SQLiteC-for-VBA VS SQLiteForExcel

Compare SQLiteC-for-VBA vs SQLiteForExcel and see what are their differences.

SQLiteC-for-VBA

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

SQLiteForExcel

A lightweight wrapper to give access to the SQLite3 library from VBA. (by govert)
Our great sponsors
  • SonarQube - Static code analysis for 29 languages.
  • Scout APM - Less time debugging, more time building
  • SaaSHub - Software Alternatives and Reviews
SQLiteC-for-VBA SQLiteForExcel
1 1
1 214
- -
8.5 0.0
7 months ago over 1 year ago
VBA C
MIT License MIT License
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.

SQLiteC-for-VBA

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 | reddit.com/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).

SQLiteForExcel

Posts with mentions or reviews of SQLiteForExcel. 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 | reddit.com/r/vba | 13 Dec 2021
    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).

What are some alternatives?

When comparing SQLiteC-for-VBA and SQLiteForExcel you can also consider the following projects:

VBA-Better-Array - An array class for VBA providing features found in more modern languages

Rubberduck - Every programmer needs a rubberduck. COM add-in for the VBA & VB6 IDE (VBE).

excel-formula-print - VBA macro to print formulas with variable names

VBA-ExtendedDictionary - Dictionary object that extends the Scripting.Dictionary

VBA-SQL-Library - Object-based Database Interaction for VBA. Create SQL Statements with VBA objects instead of string concatination.

QRCodeLibVBA - QR Code generator library in VBA