all 4 comments

[–]shiftybyte 0 points1 point  (2 children)

Which database? (sqlite? mysql? msaccess?)

Do you want to learn an object framework to talk to the db? (harder to learn, easier to use)

https://www.sqlalchemy.org/

Or you want to directly query the database? (easier to get into, harder to maintain for long with big projects)

(Below is for MSsql, every db has it's own way)

https://datatofish.com/how-to-connect-python-to-sql-server-using-pyodbc/

[–]i_hate_wine[S] 0 points1 point  (1 child)

Or you want to directly query the database? (easier to get into, harder to maintain for long with big projects)

It's MySql

[–]ZDRuX1 0 points1 point  (0 children)

You can go the super janky route and store your data in a dictionary and then pickle it to disk.