News for hackers. Stuff that matters.
Re:Embracing SQL in Postgres by spacemanmatt on Thursday February 26, 2015 @09:15AM (#9112564)
> something more structured and more closely corresponding to the domain

If the needs have changed, the API should be upgraded. It seems like ad-hoc querying is mainly to get around shortcomings in the API, right?

Re:Embracing SQL in Postgres by lmm on Thursday February 26, 2015 @09:50AM (#9112751)
Sometimes the business requirements really are that ad-hoc that you need something as general as SQL (in which case there's no point reimplementing it yourself as an "inner platform").
Re:Embracing SQL in Postgres by spacemanmatt on Thursday February 26, 2015 @05:42PM (#9116081)
There's no inner platform. If the business requirements obligate the schema to change, that has a cascade effect on the remote facade and any ORMs using it or DAOs written against it. The database is part of the product, but if you treat it as a foreign component on its own change schedule, I understand how it looks like an inner platform.
Re:Embracing SQL in Postgres by lmm on Friday February 27, 2015 @05:02AM (#9118067)
I meant in the sense of http://thedailywtf.com/articles/The_Inner-Platform_Effect . If you try to create a platform that has all the power and flexibility of SQL queries, you end up reimplementing SQL, poorly.