Repository navigation
Enable the 2 new SQLite 3.51.0 amalgamation extensions. #60618
Description
Depends on #60614.
What is the problem this feature will solve?
SQLite 3.51.0 added 2 new extensions to the amalgamation:
-
Carray: Enabled by compile-time flag
-DSQLITE_ENABLE_CARRAY. Useful for binding C-language arrays to SQL queries. I am unsure wether JS/TS can make use of this directly, but perhaps it may at least be useful for internal use in the Node.js-SQLite bindings. I am, however, not familiar enough with the code to comment on it. -
Percentile: Enabled by compile-time flag
-DSQLITE_ENABLE_PERCENTILE. Useful for extracting various statistical percentages from tables and should be faster than JS by having a native implementation. It also includes another compile time flag,-DSQLITE_ENABLE_ORDERED_SET_AGGREGATES=1, which can be set to 1 to support cross-platform SQL syntax, adding the newWITHINkeyword. Also increases binary size by about 1200 bytes. See the docs for all details: https://sqlite.org/compile.html#enable_ordered_set_aggregates.
What is the feature you are proposing to solve the problem?
Enable the Percentile extension with its compile flags.
Carray usefulness should be investigated and can also be enabled via its compile-time flag.
What alternatives have you considered?
Missing out on these new extensions.
Activity
codervipul775 commentedon Nov 8, 2025
Hey @TheOneTheOnlyJJ , I want to work on this feature. Please assign it to me.
TheOneTheOnlyJJ commentedon Jan 18, 2026
@geeksilva97
Could you please add the proper
sqlitelabel to this issue?sqlite: enable Percentile extension
sqlite: enable Percentile extension
github-actions commentedon Jul 20, 2026
This issue has been marked as stale due to 90 days of inactivity.
It will be automatically closed in 30 days if no further activity occurs. If this is still relevant, please leave a comment or update it to keep it open.
trivikr commentedon Jul 27, 2026
The
Percentileextension was added in #61295@TheOneTheOnlyJJ Are you working on adding
Carray?TheOneTheOnlyJJ commentedon Jul 27, 2026
No, I only needed
Percentilefor my work and I'm not sure howCarraycould be integrated; it looks more complicated than enabling a simple compile-time flag. I'm not sure the existing C++ codebase would benefit from havingCarray, and even if it did, I'm not sure how Node could measure and communicate that to users.Edit: It may be useful in Node internals?
sqlite: enable Percentile extension