Accessing binary blob data in MySQL backend
nginx-forum at nginx.us
Wed Jun 1 10:12:34 MSD 2011
> On Tue, May 31, 2011 at 11:50 PM, Piotr Sikora
> <piotr.sikora at frickle.com> wrote:
> There's a specification for the RDS binary format
> in ngx_drizzle's README file:
> See the Output section there.
First of all, thanks to both of you, Piotr and agentzh, for your
> > Anyway, I believe that agentzh was/is working on
> RDS parser for Lua.
> Yeah, I'll work on the RDS API for ngx_lua, for
> local lua_table =
> local rds_binary = ngx.to_rds(some_lua_table)
That what be awesome, really :-) I would be happy to test code as soon
> We surely *can* implement a drizzle_output
> directive though it's much
> more difficult than ngx_postgres because
> ngx_drizzle is designed to
> work in a streaming fashion while libpq in the Pg
> world always buffer
> the whole resultset.
Haven't thought about that, but makes perfect sense.
> It seems that I still do have a lot of interesting
> stuffs to work on,
> huh? ;) Well, the focus in the future will,
> however, be on developing
> a full-fledged non-blocking streaming mysql C
> driver from scratch for
> nginx because both libmysql and libdrizzle are sad
> in one way or
Sounds like a plan, but surely it cannot be expeceted that this will be
available soon, right?
For now maybe another area I can look at is MySQL's upcoming Memcache
interface  (which would also reduce the pain for SQL query parsing as
in my use case from the web server point of view MySQL is just being
used as a key value store) and access it via the Memcache module.
Anyway, many thanks so far!
Posted at Nginx Forum: http://forum.nginx.org/read.php?2,202577,202857#msg-202857
More information about the nginx