web app with just html/css/js and openresty <-> nx_postgres

arcanosam · 2017-12-21T01:54:20+00:00

I think option 1 is the best way for checking whether this HTTP request carries request body or not. When neither Content-Length nor Transfer-Encoding i...

web app with just html/css/js and openresty <-> nx_postgres

arcanosam

Hi all

I'm totally new on OpenResty which I found few hours ago.

But if I understood what I read until now about OpenResty, theoretically, I could build an web app where I could be handle all on Postgres (using ngx_postgres module)?

I just have to worry on how build user interface with HTML/JS/CSS and then the heavy work will send to database, right?

Because, today, I know what I will say now it's not the usual approach, but a database like PostGres can do all about a PHP, Python can do, include using this languages if need.

So, as I saw in the ngx_postgres Readme, I could just call my procedures/functions and pass the data which came from browser and the response generated by postgres already converted to json (with your own functions).

Using this picture to ilustrate:

I could be eliminating PHP Processor phase, as example.

In another topic in this forums, someone told the ngx_postgres lacks transactions, but in my approach I don't need because I could do it within database.

Any sugestions or precautions I might take before try?

If I return from database a JSON, what I have to do to disable the default behavior of ngx_postgres module that is a response in rds format?

Thanks for attention.

And congratulations for the developers, nice plataform you created.

Cheers,

Samuel

moonbingbing

https://github.com/leafo/pgmoon is better than ngx_postgres, the latter is no longer recommended.

pgmoon support transactions and you do not need to care rds format anymore.

2017-12-21 1:54 GMT+08:00 サムエルテイェイラサントス <arca...@gmail.com>:

Hi all

I'm totally new on OpenResty which I found few hours ago.

But if I understood what I read until now about OpenResty, theoretically, I could build an web app where I could be handle all on Postgres (using ngx_postgres module)?

I just have to worry on how build user interface with HTML/JS/CSS and then the heavy work will send to database, right?

Because, today, I know what I will say now it's not the usual approach, but a database like PostGres can do all about a PHP, Python can do, include using this languages if need.

So, as I saw in the ngx_postgres Readme, I could just call my procedures/functions and pass the data which came from browser and the response generated by postgres already converted to json (with your own functions).

Using this picture to ilustrate:

I could be eliminating PHP Processor phase, as example.

In another topic in this forums, someone told the ngx_postgres lacks transactions, but in my approach I don't need because I could do it within database.

Any sugestions or precautions I might take before try?

If I return from database a JSON, what I have to do to disable the default behavior of ngx_postgres module that is a response in rds format?

Thanks for attention.

And congratulations for the developers, nice plataform you created.

Cheers,

Samuel

.

arcanosam

I see that recommendation in another discussions too.

But I have to use Lua to use pgmoon.

And using ngx_postgres I could use raw SQL.

So ngx_postgres will be discontinued? 😓

@Gmail-mobile