Welcome! Log In Create A New Profile

Advanced

Re: Accessing binary blob data in MySQL backend

May 31, 2011 10:34AM
On Wed, Jun 01, 2011 at 12:06:12AM +1000, SplitIce wrote:
> ease of management is the main positive, I recently moved away from it

What do you mean by "ease of management". As for me there is no easier
management than file system one. You have a lot of tools - find, grep, etc.

> myself to a filesystem based solution for one of my clients. The largest
> disadvantage is the size of the table. Oh and JSON can be binary safe if
> implmented correctly with correct escape sequences, yes?
>
> On Tue, May 31, 2011 at 11:57 PM, Igor Sysoev <igor@sysoev.ru> wrote:
>
> > On Tue, May 31, 2011 at 07:20:34AM -0400, csg wrote:
> > > 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
> >
> > I can not say anuthing about subject, I'm just interesting are any
> > advanatges to store images in MySQL instead of file system ?


--
Igor Sysoev

_______________________________________________
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: 286
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