Databases

MySQL or mongoDB?

Relational versus non-relational databases SQL – RELATIONAL NoSQL – NON-RELATIONAL Tables / schema Humongous data, collections, documents, duplication of data Structured Semi/no structure, flexible Relations Less dependence on relations, quick reads Atomic Eventually consistent Monolithic Distributed Scaling Horizontal: add more servers, difficult for SQL (cannot split relational databases) Vertical: add more resources Considerations Consistency versus scale Internal versus public SQL – “Structured Query Language” Relational databases are “Excel on steroids” [Read More]