DELETE FROM images WHERE (uploaded_user='user1' OR uploaded_user='user2') AND uploaded_date > 123 AND gallery_id=0<br><br>SQL makes querying and management easy, thats why some people choose to store their data in mysql BLOBs instead of on the filesystem.<br>
<br><br><br><div class="gmail_quote">On Wed, Jun 1, 2011 at 12:33 AM, Igor Sysoev <span dir="ltr"><<a href="mailto:igor@sysoev.ru">igor@sysoev.ru</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div class="im">On Wed, Jun 01, 2011 at 12:06:12AM +1000, SplitIce wrote:<br>
> ease of management is the main positive, I recently moved away from it<br>
<br>
</div>What do you mean by "ease of management". As for me there is no easier<br>
management than file system one. You have a lot of tools - find, grep, etc.<br>
<div><div></div><div class="h5"><br>
> myself to a filesystem based solution for one of my clients. The largest<br>
> disadvantage is the size of the table. Oh and JSON can be binary safe if<br>
> implmented correctly with correct escape sequences, yes?<br>
><br>
> On Tue, May 31, 2011 at 11:57 PM, Igor Sysoev <<a href="mailto:igor@sysoev.ru">igor@sysoev.ru</a>> wrote:<br>
><br>
> > On Tue, May 31, 2011 at 07:20:34AM -0400, csg wrote:<br>
> > > Hi!<br>
> > ><br>
> > > I am curious if is feasible to have Nginx deliver binary blob data which<br>
> > > is currently stored in a MySQL database. I was loosely following the<br>
> > > examples mentioned in agentzh's blog [1] which work all fine for me with<br>
> > > non-binary data. But as JSON is used for intermediate serialization<br>
> > > which is not binary safe I was wondering if there are other ways (or<br>
> > > even modules) that access the raw payload data from its RDS<br>
> > > representation.<br>
> > ><br>
> > > In my scenario I'm trying to access images data like JPEGs stored as<br>
> > > blobs in MySQL causing the JSON parser to fail of course<br>
> ><br>
> > I can not say anuthing about subject, I'm just interesting are any<br>
> > advanatges to store images in MySQL instead of file system ?<br>
<br>
<br>
--<br>
Igor Sysoev<br>
<br>
_______________________________________________<br>
nginx mailing list<br>
<a href="mailto:nginx@nginx.org">nginx@nginx.org</a><br>
<a href="http://nginx.org/mailman/listinfo/nginx" target="_blank">http://nginx.org/mailman/listinfo/nginx</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br><a href="http://thewarezscene.org" target="_blank">Warez Scene</a> <a href="http://www.nexusddl.com" target="_blank">Free Rapidshare Downloads</a><br><br>