- Files
- DB-API II
- Qt SQL and Data-Aware Widgets
- Gadfly
- Object Databases
- Object-Relational Mappers
- A Simple GUI Using PyQt's Data-Aware Objects
Object-Relational Mappers
One wheel that has been invented time and time again is the object-relational mapping. This is code that either takes Python objects and prepares them for storage in a relational database, or code that takes the data model of a relational database and constructs Python objects from it.
An example of the first approach is discussed in Joel Shprentz's article "Persistent Storage of Python Objects in Relational Databases." I developed the second idea in dbObj (see http://www.valdyas.org/python/dbobj.html), together with a library that takes the repository and automatically creates PyQt-based data-aware forms and table views.