sqlite: enable common flags by geeksilva97 · Pull Request #57621 · nodejs/node

geeksilva97 · 2025-03-25T17:51:46Z

This PR enables flags that are common to other sqlite players in Node.js ecosystem:

This is related to #56476, even though it does not enable the RBU extension.

I see this as a good step toward the stabilization since it will make it easier for people from other dependencies.

nodejs-github-bot · 2025-03-25T17:51:50Z

Review requested:

@nodejs/gyp
@nodejs/security-wg
@nodejs/sqlite

geeksilva97 · 2025-03-25T17:52:47Z

Not sure whether this will be a problem, but this increases the binary size by 600KB.

cjihrig

Not saying whether or not we should land this, but https://github.com/nodejs/node/blob/main/deps/sqlite/unofficial.gni should be updated, and there should be at least one test for each new API to prevent regressions.

geeksilva97 · 2025-03-25T17:57:11Z

Not saying whether or not we should land this, but https://github.com/nodejs/node/blob/main/deps/sqlite/unofficial.gni should be updated, and there should be at least one test for each new API to prevent regressions.

Good point. Also, I think it would be good to have some benchmarks on sqlite implementations.

geeksilva97 · 2025-03-25T19:23:09Z

Not saying whether or not we should land this, but https://github.com/nodejs/node/blob/main/deps/sqlite/unofficial.gni should be updated, and there should be at least one test for each new API to prevent regressions.

@cjihrig , what's the difference between .gyp and .gni file?

test/parallel/test-sqlite.js

cjihrig · 2025-03-25T19:30:37Z

what's the difference between .gyp and .gni file?

They are for two different build systems. The .gyp file is used by the official build. The .gni file is used by the unofficial GN build.

geeksilva97 · 2025-03-25T19:32:39Z

what's the difference between .gyp and .gni file?

They are for two different build systems. The .gyp file is used by the official build. The .gni file is used by the unofficial GN build.

Thank you!

cjihrig · 2025-03-25T19:42:35Z

even though it does not enable the RBU extension.

Why not? And why not the Geopoly extension?

geeksilva97 · 2025-03-25T20:16:35Z

even though it does not enable the RBU extension.

Why not? And why not the Geopoly extension?

For RBU, I didn't see it in better-sqlite3 or node-sqlite3. Geopoly seems like a good extension to have.

geeksilva97 · 2025-03-25T20:26:06Z

even though it does not enable the RBU extension.

Why not? And why not the Geopoly extension?

For RBU, I didn't see it in better-sqlite3 or node-sqlite3. Geopoly seems like a good extension to have.

On the other hand, the issue mentions the SQLite Amalgamation. I think we could have RBU enabled.

The amalgamation contains everything you need to integrate SQLite into a larger project

codecov · 2025-03-25T21:55:59Z

Codecov Report

All modified and coverable lines are covered by tests ✅

Project coverage is 90.23%. Comparing base (1b5b019) to head (c22f75e).
Report is 69 commits behind head on main.

Additional details and impacted files

@@            Coverage Diff             @@
##             main   #57621      +/-   ##
==========================================
+ Coverage   90.22%   90.23%   +0.01%     
==========================================
  Files         630      630              
  Lines      185054   185055       +1     
  Branches    36254    36219      -35     
==========================================
+ Hits       166963   166985      +22     
- Misses      11032    11037       +5     
+ Partials     7059     7033      -26

see 45 files with indirect coverage changes

🚀 New features to boost your workflow:

❄️ Test Analytics: Detect flaky tests, report on failures, and find test suite problems.
📦 JS Bundle Analysis: Save yourself from yourself by tracking and limiting bundle sizes in JS merges.

TheOneTheOnlyJJ

Small typo

test/parallel/test-sqlite.js

cjihrig

One comment, but changes LGTM.

test/parallel/test-sqlite.js

Co-authored-by: Colin Ihrig <cjihrig@gmail.com>

TheOneTheOnlyJJ · 2025-03-26T14:05:52Z

test/parallel/test-sqlite.js

+    );
+  });
+
+  test('fts3 parenthesis', (t) => {


This is inconsistent with the rest, missing is enabled in its name.

test/parallel/test-sqlite.js

cjihrig

Still unsure whether or not we want all of these enabled, but giving this a LGTM so it's not stalled.

TheOneTheOnlyJJ · 2025-04-03T20:22:06Z

Still unsure whether or not we want all of these enabled, but giving this a LGTM so it's not stalled.

I really hope they land. Not having them enabled limits the usefulness of the library a lot.

bakkot · 2025-04-03T20:28:39Z

I personally don't care about the other ones but I'm really hoping FTS5 specifically lands.

TheOneTheOnlyJJ · 2025-04-03T20:40:04Z

I personally don't care about the other ones but I'm really hoping FTS5 specifically lands.

This is why, for all the various use cases various projects have, they should all be included. 😊

cjihrig · 2025-04-04T16:46:23Z

Just noting that this is ready to land. It just needs one person who believes in this change strongly enough to put the commit-queue label on it.

geeksilva97 · 2025-04-04T16:48:29Z

Let's do this!

nodejs-github-bot · 2025-04-04T16:57:45Z

Landed in 9aa57bf

PR-URL: nodejs#57621 Reviewed-By: Colin Ihrig <cjihrig@gmail.com>

PR-URL: #57621 Reviewed-By: Colin Ihrig <cjihrig@gmail.com>

nodejs-github-bot added dependencies Pull requests that update a dependency file. needs-ci PRs that need a full CI run. sqlite Issues and PRs related to the SQLite subsystem. labels Mar 25, 2025

geeksilva97 force-pushed the enable-common-sqlite-flags branch from e4b93b9 to 9590dee Compare March 25, 2025 17:53

cjihrig reviewed Mar 25, 2025

View reviewed changes

geeksilva97 force-pushed the enable-common-sqlite-flags branch from 9590dee to 0c1ec86 Compare March 25, 2025 19:22

geeksilva97 commented Mar 25, 2025

View reviewed changes

test/parallel/test-sqlite.js Outdated Show resolved Hide resolved

geeksilva97 force-pushed the enable-common-sqlite-flags branch from 0c1ec86 to 31c5aa5 Compare March 25, 2025 19:28

TheOneTheOnlyJJ reviewed Mar 26, 2025

View reviewed changes

test/parallel/test-sqlite.js Outdated Show resolved Hide resolved

sqlite: enable common flags

3f64dfa

geeksilva97 force-pushed the enable-common-sqlite-flags branch from 31c5aa5 to 3f64dfa Compare March 26, 2025 13:49

geeksilva97 commented Mar 26, 2025

View reviewed changes

test/parallel/test-sqlite.js Show resolved Hide resolved

cjihrig reviewed Mar 26, 2025

View reviewed changes

test/parallel/test-sqlite.js Outdated Show resolved Hide resolved

sqlite: apply review change

c22f75e

Co-authored-by: Colin Ihrig <cjihrig@gmail.com>

TheOneTheOnlyJJ reviewed Mar 26, 2025

View reviewed changes

test/parallel/test-sqlite.js Outdated Show resolved Hide resolved

TheOneTheOnlyJJ mentioned this pull request Mar 26, 2025

Add dbhash and sqldiff utilities as JS APIs for working with SQLite #57637

Closed

cjihrig approved these changes Apr 3, 2025

View reviewed changes

cjihrig added the request-ci Add this label to start a Jenkins CI on a PR. label Apr 3, 2025

github-actions bot removed the request-ci Add this label to start a Jenkins CI on a PR. label Apr 3, 2025

cjihrig added the commit-queue-squash Add this label to instruct the Commit Queue to squash all the PR commits into the first one. label Apr 3, 2025

geeksilva97 added the commit-queue Add this label to land a pull request using GitHub Actions. label Apr 4, 2025

nodejs-github-bot removed the commit-queue Add this label to land a pull request using GitHub Actions. label Apr 4, 2025

nodejs-github-bot merged commit 9aa57bf into nodejs:main Apr 4, 2025
67 checks passed

cjihrig mentioned this pull request Apr 4, 2025

Enable all SQLite extensions that do not require code changes. #56476

Closed

JonasBa pushed a commit to JonasBa/node that referenced this pull request Apr 11, 2025

sqlite: enable common flags

6c4a8c2

PR-URL: nodejs#57621 Reviewed-By: Colin Ihrig <cjihrig@gmail.com>

RafaelGSS pushed a commit that referenced this pull request May 1, 2025

sqlite: enable common flags

c5eb647

PR-URL: #57621 Reviewed-By: Colin Ihrig <cjihrig@gmail.com>

RafaelGSS mentioned this pull request May 1, 2025

2025-05-06, Version 24.0.0 (Current) #57609

Merged

RafaelGSS pushed a commit that referenced this pull request May 2, 2025

sqlite: enable common flags

064e0eb

PR-URL: #57621 Reviewed-By: Colin Ihrig <cjihrig@gmail.com>

aduh95 mentioned this pull request May 3, 2025

sqlite: enable Geopoly, Math functions and RBU extensions NixOS/nixpkgs#403958

Merged

13 tasks

aduh95 pushed a commit that referenced this pull request May 6, 2025

sqlite: enable common flags

ee0891d

PR-URL: #57621 Reviewed-By: Colin Ihrig <cjihrig@gmail.com>

aduh95 pushed a commit that referenced this pull request May 6, 2025

sqlite: enable common flags

c92647b

PR-URL: #57621 Reviewed-By: Colin Ihrig <cjihrig@gmail.com>

RafaelGSS pushed a commit that referenced this pull request May 14, 2025

sqlite: enable common flags

61743f1

PR-URL: #57621 Reviewed-By: Colin Ihrig <cjihrig@gmail.com>

aduh95 pushed a commit that referenced this pull request May 16, 2025

sqlite: enable common flags

05172fd

PR-URL: #57621 Reviewed-By: Colin Ihrig <cjihrig@gmail.com>

aduh95 pushed a commit that referenced this pull request May 17, 2025

sqlite: enable common flags

95d8cf4

PR-URL: #57621 Reviewed-By: Colin Ihrig <cjihrig@gmail.com>

aduh95 pushed a commit that referenced this pull request May 17, 2025

sqlite: enable common flags

11723e4

PR-URL: #57621 Reviewed-By: Colin Ihrig <cjihrig@gmail.com>

aduh95 pushed a commit that referenced this pull request May 17, 2025

sqlite: enable common flags

dc98f2e

PR-URL: #57621 Reviewed-By: Colin Ihrig <cjihrig@gmail.com>

aduh95 pushed a commit that referenced this pull request May 18, 2025

sqlite: enable common flags

3fd205c

PR-URL: #57621 Reviewed-By: Colin Ihrig <cjihrig@gmail.com>

github-actions bot mentioned this pull request May 19, 2025

2025-05-21, Version 22.16.0 'Jod' (LTS) #58388

Merged

aduh95 pushed a commit that referenced this pull request May 19, 2025

sqlite: enable common flags

ed9d2fd

PR-URL: #57621 Reviewed-By: Colin Ihrig <cjihrig@gmail.com>

geeksilva97 deleted the enable-common-sqlite-flags branch May 20, 2025 00:46

ghost mentioned this pull request Jun 8, 2025

### Notable Changes autofix-ci/action#28

Closed

TheOneTheOnlyJJ mentioned this pull request Jul 12, 2025

fix: missing SQLite builtin support in Node.js electron/electron#47706

Merged

3 tasks

TheOneTheOnlyJJ mentioned this pull request Jan 6, 2026

sqlite: enable Percentile extension #61295

Merged

Uh oh!

Conversation

geeksilva97 commented Mar 25, 2025 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Uh oh!

nodejs-github-bot commented Mar 25, 2025

Uh oh!

geeksilva97 commented Mar 25, 2025

Uh oh!

cjihrig left a comment

Choose a reason for hiding this comment

Uh oh!

geeksilva97 commented Mar 25, 2025

Uh oh!

geeksilva97 commented Mar 25, 2025

Uh oh!

Uh oh!

cjihrig commented Mar 25, 2025

Uh oh!

geeksilva97 commented Mar 25, 2025

Uh oh!

cjihrig commented Mar 25, 2025

Uh oh!

geeksilva97 commented Mar 25, 2025 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Uh oh!

geeksilva97 commented Mar 25, 2025 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Uh oh!

codecov bot commented Mar 25, 2025 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Codecov Report

Uh oh!

TheOneTheOnlyJJ left a comment

Choose a reason for hiding this comment

Uh oh!

Uh oh!

Uh oh!

cjihrig left a comment

Choose a reason for hiding this comment

Uh oh!

Uh oh!

TheOneTheOnlyJJ Mar 26, 2025

Choose a reason for hiding this comment

Uh oh!

Uh oh!

cjihrig left a comment

Choose a reason for hiding this comment

Uh oh!

TheOneTheOnlyJJ commented Apr 3, 2025

Uh oh!

bakkot commented Apr 3, 2025

Uh oh!

TheOneTheOnlyJJ commented Apr 3, 2025

Uh oh!

cjihrig commented Apr 4, 2025

Uh oh!

geeksilva97 commented Apr 4, 2025

Uh oh!

Uh oh!

nodejs-github-bot commented Apr 4, 2025

Uh oh!

Reviewers

Assignees

Labels

Projects

Milestone

Development

Uh oh!

5 participants

geeksilva97 commented Mar 25, 2025 •

edited

Loading

geeksilva97 commented Mar 25, 2025 •

edited

Loading

geeksilva97 commented Mar 25, 2025 •

edited

Loading

codecov bot commented Mar 25, 2025 •

edited

Loading