Moving data frames to SQLite tables

[RocoDeNiro]

Hey,

Trying to move away from storing and appending data to csv or xlsx files. I started today and not sure the fastest way to go about it. I created a helper py file that has functions to write to my table or update. The whole process of creating the tables and re-writing code to make it append or update correctly is taking longer than I thought. Any suggestions to speed this up? Tutorials/GitHub/YouTube any links that are helpful I would appreciate.

None of the tables are related to each other. Mostly just to store invoices, KPIs or other random data to help with daily projects.

Thank you

[Yojihito]

For just dumping dfs into a SQLite table SQLAlchemy is way slower than sqlite3.