search

WiseLibs / better-sqlite3

The fastest and simplest library for SQLite3 in Node.js.
MIT License
5.37k stars 394 forks source link

Custom build docs do not specify a minimum sqlite version #1019

Closed kgilmer closed 1 year ago

kgilmer commented 1 year ago

I want to know the minimum sqlite version required for use with better-sqlite3. I notice this documentation which describes how to build against a user-specified version, however there is no info about what versions may be supported. Does this mean that all features of better-sqlite3 are usable from the initial alpha release in May of 2000? Some newer version is required?

JoshuaWise commented 1 year ago

An exact answer is hard to provide because better-sqlite3 is regularly updated with new features that may depend on the most recent version of SQLite. After doing a quick, manual scan, I'll say that better-sqlite3 should currently work with SQLite version 3.31.0 or later, but that's not guaranteed for future versions of better-sqlite3.

In general, you are expected to use the latest version of SQLite. The main purpose of supporting custom builds is to support defining your own compile-time options and to support encryption-enabled forks of SQLite.