I'd like to suggest sqlalchemy as a great alternative.
It does a lot of background tasks for you automatically.
Basics are simple to learn.
I have a tutorial on this forum here: https://python-forum.io/Thread-SqlAlchem...-Data-Load.
In a nutshell, you build a model which includes a class for each table, and import that model whenever a project needs access to your database.
Whenever you make an update (like adding a new column), the model will create the column for you (if you wish) and every module where that table is used will immediately have access (through the model) to the new data in that column.
It does a lot of background tasks for you automatically.
Basics are simple to learn.
I have a tutorial on this forum here: https://python-forum.io/Thread-SqlAlchem...-Data-Load.
In a nutshell, you build a model which includes a class for each table, and import that model whenever a project needs access to your database.
Whenever you make an update (like adding a new column), the model will create the column for you (if you wish) and every module where that table is used will immediately have access (through the model) to the new data in that column.