very nice, indeed. it would be very impressive, if postgresql could generate it'...

chrisdevereux · on July 21, 2015

You might be interested in this: https://github.com/begriffs/postgrest

"PostgREST serves a fully RESTful API from any existing PostgreSQL database. It provides a cleaner, more standards-compliant, faster API than you are likely to write from scratch."

Sidenote: Anyone had any experience using postgrest? Any good?

snuxoll · on July 21, 2015

It's pretty nice to work with for internal CRUD applications and prototyping, once support for stored functions [0] is completed it'll be tremendously more useful.

0: https://github.com/begriffs/postgrest/issues/114

fredsted · on July 21, 2015

I don't think this is the database's job. However, lots of frameworks do code generation. With Yii you can supply a database and it'll generate the necessary controllers, models and views.

outworlder · on July 21, 2015

Well, I did a terminal-like, request/response user interface for PostgreSQL when I got carried away with a homework assignment. It had a menu system several layers deep.

I assume one could do the same by having it generate html and javascript.

Note that could != should.

iLoch · on July 21, 2015

This makes me want to cry.. When do you ever not have ANY logic in CRUD?

zo1 · on July 21, 2015

Configuration data? Manual input of test data?

thorin · on July 21, 2015

Very possible with oracle apex and oracle rest data services, even with the free version of Oracle

juliangregorian · on July 21, 2015

http://rny.io/nginx/postgresql/2013/07/26/simple-api-with-ng...

Probably don't use it in production.

merb · on July 21, 2015

Why not? Currently the extension API could be used to create a server that directly serves web pages and is as secure as every other application.

juliangregorian · on July 22, 2015

Good luck with that.