What is the best relational database for node.js?

Question

I do not see a lot of conversation about node.js and relational databases. what am I missing?? thank you.

Answer 1

I have seen several projects with SQLite, MySQL and SQL Server. Basically you're not missing anything, you just have to find a driver for your database, make the connections and start working.

In the same way I have not seen that there is a database that can be considered standard. The choice is always made by the developer based on the requirements of the application

Answer 2

Node.js is best to handle with NoSql database connection eg. Mongodb. Their syntax is similar, one use Javascript and the other uses Json.

Answer 3

thanks Calvin. But that's what I'm afraid of. I'm an old relational-database person. I eat sleep and dream in relational database. I want to know which relational database works best with node.js. I do not want to have to convert my data to Json first. But I'm willing to do that if that is the best/ most popular way. but I'm definitely going to store my data in a relational database permanently even if I have to convert it to Json before it goes to a web page. That is a core value of mine. thoughts?

Answer 4

can anyone speak specifically to relational databases and node.js? thanks.

Answer 5

Hi Lisa F did you found YOUR RDB pick for Nodejs, I am curious as well?

I think we will have to decide based on 2 factors.

# js friendliness
Sqllite, plain JSON file (i wrote basic validation and CRUD for using plain JSON it was a cool experiment)

#speed, performance
Redis, mariadb

Postgre is getting popular as well, I got to know it by working on heroku(plug and play paas cloud platform) they offer free Postgre dbs for testing.

I personally love mongodb right now, people say its bloated and slow.

But i love that its more application centric and not data centric so very easy to model unlike in Sql, so really awesome when we start and datasets are not completely known , we can always move to other db later.

If indexing and setup is done right i think it ll beat many Sql s ( it would be a cool experiment)

Answer 6

Hi Lisa F and Morpheus
You could integrate a SQL database through Sequelize.js
Check out the getting started tutorial here: http://docs.sequelizejs.com/manual/installation/getting-started

Answer 7

morpheus unfortunately no. Although node.js is so tempting, until I can connect it to a relational database with the same ease that I can use php and sql/mysql I'm sticking with the tried and true.
Properly structured relational databases have been at the heart of all of my application successes and poorly designed databases have been at the heart of all of my failures.
So I have to start there...

Answer 8

Best is a word that rarely applies to different languages in programming because they all have pros and cons depending on what you are trying to do. Language A may be best for Project 1 but for Project 2 you find Languange B is best. Same with databases. They all do essentially the same thing. Some are a little harder to learn than others. Some have some requirements others don't. It's up to you to pick which is best for you and the project.