René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Enable the 2 new SQLite 3.51.0 amalgamation extensions.","articleBody":"Depends on #60614.\n\n### What is the problem this feature will solve?\n\n[SQLite 3.51.0](https://sqlite.org/releaselog/3_51_0.html) added 2 new extensions to the amalgamation:\n\n- [Carray](https://sqlite.org/carray.html): 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.\n\n- [Percentile](https://sqlite.org/percentile.html): 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 new `WITHIN` keyword. Also increases binary size by about 1200 bytes. See the docs for all details: https://sqlite.org/compile.html#enable_ordered_set_aggregates.\n\n\n### What is the feature you are proposing to solve the problem?\n\nEnable the Percentile extension with its compile flags.\n\nCarray usefulness should be investigated and can also be enabled via its compile-time flag.\n\n### What alternatives have you considered?\n\nMissing out on these new extensions.","author":{"url":"https://github.com/TheOneTheOnlyJJ","@type":"Person","name":"TheOneTheOnlyJJ"},"datePublished":"2025-11-07T14:36:59.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":2},"url":"https://github.com/60618/node/issues/60618"}