SQLiteC-for-VBA
SQLite library for VBA wrapping ADODB and SQLite C-language API. (by pchemguy)
VBA-ExtendedDictionary
Dictionary object that extends the Scripting.Dictionary (by SSlinky)
| SQLiteC-for-VBA | VBA-ExtendedDictionary | |
|---|---|---|
| 1 | 8 | |
| 5 | 20 | |
| - | - | |
| 0.0 | 7.7 | |
| about 3 years ago | 11 months ago | |
| VBA | VBA | |
| 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.
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-ExtendedDictionary
Posts with mentions or reviews of VBA-ExtendedDictionary.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2021-03-23.
-
Update database with two similar workbooks
If you're working with dictionaries, this might help.
- [EXCEL] Loop theory
-
excel - pasting from dictionary into sheet1
Using u/chunkyasparagus' example values, I populated my cExtendedDictionary and dumped it to the sheet. Took at a guess, nearly a second to run.
-
Best way to query a set of data in vba?
This was one of the things my Extended Dictionary was designed to do with the AddBulk method.
- [EXCEL] Checking one data table for information relative to another one using VBA
- How do i find out how many times a duplicate value appear in a column of data?
-
Where to use class modules
An example of where I've used a class as a tool can be found here.
- [VBA] Record unique values from a collection in an array
What are some alternatives?
When comparing SQLiteC-for-VBA and VBA-ExtendedDictionary you can also consider the following projects:
VBA-SQL-Library - Object-based Database Interaction for VBA. Create SQL Statements with VBA objects instead of string concatination.
VBA-JSON-parser - Backus-Naur Form JSON Parser based on RegEx for VBA
Excel-Pomodoro-Timer - Excel Pomodoro Timer
QRCodeLibVBA - QR Code generator library in VBA
excel-formula-print - VBA macro to print formulas with variable names
VBAUnicodeTools - Tools for working with Unicode in the VB Editor