search

WiseLibs / better-sqlite3

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

Supporting `generate_series` ? #1126

Closed rob-gordon closed 3 months ago

rob-gordon commented 6 months ago

Unless I'm doing something wrong better-sqlite3 doesn't support generate_series

Is this true? And if so, are there any plans to support it in the future?

Thanks!

Prinzhorn commented 6 months ago

If by "doesn't support" you mean that it isn't compiled into the SQLite build that ships with better-sqlite3 then no.

Other than that, you should be able to compile and then db.loadExtension it.

From what I can see there is no SQLITE_ENABLE_SERIES=1 configuration we could just switch on like we do with other extensions such as SQLITE_ENABLE_JSON1 https://github.com/WiseLibs/better-sqlite3/blob/master/docs/compilation.md#bundled-configuration