Create tables for either MySQL OR SQLite

[moonfloof]

Currently, table creation SQL syntax is only specified for SQLite, however if Microlight is to support MySQL as well (and even PostgreSQL?), the syntax needs to support both formats.

[pwFoo]

Would be nice to have backend plugins to switch between mysql, sqlite or write custom functions to load / save / update data? For example to call a framework function to do the job instead of just talk to a database backend directly?

[moonfloof]

Ooh, that is something I hadn't considered. There is a lot of code I want to change that I wrote last year, and that could possibly be part of it!

[pwFoo]

Could be a way to use your project to include to a framework / cms / website... Don't know how good / easy that would work. But should be good to consider...