How to invoke ngx_postgres in init_worker_by_lua_block

[Andy Ai]

I want load all data from a PostgreSQL table. and using ngx.timer.at update incrementally.

Like this:

init_worker_by_lua_block {

  local handler = function()

    local res = -- load data from PostgreSQL

    cache:set(key, res.body)

    ngx.timer.at(delay, handler)

  end

  ngx.timer.at(delay, handler)

}

ngx_postgres need a sub-repquest, example:

local res = ngx.location.capture('/postgres', {args = {sql = sql}})

But, In ngx.timer.at the sub-request is disabled. 

What should I do ?

[Ming]

You can try https://github.com/azurewang/lua-resty-postgres or https://github.com/leafo/pgmoon, which are use cosocket

--
You received this message because you are subscribed to the Google Groups "openresty-en" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openresty-en+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Andy Ai]

Thanks,

But error.log is echo some errors, when start the OpenResty

2016/09/16 12:58:55 [error] 1097#0: init_worker_by_lua error: lib/lua-resty-postgres/lib/resty/postgres.lua:38: API disabled in the context of init_worker_by_lua*

stack traceback:

[C]: in function 'tcp'

lib/lua-resty-postgres/lib/resty/postgres.lua:38: in function 'new'

init_worker_by_lua:4: in function 'handler'

init_worker_by_lua:11: in main chunk

在 2016年9月15日星期四 UTC+8下午9:26:40，WenMing写道：

To unsubscribe from this group and stop receiving emails from it, send an email to openresty-en...@googlegroups.com.

[Andy Ai]

I find a solution. 

Like this:

https://github.com/openresty/lua-resty-upstream-healthcheck/blob/master/lib/resty/upstream/healthcheck.lua

在 2016年9月16日星期五 UTC+8下午1:03:16，Andy Ai写道：

[Ming]

The cosockets are disabled in the init_worker_by_lua* directive context, however you can create a 0-delay timer via ngx.time.at API to do cosocket works.

To unsubscribe from this group and stop receiving emails from it, send an email to openresty-en+unsubscribe@googlegroups.com.

[Andy Ai]

Thanks

在 2016年9月18日星期日 UTC+8上午11:15:16，WenMing写道：

[Nelson, Erik - 2]

I was thinking about adding a simple collaborative editor to my openresty-powered website, something along the lines of Etherpad Lite

https://github.com/ether/etherpad-lite

Unfortunately, it seems like that requires node.js, which isn't the end of the world but I'd like to avoid adding a new tool if pssible.

It occurred to me that someone maybe someone had done something similar to this- does anyone have experience with this kind of thing on openresty?

Thoughts welcome!

Erik

----------------------------------------------------------------------
This message, and any attachments, is for the intended recipient(s) only, may contain information that is privileged, confidential and/or proprietary and subject to important terms and conditions available at http://www.bankofamerica.com/emaildisclaimer. If you are not the intended recipient, please delete this message.