4 ms·

very nice, indeed. it would be very impressive, if postgresql could generate it's own CRUD interface (select option: angular / react) so much tedious frame-wo

very nice, indeed. it would be very impressive, if postgresql could generate it's own CRUD interface (select option: angular / react) so much tedious frame-work could be just dropped.

chrisdevereux 11y ago
You might be interested in this: https://github.com/begriffs/postgrest 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 11y ago
  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 https://github.com/begriffs/postgrest/issues/114
fredsted 11y ago
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.
iLoch 11y ago
This makes me want to cry.. When do you ever not have ANY logic in CRUD?
- zo1 11y ago
  Configuration data? Manual input of test data?
outworlder 11y ago
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.
juliangregorian 11y ago
http://rny.io/nginx/postgresql/2013/07/26/simple-api-with-nginx-and-postgresql.html http://rny.io/nginx/postgresql/2013/07/26/simple-api-with-ng... Probably don't use it in production.
- merb 11y ago
  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 11y ago
    Good luck with that.
thorin 11y ago
Very possible with oracle apex and oracle rest data services, even with the free version of Oracle

very nice, indeed. it would be very impressive, if postgresql could generate it's own CRUD interface (select option: angular / react) so much tedious frame-work could be just dropped.

chrisdevereux 11y ago

You might be interested in this: https://github.com/begriffs/postgrest 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 11y ago
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 https://github.com/begriffs/postgrest/issues/114

fredsted 11y ago

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.

iLoch 11y ago

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

zo1 11y ago
Configuration data? Manual input of test data?

outworlder 11y ago

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.

juliangregorian 11y ago

http://rny.io/nginx/postgresql/2013/07/26/simple-api-with-nginx-and-postgresql.html http://rny.io/nginx/postgresql/2013/07/26/simple-api-with-ng... Probably don't use it in production.

merb 11y ago
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 11y ago
  Good luck with that.

thorin 11y ago

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