I am developing application using node.js. In that I am willing to use SQLite as embedded database. I searched online for SQLite npm modules. I found various modules:
From documentation and other sources, I understood that (1) operates synchronously, while (2) and (3) works asynchronously. So, I dropped the plan to use (1).
Now, I want to know what is the difference between (2) and (3) and which one should be preferred? I googled a lot but could not find much to help.
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.
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.