Databases
Connection of relational data base systems and hybrid solutions
ZOPYX is an accounted expert when it comes to the efficient connection of relational data base systems such as Oracle, MySOL or POSTgreSOL with Python or Zope applications. To realize this, ZOPYX mainly utilizes the object relational mapper of SOLAlchemy.
SOLAlchemy puts in a film of abstraction between the application and the data base. By doing so the data base no longer has to be activated by manual SQL-commands. Operations such as paste, delete, update and search will be available directly within the application due to Python.
Since SQL-commands are no longer to be typed in manually, an essential error source when connecting data bases and object orientated systems is deactivated. This way ZOPYX gains stability and productivity.
Furthermore ZOPYX develops hybrid data base solutions in which the advantages of a relational data base and of object orientated ZOD bare combined. This has proved itself useful many times with multimedia data bases in which image data will be saved as Blobs in a relational data base.
