Database

Drake CMS uses ADOdb Lite as its database abstraction layer.

DKDB SQL format

Drake CMS uses internally a special format for its SQL data; this is the general specification of such format:

The SQL data is re-encoded (and correctly escaped) for the target database system by Drake CMS itself; following the above DKDB SQL standard format you will allow maximum portability between different database systems.

Note: the DKDB SQL format is used natively by Gladius DB; strings will be re-encoded for each database system upon import

SQL constraints

In order to avoid incompatibilities it is suggested to use a plain simple syntax as most compliant to SQL92 as possible, but taking in account the following:

Related pages