4 ms·
NoSQL is just a poor term. It lumps together a number of radically different approaches. Imagine a term like NoCar that would lump together airplanes, bicycles,
by nine_k 5y ago
NoSQL is just a poor term. It lumps together a number of radically different approaches. Imagine a term like NoCar that would lump together airplanes, bicycles, boats, trains, and scooters, just because they are means of transportation which are not a car.
Things like Redis, Kafka, Consul, FoundationDB, RRDTool, git, S3, and plain files are all NoSQL databases of sorts. They all are useful in certain areas, all have very different features and guarantees, and each would be a poor substitute for each other or for an SQL database. (Likely even MongoDB can be useful in some areas, even though I have a hard time imagining that.)
I wish the whole "NoSQL" moniker would go away, replaced by a few terms that make more sense.
That said, the original article is a good one, laying out the upsides and downsides of a document database, and why it makes sense as a local, per-app database.
- mr_overalls 5y ago> radically different approaches Exactly. Relational databases are fantastic general tools, but various use cases can make more specialized data stores the best choice for a particular job. Document stores, key-value stores, column-oriented databases, graph databases can all be more suitable for a given tasks than relational databases.
- tabtab 5y ago> Document stores, key-value stores, column-oriented databases, graph databases can all be more suitable for a given tasks than relational databases. Can related features be add-ons to RDBMS rather than leaving the RDBMS world for good? Any non-trivial system will need at least some of what RDBMS offer. We should try not to throw out the baby with the bathwater. I'd like to explore specific use-cases for NoSql to see what features they need that RDBMS currently lack and if it's impossible to practically add those features to RDBMS. Dynamism of "structure" is about the only thing I can think of right now, and there are possible remedies, per "Dynamic Relational" mentioned nearby.
- mr_overalls 5y agoAt some point when designing a data store, decisions must be made with regards to memory layouts, integrity, transaction guarantees, ease of replication, etc. These choices typically involve reliability vs performance tradeoffs for various use cases. I mean, you _can_ store graph data in a relational database, but its' not typically easy to insert or query, there are serious performance penalties, etc. Purpose-built data structures will always out-perform generic ones.