1
The question may be a little generic but I don’t know how to be more specific. When to use a nosql database and when to use an sql?
90% of banks or more have relationships.
clientes se relacionam com vendas, vendas com produtos, produtos com estoques, estoques com empresas. Therefore, there are tables to create the main ones in the cited example: clientes,empresas,produtos, and auxiliary tables that will communicate between the other tables, in this case, vendas that will have the id_cliente,id_empresa,id_venda,total,desconto and another table taking with the id_venda and the id_produto. Well, this would be more or less a relational world. But how would I apply it in a nosql world or why would I apply it?
It would be redundant and outside the applicability of a nosql if I did:
{
   empresas: [
      {empresa1: {
            razao_social: "",
            produtos: [{produto1: {nome: "",}}, {produto2: {nome: "",}}]
      }
   ],
   clientes: ["mesmo modelo de empresas"],
   vendas: [
      {venda1: {cliente_id: 111, empresa_id: 222, produto_id: 333}}
   ]
}
So, the question is: at which moment should I use a nosql and practically, the whole bank has relationship between the tables?
Felipe, does she already answer? If not, then be more specific.
– Maniero
It also has these: In what kind of application can I use Mongodb? ... JS node - Mongodb x Mysql
– NoobSaibot
Related has: https://answall.com/q/14533/101, https://answall.com/q/96409/101, https://answall.com/q/203857/101, https://answall.com/q/295902/101, https://pt.overfstacklow.com/q/216855/101, https://pt.stacklowoverf.com/q/205171/101 and https://en.stackoverflow.com/q/138621/101. Some or the set may already have responded.
– Maniero
Thank you guys, the links you gave me were a big help.
– Felipe Paz