
Tue, July 16, 2019

Various Node.js sqlite packages. What is the best?
The official implementation is actually sqlite3
, and there are at least 2 packages built on top of it -- sqlite
and TypeORM
. There are also other packages that can run SQLite including better-sqlite3
and sql.js
.
Considerations
- Easy to write / maintain
- Client-side / browser only
- Fast
- Electron.js-enabled
In my experience, it seems that, in Node.js environment, Promise-based sqlite
seems the be the best. Also, being-based on sqlite3
, it works well with Electron.js (better-sqlite3
does not work well with Node.js. sql.js
of course works, but it is not truly file-based.)
However, better-sqlite3
claims to be faster than sqlite
…
Being a TypeScript user, I am looking forward to try out TypeORM
sometime.