Re:PostgREST – REST API from any PostgreSQL database
by batou on Wednesday July 22, 2015 @08:04AM
(#9929042)
No that's about it. Granted they give you efficient paths to get it back again and store it on the right shelves but that's about it.
The key benefit is probably familiarity.
I'm not saying they're an invalid tool, merely just a single tool in a batbelt of a million solutions.
Re:PostgREST – REST API from any PostgreSQL database
by LunaSea on Wednesday July 22, 2015 @07:12AM
(#9928875)
It is but NO database has the chops to help you handle the business logic.
Re:PostgREST – REST API from any PostgreSQL database
by batou on Wednesday July 22, 2015 @08:08AM
(#9929059)
Despite many attempts by people to prove otherwise. Literally every "enterprise" product I've seen tried to do this and fucked it up royally.
Re:PostgREST – REST API from any PostgreSQL database
by arethuza on Wednesday July 22, 2015 @08:59AM
(#9929312)
Interestingly some very enterprise products don't even try and use database features like foreign key relationships - it can be a bit of a shock to open a database with many thousands of tables and realise that there is no obvious way to work out how they relate without looking at application level structures.
You've got to be joking, right?
Data is an enterprise's single biggest asset. A robust, consistent and performant store is vital. SPs can be written as garbage like any other logic, but in the right hands they are a perfectly valid tool for providing useful access to complex data.