News for hackers. Stuff that matters.

A comment on SQLer – Turn Your SQL queries into RESTful APIs without any programming language. Parent comment

Re:SQLer – Turn Your SQL queries into RESTful APIs without a... by pritambarhate on Wednesday January 09, 2019 @04:02AM (#18863370)
One thing I found hard to grasp with Postgrest is SQL based authentication and authorization. It's not easy to understand and implement. It will be great if Postgrest also provides an auth webhook like SQLer. That way users can write or plug-in authentication and authorization in a language/framework they are more familiar with.
[ Parent | on HN ]
Re:SQLer – Turn Your SQL queries into RESTful APIs without a... by danroc on Wednesday January 09, 2019 @04:31AM (#18863497)
Totally agree. I feel it is such a powerful feature but so obscure. I have a solution up, taken from other sources, but what's actually happening behind the scenes is kinda mystery to me. Makes me anxious.
[ Parent | on HN ]
Re:SQLer – Turn Your SQL queries into RESTful APIs without a... by michelpp on Wednesday January 09, 2019 @11:33AM (#18866045)
It's mysterious to you. For the rest of us is thoroughly documented:

http://postgrest.org/en/v5.2/tutorials/tut1.html

http://postgrest.org/en/v5.2/auth.html

https://www.postgresql.org/docs/current/user-manag.html

https://www.postgresql.org/docs/current/ddl-rowsecurity.html

[ Parent | on HN ]
Re:SQLer – Turn Your SQL queries into RESTful APIs without a... by openbasic on Thursday January 10, 2019 @11:28AM (#18875051)
Is it possible to do JWT rotation?
[ Parent | on HN ]