Transactions for SQLite

[sant123]

Hello, I haven’t found a discussion neither an issue that talks about the support for transactions. Is this something Node.js will/would support in the future?

This is how better-sqlite3 uses it: https://github.com/WiseLibs/better-sqlite3/blob/master/docs/api.md#transactionfunction---function

Thanks 🙏🏼

Originally posted by @sant123 in #57396

[targos]

We can certainly discuss the addition of features like that one to make the API more ergonomic, but you can already do transactions using SQL statements: https://sqlite.org/lang_transaction.html

There are some examples in https://github.com/nodejs/node/blob/a0139e06a0754058ffd891f779be55584665f8a8/test/parallel/test-sqlite-transactions.js

@nodejs/sqlite

[sant123]

Thanks @targos, I’m going to give it a try 🙏🏼

[sant123]

This is my code and perfectly worked:

import { DatabaseSync } from "node:sqlite";
const db = new DatabaseSync(":memory:");

db.exec(`CREATE TABLE people (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  birthdate TEXT NOT NULL
) STRICT`);

const insertPeople = db.prepare(`
  INSERT INTO people
    (name, birthdate)
  VALUES
    (:name, :birthdate)
  `);

insertPeople.run({ name: "Flash", birthdate: "1956-07-16" });

db.exec("BEGIN TRANSACTION");
insertPeople.run({ name: "Bruno", birthdate: "1962-12-11" });
db.exec("ROLLBACK");

insertPeople.run({ name: "Bruce", birthdate: "1963-06-17" });

const people = db.prepare("SELECT * FROM people").all();

console.log(people);

[
  [Object: null prototype] {
    id: 1,
    name: 'Flash',
    birthdate: '1956-07-16'
  },
  [Object: null prototype] {
    id: 2,
    name: 'Bruce',
    birthdate: '1963-06-17'
  }
]

Thanks a lot @targos for pointing this out.