Lua and Postgres

brian · 2013-03-22T19:28:11+00:00

This worked perfectly! Thanks a ton!Would love this to go mainstream.-DiptamayOn Thu, Mar 21, 2013 at 9:15 PM, Diptamay Sanyal <dip...@gmail.com> wrote...

Lua and Postgres

brian

I have a project where the data is in Postgres. (It's really more of
an experiment.)  I was thinking that I'd use the ngx_posgres module
with rds output format and use location.capture in Lua and rds.parser
to "munge" the data. Sound reasonable?

--Brian

tor

I've done sort of exactly that in my weather project:

https://github.com/torhve/Amatyr/blob/master/README.md

https://github.com/torhve/Amatyr/blob/master/api.lua

https://github.com/torhve/Amatyr/blob/master/pgrouter.lua

2013/3/22 Brian Akins <br...@akins.org>

I have a project where the data is in Postgres. (It's really more of
an experiment.) I was thinking that I'd use the ngx_posgres module
with rds output format and use location.capture in Lua and rds.parser
to "munge" the data. Sound reasonable?

--Bria.

agentzh

Hello!

On Fri, Mar 22, 2013 at 4:28 AM, Brian Akins wrote:
> I have a project where the data is in Postgres. (It's really more of
> an experiment.)  I was thinking that I'd use the ngx_posgres module
> with rds output format and use location.capture in Lua and rds.parser
> to "munge" the data. Sound reasonable?
>

Yes :)

FWIW, The lua-resty-postgresql library is still on my TODO list
although @hugozhu has done some experiments with a subset of the Pg
protocol (used by Taobao's OceanBase database):

    https://github.com/hugozhu/lua-resty-oceanbase

I've been trying to get away from subrequests for direct database
communication in the future :)

Best regards,
-agentzh