That is, you'll have a generic class hierarchy, able to access:

As a result, the SynDBExplorer sample tool is now able to select a SQLite3 database as source, in addition to the OleDB, ODBC or Oracle/OCI database types. 



Select "Sqlite3" as the database type when creating a new connection, and specify the full SQLite3 database as "Server name". Other properties (Database name, User ID, Password) are just ignored. 

The SynDBExplorer tool is a multi-tabbed software able to list all tables, and also column names and types - including indexes. It can also export all result content into csv, json, text or pdf files. And you have some popup-menus to help you enter field names or values into your SQL statement.
You can download this free tool from this direct link.

As you can see in the SynSQLite3.pas source code, adding such another Database to the SynDB classes model is just a very thin layer, calling the new shared SynSQLite3 unit.

Now I will work on integrating all those SynDB classes into our main framework, which is now named mORMot (at least in the source code).

Feedback and comments are welcome on our forum.