SQLiteC-for-VBA
SQLite library for VBA wrapping ADODB and SQLite C-language API. (by pchemguy)
VBA-SQL-Library
Object-based Database Interaction for VBA. Create SQL Statements with VBA objects instead of string concatination. (by Beakerboy)
| SQLiteC-for-VBA | VBA-SQL-Library | |
|---|---|---|
| 1 | 2 | |
| 5 | 78 | |
| - | - | |
| 0.0 | 4.4 | |
| over 3 years ago | 10 months ago | |
| VBA | VBA | |
| 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.
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
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).
VBA-SQL-Library
Posts with mentions or reviews of VBA-SQL-Library.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2021-04-16.
-
A VBA Project for Unit testing VBA with VBA. Please review, test, use, improve!
I'm willing to merge in any pull requests anyone can come up with. I use this library to run all the tests on VBA-SQL-Library.
-
stdEnumerator - Enumerate and manipulate any collection/array/class with very few statements
VBA-SQL-Library/SQLUnitTests.bas at master · Beakerboy/VBA-SQL-Library (github.com)
What are some alternatives?
When comparing SQLiteC-for-VBA and VBA-SQL-Library you can also consider the following projects:
VBA-ExtendedDictionary - Dictionary object that extends the Scripting.Dictionary
stdVBA - VBA Standard Library - A Collection of libraries to form a common standard layer for modern VBA applications.
Excel-Pomodoro-Timer - Excel Pomodoro Timer
QRCodeLibVBA - QR Code generator library in VBA
excel-formula-print - VBA macro to print formulas with variable names
vba-macros - Some VBA macros for personal use