SQLData

SQLData is an extension of the DB class that is meant to provide object-relational mappings to store and retrieve persistent objects in a SQL database. The class comes with additional scripts for generating classes that can be used by applications to access given database table using the SQLData class as means to store and retrieve data with SQL statements. 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. Experience has shown that the automatic generation handles about 80% of the repetitive work involved in building classes and forms. SQLData was designed to make it easy to automate the construction of the application specific classes interfacing to SQL tables. SQLData supports all databases supported by the DB class, currently MySQL and PostgreSQL 8.0 and up.