Enable the 2 new SQLite 3.51.0 amalgamation extensions.
还没有人认领这个 Issue。
- 主要语言
- JavaScript
- 星标
- 122k
- 派生
- 37.4k
- 平均合并
- 4 天 3 小时
- 30 天内合并 PR
- 272
描述
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.
贡献指南
从这里开始
- 先读完整个 Issue,再读项目的贡献指南。
- 在 Issue 下留言说明你要接手 —— 这能避免两个人做同样的事。
- Fork 仓库,在一个分支上完成修改。
- 提交 Pull Request,并在描述里引用这个 Issue 编号。
调研方向
首先检查依赖项 #60614 以及 Node.js SQLite amalgamation 集成。确认如何提供编译时标志,然后评估启用 SQLITE_ENABLE_PERCENTILE、SQLITE_ENABLE_ORDERED_SET_AGGREGATES 和 SQLITE_ENABLE_CARRAY;当预期的扩展已启用且其支持已得到验证时,即表示完成。
由索引模型根据 Issue 内容生成。
评估
- 技术栈
- c, node.js, sqlite
- 领域
- backend, databases
- Issue 类型
- 功能
- 难度
- 4/5
- 预计耗时
- 3-5 天
- 活跃度
- 冷清
- 描述清晰度
- 基本清楚
- 新手友好度
- 43/100