News for hackers. Stuff that matters.

A comment on What PostgreSQL has over other open source SQL databases: Part II. Parent comment

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.

[ Parent | on HN ]
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.
[ Parent | on HN ]
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.

[ Parent | on HN ]