Accessing binary blob data in MySQL backend
mat999 at gmail.com
Tue May 31 18:38:33 MSD 2011
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,
> > 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
> > > > is currently stored in a MySQL database. I was loosely following the
> > > > examples mentioned in agentzh's blog  which work all fine for me
> > > > 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
Warez Scene <http://thewarezscene.org> Free Rapidshare
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the nginx