-
Complete project source code with dependencies is available from the GitHub repo and the project documentation - from the GitHub pages site. I perform unit testing under x32/VBA6 (Excel XP/2002 SP3) and x64/VBA7 (Excel 2016) environments. With the entire repository cloned on Windows 10 and the two dependencies (the SQLiteODBC driver and the RubberDuck VBA add-in) installed, the following two quick checks can be executed right away from the immediate pane. This command ?LiteMan(":mem:").ExecADO.GetScalar("SELECT sqlite_version()") returns SQLite library version used by the SQLiteODBC driver (usually embedded), e.g., 3.23.3, and this command ?SQLiteC("").CreateConnection(":mem:").ExecADO.GetScalar("SELECT sqlite_version()") returns SQLite library version loaded by the project, e.g., 3.37.0. The project also includes a set of examples, which should also run out-of-the-box (see documentation).
-
CodeRabbit
CodeRabbit: AI Code Reviews for Developers. Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.
-
The SQLiteC subpackage uses custom compiled x32 and x64 SQLite binaries for Windows, with all extensions, including ICU, enabled (included in the repository). The SQLiteODBC driver is the other dependency (its bitness must match that of the used Excel version, and it must be installed on the target machine) used by the SQLiteADO subpackage. This project unit testing relies on the RubberDuck VBA framework. Because of early bindings, this add-in must also be installed (it does not require admin privileges).
-
The SQLiteCAdo library is a VBA middleware facilitating access to SQLite databases. Its two subpackages provide alternative connectivity options: via ADODB/SQLiteODBC and directly via the C-language API. My earlier project, SQLiteDB, is the predecessor of the SQLiteADO subpackage. The SQLite For Excel VBA module, in turn, served as an inspiration for the other major component of the library, SQLiteC (Fig. 1).
