Re:What PostgreSQL has over other open source SQL databases:...
by takeda on Sunday October 25, 2015 @01:48AM
(#10446120)
That'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.
Re:What PostgreSQL has over other open source SQL databases:...
by spacemanmatt on Sunday October 25, 2015 @05:18AM
(#10446431)
They're all specialized DBs. There is no general case.
Re:What PostgreSQL has over other open source SQL databases:...
by manigandham on Sunday October 25, 2015 @11:15AM
(#10447077)
You 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.
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.