5 ms·

SQL Server 2005 and newer continued to invest in the XML datatype which was a poor product choice in hindsight. While I applaud this product feature, I'm not c

SQL Server 2005 and newer continued to invest in the XML datatype which was a poor product choice in hindsight. While I applaud this product feature, I'm not convinced of the value of storing JSON in a relational database (any more than storing XML).

baq 11y 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 11y ago
  With the added value of constraints and data integrity. I am yet to do any project where a NoSQL database makes sense.
- M8 11y ago
  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.
  - threeseed 11y ago
    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.
  - dorfsmay 11y ago
    As someone who had to do aggregation on hstore... Gosh! Why? It's not that difficult to add a column!
- ahachete 11y ago
  Or 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 11y ago
    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 11y ago
      It's trendy on HN to like SQL databases and bash MongoDB.
      - ahachete 11y ago
        I know. But there was no MongoDB bashing -- at least in the comment ;)
      - moron4hire 11y ago
        Really? I thought it was the other way around. Try not to make generalizations of a rather diverse crowd.

baq 11y 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 11y ago
With the added value of constraints and data integrity. I am yet to do any project where a NoSQL database makes sense.
M8 11y ago
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.
- threeseed 11y ago
  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.
- dorfsmay 11y ago
  As someone who had to do aggregation on hstore... Gosh! Why? It's not that difficult to add a column!
ahachete 11y ago
Or 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 11y ago
  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 11y ago
    It's trendy on HN to like SQL databases and bash MongoDB.
    - ahachete 11y ago
      I know. But there was no MongoDB bashing -- at least in the comment ;)
    - moron4hire 11y ago
      Really? I thought it was the other way around. Try not to make generalizations of a rather diverse crowd.