What is best DB we use for desktop application using NodeJS back-end

Comments

[Uriel dos Santos Souza]

SQLite
SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine. SQLite is the most used database engine in the world. SQLite is built into all mobile phones and most computers and comes bundled inside countless other applications that people use every day

sqlite.org/index.html

[Sean Cassiere]

Honestly, it mostly comes down to what database you are familar with? and whether or not it meets the needs of your business requirements?

If you are more familar with a NoSQL style of database, then the easy choice would be MongoDB. However, if you are more into relational SQL databases, then MySQL and PostgreSQL are options hard to go wrong with.

If you do go with an SQL database and your project becomes large enough, the then a mirgration to a service such as planetscale.com would be infinitely easier with MySQL.

[Bhimashankar Javalkote]

Thank you for your valuable advice that helps me to understand which DB should I use for my project