[EXCEL] SQLite C/ADO VBA library with reflection

This page summarizes the projects mentioned and recommended in the original post on /r/vba

InfluxDB - Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
www.influxdata.com
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured
  • SQLiteC-for-VBA

    SQLite library for VBA wrapping ADODB and SQLite C-language API.

  • 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).

  • Rubberduck

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

  • 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).

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo
  • SQLiteForExcel

    A lightweight wrapper to give access to the SQLite3 library from VBA.

  • 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).

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts

  • Rubberduck – A free and open-source VBIDE add-in

    1 project | news.ycombinator.com | 25 Jan 2024
  • In a world that runs on Excel, why should I as an engineer learn python?

    1 project | /r/AskEngineers | 11 May 2023
  • Code Review - Is this clean code?

    2 projects | /r/vba | 9 Feb 2023
  • Is it for bath time?

    1 project | /r/ProgrammerHumor | 10 Nov 2022
  • Open source projects looking for contributors

    2 projects | /r/dotnet | 10 Nov 2022