Accessing binary blob data in MySQL backend

[SplitIce]

DELETE FROM images WHERE (uploaded_user='user1' OR uploaded_user='user2')
AND uploaded_date > 123 AND gallery_id=0

SQL makes querying and management easy, thats why some people choose to
store their data in mysql BLOBs instead of on the filesystem.



On Wed, Jun 1, 2011 at 12:33 AM, Igor Sysoev <igor at sysoev.ru> wrote:

> 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 [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 at nginx.org
> http://nginx.org/mailman/listinfo/nginx
>



-- 
Warez Scene <http://thewarezscene.org> Free Rapidshare
Downloads<http://www.nexusddl.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://nginx.org/pipermail/nginx/attachments/20110601/7accbaac/attachment-0001.html>