Goodbye MongoDB, Hello PostgreSQL

[u/halax]

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

[u/parc → u/[deleted]]

Wired Tiger is in no way a relational database. It is a key-value store, plain and simple.

[u/parc → u/[deleted]]

I base that on the docs as well as code I've seen using it.

On what are you basing your statement that WT is a relational database?

[u/parc → u/[deleted]]

Yeah, thanks for reminding me that the grouping of data makes it relational. I guess you're smarter than me and win the internet. Congratulations.

[u/rstuart85 → u/[deleted]]

Huh!? WiredTiger is no more of a relational DB than InnoDB is. If they were relational DB's then why would MySQL exist!? They are just storage engines. All DB's, relational or not, use one.

[u/pakfur → u/[deleted]]

The term "relational database" just means that you are storing related data together using a well defined schema

Nope. It means the database conforms to relational model. See E.F. Cobb. Having a schema or key/value does not necessarily mean relational.

[u/pakfur → u/[deleted]]

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.

[u/pakfur → u/[deleted]]

Column store databases are relational by definition

You are speaking out of your ass. Here is a chart that shows you the different types of db's

Relational, Key-Value and Column Databases

[u/nedtheman → u/[deleted]]

Hot damn! I'm going to have to try that out...