Skip to content

New SQlite database options #58697

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
nodejs-github-bot merged 11 commits into from
Jun 24, 2025
Merged

New SQlite database options #58697

Show file tree
Hide file tree
Changes from 1 commit
Commits
Show all changes
11 commits
Select commit Hold shift + click to select a range
6836df6
sqlite: add support for readBigInts option in db connection level
miguelmarcondesf Jun 11, 2025
68889b1
sqlite: add readBigInts as env property
miguelmarcondesf Jun 12, 2025
2f589fa
sqlite: add support for returnArrays option in db connection
miguelmarcondesf Jun 12, 2025
88be767
sqlite: add support for allowBareNamedParameters option in db connection
miguelmarcondesf Jun 12, 2025
917a093
sqlite: add support for allowUnknownNamedParameters option in db conn…
miguelmarcondesf Jun 12, 2025
1aca01e
doc: document new options for database connection
miguelmarcondesf Jun 12, 2025
7f0c06b
doc: update SQLite documentation with changes
miguelmarcondesf Jun 17, 2025
d7f08c0
test: remove redundant default values tests
miguelmarcondesf Jun 18, 2025
a0d04ad
doc: fix replacemme
miguelmarcondesf Jun 18, 2025
8839375
sqllite: add Raw string literals
miguelmarcondesf Jun 18, 2025
5693d3c
test: update error messages
miguelmarcondesf Jun 18, 2025
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Prev Previous commit
Next Next commit
doc: update SQLite documentation with changes
  • Loading branch information
@miguelmarcondesf
miguelmarcondesf committed Jun 17, 2025
commit 7f0c06b9874a77d5a53010bcd6d0b52d3f734210
5 changes: 5 additions & 0 deletions doc/api/sqlite.md
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -97,6 +97,11 @@ exposed by this class execute synchronously.

<!-- YAML
added: v22.5.0
changes:
- version:
- REPLACEME
Comment thread
miguelmarcondesf marked this conversation as resolved.
Outdated
pr-url: https://github.com/nodejs/node/pull/58697
description: Add new SQLite database options.
-->

* `path` {string | Buffer | URL} The path of the database. A SQLite database can be
Expand Down
4 changes: 0 additions & 4 deletions test/parallel/test-sqlite-database-sync.js
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -196,11 +196,9 @@ suite('DatabaseSync() constructor', () => {
t.assert.strictEqual(setup, undefined);

const query = db.prepare('SELECT val FROM data');
t.assert.strictEqual(query.setReadBigInts(true), undefined);
t.assert.deepStrictEqual(query.get(), { __proto__: null, val: 42n });

const insert = db.prepare('INSERT INTO data (key) VALUES (?)');
t.assert.strictEqual(insert.setReadBigInts(true), undefined);
t.assert.deepStrictEqual(
insert.run(20),
{ changes: 1n, lastInsertRowid: 20n },
Expand All @@ -219,11 +217,9 @@ suite('DatabaseSync() constructor', () => {
t.assert.strictEqual(setup, undefined);

const query = db.prepare('SELECT val FROM data');
t.assert.strictEqual(query.setReadBigInts(false), undefined);
t.assert.deepStrictEqual(query.get(), { __proto__: null, val: 42 });

const insert = db.prepare('INSERT INTO data (key) VALUES (?)');
t.assert.strictEqual(insert.setReadBigInts(false), undefined);
t.assert.deepStrictEqual(
insert.run(20),
{ changes: 1, lastInsertRowid: 20 },
Expand Down
Loading