News for hackers. Stuff that matters.
Re:What PostgreSQL has over other open source SQL databases:... by manigandham on Sunday October 25, 2015 @12:53AM (#10446020)
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.

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.