Asynchronous better-sqlite3?

[hyunbinseo]

According to the better-sqlite3 documentation, it provides a synchronous API.

Easy-to-use synchronous API (better concurrency than an asynchronous API... yes, you read that correctly)

const db = require('better-sqlite3')('foobar.db', options);

const row = db.prepare('SELECT * FROM users WHERE id = ?').get(userId);
console.log(row.firstName, row.lastName, row.email);

Regarding this, would there be a performance difference in Drizzle ORM's async and sync APIs?

// Asynchronous
const result = await db.select().from(users);

// Synchronous
const result = db.select().from(users).all();
const result = db.select().from(users).get();
const result = db.select().from(users).values();
const result = db.select().from(users).run();

---

better-sqlite3 does support worker threads. Would this be advised in a Node.js server?

For most applications, better-sqlite3 is fast enough to use in the main thread without blocking for a noticeable amount of time. However, if you need to perform very slow queries, you have the option of using worker threads to keep things running smoothly.