3 ms·
Postgres is the last SQL DB thing mentioned? No mention of RethinkDB (https://rethinkdb.com/ https://rethinkdb.com/) ? SQL is good if your data is "unchanging
by hardwaresofton 11y ago
Postgres is the last SQL DB thing mentioned?
No mention of RethinkDB (https://rethinkdb.com/ 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.
- overcast 11y agoYeh 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.
- hardwaresofton 11y agoSame 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.
- hiphipjorge 11y agoGotta love the subqueries and the join command! Makes everything nicer!