I have been working on a project aimed at producing custom SQLite builds on Windows, and I would like to share my scripts (see project repo) and insights (see project docs). I would be happy to provide binaries to anyone interested (the repo only contains scripts). I would also be interested in any relevant feedback.

The project explores the building process of the SQLite library and the SQLiteODBC driver on Windows with two toolchains (MS VC++ Build Tools (MSVC) and MSYS2/MinGW) and a particular focus on customizing and extending it. The project repository hosts several scripts producing custom SQLite/SQLiteODBC builds with extended functionality, and these scripts can be further tailored to specific needs.

Features:

  • ICU enabled builds
  • STDCALL x32 build for direct access from VBA
  • Integrated extensions enabled by default
  • Extra extensions integrated with the core
  • SQLiteODBC driver embedding current SQLite release with all features enabled
  • Dependencies bundled together with SQLite binaries
  • MSVC Build Tools and MSYS2/MinGW shell scripts