6 ms·
I should write a SQL as a NoSQL database blog post, showing a trivial one-table schema that does all you could ever want in a NoSQL, especially after choosing t
by cryptonector 6y ago
I should write a SQL as a NoSQL database blog post, showing a trivial one-table schema that does all you could ever want in a NoSQL, especially after choosing to ignore that it still has SQL.
- devoutsalsa 6y agoSomeone wrote a SQL wrapper around InnoDB & called it MySQL XD
- 10000truths 6y agoThey should sell that to a large tech corp, I bet they'd make a killing.
- richardwhiuk 6y agosqlite and json.1 gets you pretty close to emulating a more powerful nosql database.
- cryptonector 6y agoI'm aware. My comment was a joke, but evidently it's been well-received.
- munk-a 6y agoThis may or may not be the case anymore[1] - but for a long while Postgres' managed to outperform MongoDB when restricted to just using single JSON column tables. One of the larger relational DBs beating the OG NoSQL will always fill me with amusement. 1. Ed. looks like this is still the case, but please remember this is MongoDB specifically. AFAICT MongoDB is mostly a dead branch at this point and a comparison against Redis or something else that's had continued investment might be more fair. I'm just happy chilling in my SQL world - I'm not super up-to-date on the NoSQL market.
- Cir0X 6y agoI can't find any sources for this. Can you provide one?
- munk-a 6y agoHere's one (read the article in detail, apparently this is up to pretty recently...) https://www.enterprisedb.com/news/new-benchmarks-show-postgres-dominating-mongodb-varied-workloads https://www.enterprisedb.com/news/new-benchmarks-show-postgr... Also, here's SiSense sensationalizing it for easy digest: https://www.sisense.com/blog/postgres-vs-mongodb-for-storing-json-data/ https://www.sisense.com/blog/postgres-vs-mongodb-for-storing...
- Lorin 6y agocheck out RedBeanPHP - it does some interesting stuff for schema liquidity
- dmingod666 6y agoPostgres has good support for JSON.
- wingspan 6y agoYou joke, but this is basically how Facebook uses MySQL for the main user table and for the majority of Entities: https://blog.yugabyte.com/facebooks-user-db-is-it-sql-or-nosql/ https://blog.yugabyte.com/facebooks-user-db-is-it-sql-or-nos...