Task #132

Use SQLite as database backend

Added by Andreas Schröder about 8 years ago. Updated almost 8 years ago.

Status:NewStart date:06/14/2010
Priority:NormalDue date:
Assignee:-% Done:


Target version:0.65.0


from http://zetcode.com/wxpython/databases/:
Starting from Python 2.5.x series, an SQLite library is included in the python language. SQLite is a small embeddable library. This means that programmers can integrate the libraty inside their applications. No server is needed to work with SQLite. Therefore SQLite is also called a zero-configuration SQL database engine.


#1 Updated by Ruben Lopez almost 8 years ago

I also find this really usefull. Most of the time, when our master crashes (or light goes off), the database gets corrupted or simply lost, and there is no easy way to recover it. Currently we are doing database backups by querying the job list with python and recovering them by resending the jobs also via a script.
SQLite would enable easier database backups, more robust, and over all, we would be able to inspect these backups and determine if they are corrupt before using them.

I vote this up! :)

Also available in: Atom PDF