3 ms·
There's no such thing as "NoSQL" - it's a meaningless term. It's far better to just refer to the actual type of database: relational, key/value, wide-column, gr
by manigandham 11y ago
There's no such thing as "NoSQL" - it's a meaningless term. It's far better to just refer to the actual type of database: relational, key/value, wide-column, graph, rdf, etc.
Any one of these database types can have a SQL interface (in various dialects and standards), ACID, different consistency models and scale-out options. It's just up to the specific database product in what it actually offers.
- takeda 11y agoThat's a good point, I do hate that term, but there's not a good term that encompasses them all. Perhaps it should be relational vs specialized database. Perhaps it should be said that relational is DB that's for general purpose, while specialized (key/value, graph, etc) requires you to understand your data so you can make proper trade-offs when picking specialized db. You are not getting those features advertised by other databases for free.
- spacemanmatt 11y agoThey're all specialized DBs. There is no general case.
- manigandham 11y agoYou don't need any terms, they're all just databases. Relational is specialized too - in dealing with relational data, foreign keys, normalization, joins, etc. ACID is just a feature of a product, not tied to relational as there are relational databases that don't offer it or can have it disabled. Tradeoffs and understanding your data apply to every single type of database.