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.
I think you should put Sqlite on the table too :)
– Jorge B.
@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.
– Filipe Moraes
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".
– Jorge B.
@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.
– Filipe Moraes
Take a look here: http://www.sqlite.org/famous.html and here: http://www.sqlite.org/whentouse.html
– Jorge B.
@Jorgeb. addoei Sqlite :)
– Filipe Moraes
@Filipe Vai de Mongodb. It is a Nosql that integrates beautifully with the high performance, flexible and low-cost hardware Nodejs.
– Guilherme Oderdenge
@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.
– Filipe Moraes
Limitations? What, after all? No triggers?
– Guilherme Oderdenge
@Guilhermeoderdenge do not know how far it is true, but see http://www.itexto.net/devkico/? p=1621
– Filipe Moraes
Take a look at the redis.
– Guilherme Oderdenge
@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.
– Filipe Moraes
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.
– Maniero