sure you can. And i don't mind you disagreeing with me either =) Although, if the solution/site is meant to be used by other than people who know something about the webserver i don't think it's a good solution.
I can imagine writing something that reads the htaccess-file and edits it... but i don't like the possible securtyissues with that. Besides... if you render a page with a selectbox from mysqltables and another with images and let the user match them together, it's idiotproof =) If you have a php(or whatever)-file wich sole purpouse is to check users rights and render images it can also always check if you have the right cookies. If you've been to the right previous page to see that picture, if not redirect to '/'; Do you get my point? I still believe that the blob i my saviour... (despite the obvious loss of performance) On Thu, 20 Mar 2003, B. van Ouwerkerk wrote: > You can use other ways to protect your images from linking by others. Like > with Apache and htaccess.. > > I don't agree with you on your opinion that it's easier to code. If you > insert a link into your database all you have to do is retrieve it and push > the link to the browser. > > > > B. > > > At 20:18 20-03-2003 +0100, lasse wrote: > >hey all.. new to the list. > > > >Just my 5 cents... > >I think it's better to store images in the database, sure you loose a bit > >in performance, but it's easier to code. > > > >The way i've done it before is always a separate render.php (or what ever) > >that compares the users rights to view that image, get's the blob from the > >database, sets right content-type for the page and then renders the > >binary data. > > > >That way... you can control frames/design (direct links to images can be > >avoided) und so weiter... > > > >//lars > > > >On Thu, 20 Mar 2003, B. van Ouwerkerk wrote: > > > > > I assume it is, have not tested it.. > > > > > > If you need to fetch the files from the database your app needs to wait > > > until it has recieved the data. If you only store name/path info it will > > > take less time to fetch the data, ship it off to the browser which can > > > start fetching the images without connecting to the database again. > > > > > > Sounds pretty logical.. and it gets worse if your site is hosted by an ISP > > > who is using a database server running on a seperate box.. > > > > > > > > > B. > > > > > > > > > At 21:35 20-03-2003 +0000, Lai Liu-yuan wrote: > > > >Well, this may be off topic. > > > > > > > >In my case, I store tens of thousands of images, gradually growing. All of > > > >them are quite small, most around 30*30 gray scale. Would it still be > > > >faster to store them on disk? > > > > > > > >On Thu, 20 Mar 2003 13:57:06 +0100 > > > >"B. van Ouwerkerk" <[EMAIL PROTECTED]> wrote: > > > > > > > > > IMHO it's better to store a link. > > > > > I have seen databases (not MySQL) getting corrupted because the file > > > > > inserted was to big. > > > > > > > > > > For the visitor it doesn't really matter whether you put it into the > > > > > database or not. A link is less difficult and you don't have to > > retrieve > > > > > pictures from the database so it might be quicker.. > > > > > > > > > > > > > > > > > > > > B. > > > > > > > > > > > > > > > At 18:34 20-03-2003 +0000, Lai Liu-yuan wrote: > > > > > >I am now having a database storing images of chinese characters for > > > > > >research purpose. I wrote a program to store and retrieve them. My > > images > > > > > >are of type ppm. This is how I designed my table: > > > > > > > > > > > >mysql> describe poor; > > > > > >+--------+----------------+------+-----+---------+-------+ > > > > > >| Field | Type | Null | Key | Default | Extra | > > > > > >+--------+----------------+------+-----+---------+-------+ > > > > > >| cc | char(2) binary | | | | | > > > > > >| width | int(1) | YES | | NULL | | > > > > > >| height | int(1) | YES | | NULL | | > > > > > >| data | blob | YES | | NULL | | > > > > > >+--------+----------------+------+-----+---------+-------+ > > > > > > > > > > > >Just have to be really careful in storing binary data. Hope this help. > > > > > > > > > > > >On Thu, 20 Mar 2003 10:34:19 +0100 > > > > > >[EMAIL PROTECTED] wrote: > > > > > > > > > > > > > Hi! > > > > > > > > > > > > > > I have a problem with my MySQL > > > > > > > > > > > > > > I need to have some a images related with an item > > > > > > > > > > > > > > for example > > > > > > > > > > > > > > ------------------------------------------ > > > > > > > ! author ! date of birth an death ! image! > > > > > > > ------------------------------------------ > > > > > > > > > > > > > > How can I define the field for the images? I have read that > > LONGBLOB > > > > > > > could be useful for large objct like images, but I can't > > understand how > > > > > > > to set it in my database... > > > > > > > > > > > > > > Thank you in advance > > > > > > > > > > > > > > stefano > > > > > > > -- > > > > > > > S t e f a n o C a r d o > > > > > > > Debian GNU-Linux user > > > > > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > > Before posting, please check: > > > > > http://www.mysql.com/manual.php (the manual) > > > > > http://lists.mysql.com/ (the list archive) > > > > > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > > > To unsubscribe, e-mail > > > > <[EMAIL PROTECTED]> > > > > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > > > > > > > > > >--------------------------------------------------------------------- > > > >Before posting, please check: > > > > http://www.mysql.com/manual.php (the manual) > > > > http://lists.mysql.com/ (the list archive) > > > > > > > >To request this thread, e-mail <[EMAIL PROTECTED]> > > > >To unsubscribe, e-mail <[EMAIL PROTECTED]> > > > >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > --------------------------------------------------------------------- > > > Before posting, please check: > > > http://www.mysql.com/manual.php (the manual) > > > http://lists.mysql.com/ (the list archive) > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > To unsubscribe, e-mail > > <[EMAIL PROTECTED]> > > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > >-- > >-----BEGIN GEEK CODE BLOCK----- > >Version: 3.1 (2002 update) > >GCM/GCS/GMU/ d+ s++:++ a-- C++(++++) UBLAIS+(++++) P+ L+(-) E--- W+++ N+ > >o-- K w O- M- V- PS(+++) PE++ Y PGP- t 5+ X++ R- tv+ b+ DI+++ D- > >G e h++ r% y++ > >------END GEEK CODE BLOCK------ > > > > > >--------------------------------------------------------------------- > >Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > >To request this thread, e-mail <[EMAIL PROTECTED]> > >To unsubscribe, e-mail <[EMAIL PROTECTED]> > >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > -- -----BEGIN GEEK CODE BLOCK----- Version: 3.1 (2002 update) GCM/GCS/GMU/ d+ s++:++ a-- C++(++++) UBLAIS+(++++) P+ L+(-) E--- W+++ N+ o-- K w O- M- V- PS(+++) PE++ Y PGP- t 5+ X++ R- tv+ b+ DI+++ D- G e h++ r% y++ ------END GEEK CODE BLOCK------ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
