News for hackers. Stuff that matters.
Re:SQLer – Turn Your SQL queries into RESTful APIs without a... by frou_dh on Wednesday January 09, 2019 @07:48AM (#18864291)
One of the suggested ways to use PostgREST is that rather than pointing it at the Postgres schema called "public" (where created tables live by default), you point it at a schema consisting of nothing but SQL Views which communicate with those tables. That way, the underlying table structure can be altered without affecting the clients that consume the auto-generated HTTP interface.

It's more effort to have to maintain some extra SQL code for those views, but with all the labour-saving PostgREST delivers in the first place, you still come out ahead.

Re:SQLer – Turn Your SQL queries into RESTful APIs without a... by duncan-donuts on Wednesday January 09, 2019 @08:42AM (#18864577)
But if you’re going to do all that why not just put an abstraction in code (that could actually have some automated tests)?
Re:SQLer – Turn Your SQL queries into RESTful APIs without a... by michelpp on Wednesday January 09, 2019 @11:35AM (#18866067)
There are test frameworks for postgres.

https://pgtap.org/