What SQLite to use with nodejs What SQLite to use with nodejs sqlite sqlite

What SQLite to use with nodejs


node.js sqlite

Use https://github.com/mapbox/node-sqlite3. It's asynchronous (almost a must-have), it's the most actively maintained, and it has the most stars on GitHub.

node.js sqlite

Alternatively, you could use a javascript embedded database. This way you just need to declare the database as a dependency in your package.json and require() it in your application.

Check out NeDB (which I wrote) or nStore for example.

node.js sqlite

For my architecture synchronous better-sqlite3 appeared to be better:

https://www.npmjs.com/package/better-sqlite3

  • Full transaction support
  • Geared for performance, efficiency, and safety
  • Easy-to-use synchronous API (faster than an asynchronous API)
  • Custom SQL function support
  • 64-bit integer support (invisible until you need it)

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last