SQLData is an extension of the dm.DB class. SQLData provides object-relational mappings to store and retrieve persistent objects in an SQL database. SQLData comes with additional scripts for generating classes to be used by applications to access given database tables using the SQLData class.

These scripts are meant to run from the command line. They retrieve the definitions of a given database table and then the generate classes to access the table rows as objects or to manipulate them via Web forms. They will generate classes and forms for any SQL database supported by dm.DB.

Experience has shown that the automatic generation handles about 80% of the repetitive work involved in building classes and forms for MySQL tables.

SQLData was designed to make it easy to automate the construction of the application specific classes interfacing to SQL tables. dm.DB provides a RDBMS independent access layer so, in principle, SQLData can be used by any database supported by dm.DB.

This script is officially compatible with PHP 5. SQL Data is a major revision to SQLData which now supports all databases supported by dm.DB.