Accessing binary blob data in MySQL backend
igor at sysoev.ru
Tue May 31 18:33:18 MSD 2011
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 at 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  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 ?
More information about the nginx