Skip to content

Latest commit

 

History

History
22 lines (14 loc) · 1.24 KB

README.md

File metadata and controls

22 lines (14 loc) · 1.24 KB

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

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.