How does one do user authentication and resource authorization?
You can easily do AuthBasic in nginx with a user file
Simple API with Nginx and PostgreSQL
11–20 of 74 posts
Re: Simple API with Nginx and PostgreSQL
#12How does one do user authentication and resource authorization?
Presumably with an 'api_key' table and an 'Authorization' header. Alternatively, Nginx can do cookies and have if-then logic to check them.
Re: Simple API with Nginx and PostgreSQL
#13Is this a "look how cool/flexible nginx is!" article or a real proposal about how to do API's?
Re: Simple API with Nginx and PostgreSQL
#14On an unrelated note, timestamptz is advisable over timestamp.
Re: Simple API with Nginx and PostgreSQL
#15If you use lapis[1] things will be much easier.
Re: Simple API with Nginx and PostgreSQL
#16I wonder what the difference in performance would be compared to NodeJS and Express.
Re: Simple API with Nginx and PostgreSQL
#17I really like the simplicity of this approach, but are the Postgres calls asynchronous? If not, it won't scale...
Re: Simple API with Nginx and PostgreSQL
#18Is this a "look how cool/flexible nginx is!" article or a real proposal about how to do API's?
Hopefully the former. It would be difficult to build anything non-trivial with it. However, I suppose you could build a basic counter or key-value system over HTTP with it.
Re: Simple API with Nginx and PostgreSQL
#19very cool, add in some lua scripting and you can get some pretty solid single purpose endpoints: http://wiki.nginx.org/HttpLuaModule maybe not perfect for a whole app but maybe depending on your goals.
Can you recommend a public repo which demonstrates use of the HttpLuaModule? [Edited to add:] Another comment mentions the Lapis framework which gives [me] a good starting point.
@subs: thanks!
Re: Simple API with Nginx and PostgreSQL
#20I made it to the bottom and thought the article was cut off. Turns out, it really is that simple. (Sans the sql injection and auth stuff).
Fantastic.