CODEWITHSUNDEEP
sqlitedifferencebetter-sqlite3
hellomynameisA
hellomynameisA

Reputation: 634

Difference between sqlite and better-sqlite3 implementation

What's the difference between sqlite and better-sqlite3 implementations? I have to use better-sqlite3 to create a database for a form (+ only node.js and express), but the only clear example I found uses sqlite. Is there any difference? If not, thanks. Otherwise, do you know any usefull links for databases and forms with better-sqlite3? Thanks

Upvotes: 5

Views: 10430

Answers (2)

user5997038
user5997038

Reputation:

In better-sqlite3, you can register custom functions and aggregate functions written in JavaScript, which you can run from within SQL queries.

In better-sqlite3, you can iterate through the cursor of a result set, and then stop whenever you want (you don't have to load the entire result set into memory).

In better-sqlite3, you can conveniently receive query results in many different formats (here, here, and here).

In better-sqlite3, you can safely work with SQLite's 64-bit integers, without losing precision due to JavaScript's number format.

See https://github.com/JoshuaWise/better-sqlite3/issues/262

Upvotes: 10

Matthias Reissner
Matthias Reissner

Reputation: 355

One important difference is: better-sqlite allows for synchronous SQLite queries. With sqlite, you can't do that.

Upvotes: 2

Related Questions