I started this project as the SQLiteDB VBA class, wrapping the ADODB library to facilitate introspection of the SQLite engine and databases. Later, I refactored the SQLiteDB class and several supporting class modules into the SQLiteADO subpackage shown on the left in Figure. SQLiteADO incorporates a set of class modules with a shared prefix Lite-. Shown on the right, the other core subpackage SQLiteC uses SQLite C-API directly (and the SQLiteC- prefix).

Library structure

While I significantly refactored the code and added some features, the package is still focused on

• database connectivity
  • SQLiteADO - ADO/SQLiteODBC connection string helpers and limited ADODB wrappers,
  • SQLiteC - alternative connectivity approach bypassing ADO/SQLiteODBC,
• validation/integrity, and
• metadata (SQL-based SQLite introspection).

See docs for further details.