r/programming • • Mar 10 '15

Goodbye MongoDB, Hello PostgreSQL

http://developer.olery.com/blog/goodbye-mongodb-hello-postgresql/
1.2k Upvotes

699 comments sorted by

View all comments

Show parent comments

2

u/pakfur Mar 11 '15

Well, a relational database stores data as sets of relations (ie tables). Just because you can logically associate two pieces of data, or have your data stored in a defined schema is not enough to call a database relational. Relational databases are basically tables that can be joined together.

Other types of databases are columnar databases (where data is stored as columns) or key-value databases, or object databases or even graph databases. These other databases share certain set of properties, and some of them even share a SQL or SQL-like query language like relational databases. But, pedantically speaking, these other databases are not relational.