SQL vs. NoSQL Databases: What’s the Difference?

Re:SQL vs. NoSQL Databases: What’s the Difference? by hardwaresofton on Thursday May 12, 2016 @12:20PM (#11684558)

Postgres is the last SQL DB thing mentioned?

No mention of RethinkDB (https://rethinkdb.com/) ?

SQL is good if your data is "unchanging"? Schema migrations happen, SQL can be sharded and scaled to multiple servers, and the fact is, unless you're facebook or google, you probably won't even need it. Didn't reddit run postgres since it began?

Glad I skimmed this.

[ Parent | on HN ]

Re:SQL vs. NoSQL Databases: What’s the Difference? by overcast on Thursday May 12, 2016 @12:25PM (#11684610)

Yeh seriously RethinkDB is the perfect hybrid of "NOSQL" document storage, with SQL like relationships. Been using it for all my projects the past year, and I love it.

[ Parent | on HN ]

Re:SQL vs. NoSQL Databases: What’s the Difference? by hardwaresofton on Thursday May 12, 2016 @02:18PM (#11685557)

Same here, I have no idea why it doesn't get more press, as far as I'm concerned it's the best document store out there.

Mongo has gotten away with some pretty substantial misses, yet still get considered every time NoSQL comes up (maybe first-to-market is really just that powerful), but RethinkDB rarely gets one, despite being so stable and having so many good features.

And when I say mongo has gotten away with substantial misses, I don't mean the documentation miss that lead to documents getting dropped, I mean core issues with their engine that necessitated the wiredtiger contributions/rewrite. Of course, mongo works very well generally, and they've definitely done their part when it comes to documentation and growing the community, and carving the path for what NoSQL document stores (in this day and age) look like.

[ Parent | on HN ]

Re:SQL vs. NoSQL Databases: What’s the Difference? by hiphipjorge on Thursday May 12, 2016 @02:54PM (#11685821)

Gotta love the subqueries and the join command! Makes everything nicer!

[ Parent | on HN ]