pgmoon - PostgreSQL driver for OpenResty

leafot · 2014-05-31T03:23:20+00:00

I use NAXSI - [1]. It has OOTB rules for this. DRAGOS [1] - https://www.owasp.org/index.php/OWASP_NAXSI_Project

pgmoon - PostgreSQL driver for OpenResty

leafot

Hello,

I've created a Postgres driver for use in OpenResty in pure Lua using the cosocket api. You can find it here: https://github.com/leafo/pgmoon

You can read the documentation and example here: https://github.com/leafo/pgmoon#example

You can install it with luarocks:

luarocks install --server=http://rocks.moonscript.org pgmoon

I am aware of the other project, https://github.com/azurewang/lua-resty-postgres There is some missing functionality in it and I originally started writing my own to learn more about the protocol to contribute but it turned out simple enough and I just implemented everything I needed. I also had the additional requirement for running the library outside of openresty which I've also implemented.

The project is fully tested and I'm running it on all of my projects now in production and it works great.

Thanks for checking it out

golgote

Thanks !

On Fri, May 30, 2014 at 9:23 PM, leaf corcoran <le...@gmail.com> wrote:

Hello,

I've created a Postgres driver for use in OpenResty in pure Lua using the cosocket api. You can find it here: https://github.com/leafo/pgmoon

You can read the documentation and example here: https://github.com/leafo/pgmoon#example

You can install it with luarocks:

luarocks install --server=http://rocks.moonscript.org pgmoon

I am aware of the other project, https://github.com/azurewang/lua-resty-postgres There is some missing functionality in it and I originally started writing my own to learn more about the protocol to contribute but it turned out simple enough and I just implemented everything I needed. I also had the additional requirement for running the library outside of openresty which I've also implemented.

The project is fully tested and I'm running it on all of my projects now in production and it works great.

Thanks for checking it out

.

anton.heryanto

Hello,

Wow that awesome..

thank you for your contribution..

have you do benchmark to compare performance between ngx_postgres with pgmoon?

and still waiting for openresty package manager.. so every known library could be easy to manage

On Saturday, May 31, 2014 3:23:21 AM UTC+8, leaf corcoran wrote:

Hello,

I've created a Postgres driver for use in OpenResty in pure Lua using the cosocket api. You can find it here: https://github.com/leafo/pgmoon

You can read the documentation and example here: https://github.com/leafo/pgmoon#example

You can install it with luarocks:

luarocks install --server=http://rocks.moonscript.org pgmoon

I am aware of the other project, https://github.com/azurewang/lua-resty-postgres There is some missing functionality in it and I originally started writing my own to learn more about the protocol to contribute but it turned out simple enough and I just implemented everything I needed. I also had the additional requirement for running the library outside of openresty which I've also implemented.

The project is fully tested and I'm running it on all of my projects now in production and it works great.

Thanks for checking it out

gg.lafon

Thank you for the contribution.

I currently use lua-resty-postgres.

Can you explain what are the new features compared to lua-resty-postgres?

What about the performance compared to lua-resty-postgres?

Jérôme

Le vendredi 30 mai 2014 21:23:21 UTC+2, leaf corcoran a écrit :

Hello,

I've created a Postgres driver for use in OpenResty in pure Lua using the cosocket api. You can find it here: https://github.com/leafo/pgmoon

You can read the documentation and example here: https://github.com/leafo/pgmoon#example

You can install it with luarocks:

luarocks install --server=http://rocks.moonscript.org pgmoon

I am aware of the other project, https://github.com/azurewang/lua-resty-postgres There is some missing functionality in it and I originally started writing my own to learn more about the protocol to contribute but it turned out simple enough and I just implemented everything I needed. I also had the additional requirement for running the library outside of openresty which I've also implemented.

The project is fully tested and I'm running it on all of my projects now in production and it works great.

Thanks for checking it out