Welcome! Log In Create A New Profile

Advanced

Re: Accessing binary blob data in MySQL backend

csg
June 01, 2011 02:12AM
agentzh Wrote:
-------------------------------------------------------
> On Tue, May 31, 2011 at 11:50 PM, Piotr Sikora
> <piotr.sikora@frickle.com> wrote:

> There's a specification for the RDS binary format
> in ngx_drizzle's README file:
>
> http://github.com/chaoslawful/drizzle-nginx-module
>
> See the Output section there.

First of all, thanks to both of you, Piotr and agentzh, for your replies!

> > 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
> example:
>
> local lua_table =
> ngx.from_rds(some_rds_binary)
> local rds_binary = ngx.to_rds(some_lua_table)

That what be awesome, really :-) I would be happy to test code as soon as available.

> 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
> another.

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 [1] (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.

[1] http://blogs.innodb.com/wp/2011/04/nosql-to-innodb-with-memcached/
[2] http://wiki.nginx.org/HttpMemcachedModule

Anyway, many thanks so far!
Subject Author Posted

Accessing binary blob data in MySQL backend

csg May 31, 2011 07:20AM

Re: Accessing binary blob data in MySQL backend

Igor Sysoev May 31, 2011 09:58AM

Re: Accessing binary blob data in MySQL backend

SplitIce May 31, 2011 10:08AM

Re: Accessing binary blob data in MySQL backend

Igor Sysoev May 31, 2011 10:34AM

Re: Accessing binary blob data in MySQL backend

SplitIce May 31, 2011 10:40AM

Re: Accessing binary blob data in MySQL backend

csg May 31, 2011 10:48AM

Re: Accessing binary blob data in MySQL backend

SplitIce May 31, 2011 11:32AM

Re: Accessing binary blob data in MySQL backend

csg May 31, 2011 10:42AM

Re: Accessing binary blob data in MySQL backend

mow May 31, 2011 10:54AM

Re: Accessing binary blob data in MySQL backend

csg May 31, 2011 11:05AM

Re: Accessing binary blob data in MySQL backend

Igor Sysoev May 31, 2011 11:10AM

Re: Accessing binary blob data in MySQL backend

csg May 31, 2011 11:24AM

Re: Accessing binary blob data in MySQL backend

Piotr Sikora May 31, 2011 11:52AM

Re: Accessing binary blob data in MySQL backend

agentzh June 01, 2011 12:04AM

Re: Accessing binary blob data in MySQL backend

csg June 01, 2011 02:12AM

Re: Accessing binary blob data in MySQL backend

mow May 31, 2011 11:44AM



Sorry, only registered users may post in this forum.

Click here to login

Online Users

Guests: 87
Record Number of Users: 6 on February 13, 2018
Record Number of Guests: 421 on December 02, 2018
Powered by nginx      Powered by FreeBSD      PHP Powered      Powered by MariaDB      ipv6 ready