turns out relational databases make for quite good nosql datastores, it just tak...

ahachete · on May 19, 2015

Or not ^_^ Have a look at ToroDB (https://github.com/torodb/torodb). It is a mongo-compatible database sitting on top of PostgreSQL. You don't need thought, just use it :)

Disclaimer: I'm a ToroDB developer

ahachete · on May 19, 2015

Surprised by the downvote. It is an open source solution that does exactly what the parent comment was asking (not having to think about how to map json to a relational database). I don't see a problem mentioning some software (again: open source) as a viable solution to that problem.

threeseed · on May 19, 2015

It's trendy on HN to like SQL databases and bash MongoDB.

moron4hire · on May 19, 2015

Really? I thought it was the other way around.

Try not to make generalizations of a rather diverse crowd.

ahachete · on May 19, 2015

I know. But there was no MongoDB bashing -- at least in the comment ;)

M8 · on May 19, 2015

SQL =>

Step 1: remove data integrity.

Step 2: remove powerful query language.

Step 3: only store strings.

=> No-SQL

It's interesting that the technology is named after a missing feature.

dorfsmay · on May 19, 2015

As someone who had to do aggregation on hstore... Gosh! Why? It's not that difficult to add a column!

threeseed · on May 19, 2015

So I take it you have zero experience with NoSQL databases then.

HiveQL is far more powerful than SQL and MongoDB QL is pretty powerful for querying document data structures. The others do 95% of what most people are doing in SQL. And the overwhelming majority of NoSQL databases support data types.

And there is no issue with the data integrity of NoSQL databases. Do you really think the hundreds of top companies would use them if there was e.g. Apple, Google, Twitter, Netflix etc.

pjmlp · on May 19, 2015

With the added value of constraints and data integrity.

I am yet to do any project where a NoSQL database makes sense.