DBGen & CDE DB Generation & Cross Database Engine

Database Generation

Our database generation infrastructure allows us to update software fast and effectively directly from a database structure. This enables us to perform software updates and improvements at a rapid pace without resulting in offline time of your web application.

Cross Database Engine

Often we needed to use data from another database in existing applications and making a common class which encapsulates the database connection and queries makes this easier. One thing that we am working on is making the translation of the different SQL dialects a reality so that an application developed in MySQL will port directly to Firebird or Oracle without having to change the SQL statements. 

Those new to PHP and database access via PHP will find that this library is a good place to start in obtaining a solution with the databases provided. One can test a couple of databases without even changing the code! Developers in the Open Source community wanting to make their applications friendly for porting between databases should want to use the Cross Database Engine in their applications making it easier for others to port the applications.

Different SQL dialects make this difficult and merely renaming ibase_query to mysql_query does not work! With this in mind the goals for the CDE Engine are as follows:

• Write code in PHP once for any database platform
• Support all PHP database connectivity
• One set of database functions connects to any database (What order does the db handle fall in ibase_connect and mysql_connect?)
• Make PHP database development simple