Database to work with nodejs

Asked

Viewed 326 times

1

I’m developing an entire application with Nodejs.

The main reasons for using Nodejs are financial/performance.

I have not yet worked with database using Nodejs, but I have some doubts, since the data load is large.

For comparison purposes, we will consider the following data:
MYSQL, Cassandra and Sqlite
Over 100,000 views daily
Database with more than 50GB of information

The issues:
High performance with Nodejs?
They have stable libraries?
High performance for large amounts of data?
High performance for a distributed database architecture?

I just want to know about the databases mentioned above and responses based on technical facts and not opinions.

mysql node.js cassandra

  • I think you should put Sqlite on the table too :)

  • @Jorgeb. Sqlite is best suited for small applications, the intention is to have in less than 2 years a database already with GB of information.

  • You are completely wrong, Sqlite is much more powerful and LIGHT than you can imagine. I have seen many people opt for Sqlite for large projects, for its simplicity and for "lightness".

  • 1

    @Jorgeb. A lot of people, can you give me a weight reference? Attention, I am not doubting your knowledge and I appreciate your time, but I like to make decisions based on solid, proven facts.

  • Take a look here: http://www.sqlite.org/famous.html and here: http://www.sqlite.org/whentouse.html

  • 1

    @Jorgeb. addoei Sqlite :)

  • @Filipe Vai de Mongodb. It is a Nosql that integrates beautifully with the high performance, flexible and low-cost hardware Nodejs.

  • @Guilhermeoderdenge I just want to limit the comparison of 3 BD that I entered in the question, if they do not close the question because it is based on opinions. I’ve considered Mongodb but eliminated after reading about the limitations.

  • Limitations? What, after all? No triggers?

  • @Guilhermeoderdenge do not know how far it is true, but see http://www.itexto.net/devkico/? p=1621

  • Take a look at the redis.

  • @Guilhermeoderdenge thank you for your time but the goal is to compare with the 3 Bds of the question, so we avoid opinions and closure of the topic.

  • Relevant: http://meta.pt.stackoverflow.com/questions/1323/a-questiona-nao-e-base-em-opinioes-mas-as-respostas-sim-porque-ser-closed. Anyone who thinks they should reopen can put their argument there. Even the author recognized the need for closure.

Show 8 more comments

2 answers

2

My answer to all these questions would be Postgresql (which is not on your list but should).

Some big players that use it are Instagram, IMDB, Macworld, Apple, Skype and meets very well in performance issues, module for Node, large amount of data and scale horizontally.

  • 1

    Thank you for your time, but your response is based on your opinion, which is not permitted by the OS. I would just like to know about a technical comparison between the 3 Bds cited.

  • Deschamps, see my comment in the other answer.

0

It depends a lot... I watch a lot lately using Mongodb with Node... and it’s very fast.. On the other hand... it will consume a lot of HD.. more in terms of performance he’s much faster than the relational... I guess you’d have to see what the real reason is... but I think Mongodb would be something to think about =)

  • 2

    Thank you for your time, but your response is based on your opinion, which is not permitted by the OS. I would just like to know about a technical comparison between the 3 Bds cited.

  • @Philip, the main problem is questions who ask only for an opinion. The OS allows me to answer whatever I feel like (as long as it is directed to solving the question). If the answer is poor, without references, etc, no problem, vote against if you wish to express disagreement. Araan, please check [Answer].

Browser other questions tagged mysql node.js cassandra

You are not signed in. Login or sign up in order to post.