SQLite library for VBA wrapping ADODB and SQLite C-language API. (by pchemguy)

SQLiteC-for-VBA Alternatives

Similar projects and alternatives to SQLiteC-for-VBA

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a better SQLiteC-for-VBA alternative or higher similarity.

SQLiteC-for-VBA reviews and mentions

Posts with mentions or reviews of SQLiteC-for-VBA. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2021-12-13.
  • [EXCEL] SQLite C/ADO VBA library with reflection
    3 projects | /r/vba | 13 Dec 2021
    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).


Basic SQLiteC-for-VBA repo stats
over 1 year ago
Collect and Analyze Billions of Data Points in Real Time
Manage all types of time series data in a single, purpose-built database. Run at any scale in any environment in the cloud, on-premises, or at the edge.