Welcome! Log In Create A New Profile

Advanced

Re: Accessing binary blob data in MySQL backend

Piotr Sikora
May 31, 2011 11:52AM
Hi,

> I had rather hoped to get some background information about RDS (is there
> some spec somewhere?)

There is no formal specification, but you can learn everything from
ngx_drizzle / ngx_postgres sources.

Take a look at those 3 files:

https://github.com/chaoslawful/drizzle-nginx-module/blob/master/t/sanity.t
https://github.com/chaoslawful/drizzle-nginx-module/blob/master/src/resty_dbd_stream.h
https://github.com/chaoslawful/drizzle-nginx-module/blob/master/src/ngx_http_drizzle_output.c

> and why the use of the database modules for Nginx for lua-nginx more or
> less enforces the use of JSON. There might be some valid points for this
> design decision and I would be interested to hear about them. It is also
> unclear to me if accessing the RDS data directly from lua-nginx is
> possible.

Because JSON parsers for Lua were already available ;)
Anyway, I believe that agentzh was/is working on RDS parser for Lua.

> Any ideas on that more than welcome :-)

Not sure if this is helpful, but you can return binary data from PostgreSQL
(you should be using PostgreSQL instead of MySQL anyway :P) using
ngx_postgres with "postgres_output" directive. There is a reason why there
is no "drizzle_output" directive, but I'll let agentzh comment on that.

Best regards,
Piotr Sikora < piotr.sikora@frickle.com >


_______________________________________________
nginx mailing list
nginx@nginx.org
http://nginx.org/mailman/listinfo/nginx
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: 308
Record Number of Users: 8 on April 13, 2023
Record Number of Guests: 421 on December 02, 2018
Powered by nginx      Powered by FreeBSD      PHP Powered      Powered by MariaDB      ipv6 ready