4 ms·
turns out relational databases make for quite good nosql datastores, it just takes a little bit of thought instead of jumping onto a bandwagon of the month.
by baq 12y ago
turns out relational databases make for quite good nosql datastores, it just takes a little bit of thought instead of jumping onto a bandwagon of the month.
- pjmlp 12y agoWith the added value of constraints and data integrity. I am yet to do any project where a NoSQL database makes sense.
- M8 12y agoSQL => 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.
- threeseed 12y agoSo 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.
- dorfsmay 12y agoAs someone who had to do aggregation on hstore... Gosh! Why? It's not that difficult to add a column!
- ahachete 12y agoOr not ^_^ Have a look at ToroDB (https://github.com/torodb/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 12y agoSurprised 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 12y agoIt's trendy on HN to like SQL databases and bash MongoDB.
- ahachete 12y agoI know. But there was no MongoDB bashing -- at least in the comment ;)
- moron4hire 12y agoReally? I thought it was the other way around. Try not to make generalizations of a rather diverse crowd.