Grokking the System Design Interview
Vote

0% completed

​

SQL vs. NoSQL

Every application stores its data somewhere. Those stores fall into two families, called SQL and NoSQL.

SQL is the name of a query language, but people use it as the name of a whole family. The proper name for that family is relational databases. MySQL, PostgreSQL, Oracle, and SQL Server are the common ones.

NoSQL means every database that is not relational. It is not one product and not one design. It covers four different kinds of store, and they have less in common with each other than people expect.

Relational Databases

A relational database keeps data in tables

.....

.....

.....

Like the course? Get enrolled and start learning!
C

chosunone

· 5 months ago

Postgres has good support for JSON columns, including even creating indexes on the fields in the JSON column, so you can have the benefit of being able to progressively move from a more dynamic schema to a more strict one.

John O' Grady

John O' Grady

· 6 months ago

Can you explain ORM? I don't think that term has come up in this course already.

Show 1 reply

Reading Progress

0%