Relational Databases

Linking relational databases with hybrid solutions

ZOPYX is a recognised expert in the efficient linkage of relational databases like Oracle, MySQL or PostgreSQL with object-oriented Python and Zope applications.  The object-relational mapper SQLAlchemy is the tool primarily deployed in achieving this.  SQLAlchemy introduces an abstraction layer between the application and the database.  Operations like insert, delete, refresh and search are made directly accessible within the application via Python functions.

The removal of need for SQL expressions to be created manually eliminates a significant source of error in the linkage of relational databases with object-oriented systems.  Thus, ZOPYX is able to achieve a substantial increase in stability and productivity.

In addition, ZOPYX develops hybrid database solutions in which the advantages of a relational database are combined with those of an object-oriented ZODB.  This approach has proven its worth repeatedly in the case of e.g. multimedia databases, where metadata is held in the relational database and image data is stored as blobs in the ZODB.


Our school uses Plone for a range of purposes, including generating reports and minutes of class conferences.  We were in need of a reliable solution to manage the printing of these standard form documents, and found the product SmartPrintNG to suit our needs well on account of its flexible configurability.  Andreas Jung conducted hands-on training in which he conveyed, in a highly competent and professional manner, the necessary know-how for us to begin working with it.

Alois Mayr
Albrecht-Ernst Gynmasium, Oettingen in Bayern