Welcome! Log In Create A New Profile

Advanced

Accessing binary blob data in MySQL backend

csg
May 31, 2011 07:20AM
Hi!

I am curious if is feasible to have Nginx deliver binary blob data which is currently stored in a MySQL database. I was loosely following the examples mentioned in agentzh's blog [1] which work all fine for me with non-binary data. But as JSON is used for intermediate serialization which is not binary safe I was wondering if there are other ways (or even modules) that access the raw payload data from its RDS representation.

In my scenario I'm trying to access images data like JPEGs stored as blobs in MySQL causing the JSON parser to fail of course

content_by_lua aborted: runtime error: InvalidJSONInput: lexical error: invalid bytes in UTF8 string.

My current software stack consists of CentOS 5.6/x86_64, Nignx 1.0.3 (plus simpl-ngx_devel_kit 0.2.17, chaoslawful-lua-nginx-module 0.1.5, chaoslawful-drizzle-nginx-module 0.0.14, agentzh-rds-json-nginx-module 0.10), Lua 5.1.4, LuaRocks 2.0.4.1, Lua YAJL 2.0, YAJL 2.0.1, Drizzle7 libraries 2011.04.15 and MySQL database 5.1.57.

[1] http://agentzh.blogspot.com/2011/02/ngxlua-v015-ability-to-capture-multiple_6605.html
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: 275
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