[thelist] Images--database or file
Austin Harris
austin at dotmail.co.uk
Mon Feb 5 08:49:26 CST 2007
Similar situation for me;
Folders for different sizes of images, (eg thumbs, main etc.) and then just a file name in the db. Makes changing images etc a lot quicker and easier. Also means you can move stuff around quickly.
Austin
----- "Bob Meetin" <ontheroad at frii.com> wrote:
> path <==> gallery_name
>
> i am using different directory names for different file sizes,
> sometimes
> i have many versions of a file in different sizes:
>
> 75x75
> 100x75
> 100x100
> 120x80
> 200x150
> 360x270
> original
> etc.
>
> i set up a standard upper path that all fit under. the files are
> associated with the gallery name, not path - might look like
> "/gallery/images/200x150/file_name.png". 200x150 houses both portrait
>
> and landscape and a p/l field is stored in the database. i don't know
>
> how to use blob to get files into the database, so can't comment on
> how
> well it works - that is another lesson. security is as Joel said.
> also
> to note, when files are uploaded i rename all to lower-case and remove
>
> spaces. -Bob
>
> Joel D Canfield wrote:
> >> Which way is best, tho?
> >>
> >
> > er, how 'bout I offer what I do without claiming it's 'best' - files
> in
> > a directory structure, path in the db.
> >
> > I prefer it because the files *can* be accessed outside the
> database
> > structure if that's desirable. if not, security lockdown cures
> that.
> > path can be changed, it can be parsed and rebuilt on the fly using
> UNC,
> > local path, web address. db can be copied elsewhere as a reference
> to
> > what's available, without requiring the bigness of storing all the
> data.
> >
> > one downside is that moving/copying the db requires the additional
> step
> > for the directory structure, but I can deal with that.
> >
> > joel
> >
>
> --
>
> * * Please support the community that supports you. * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
More information about the thelist
mailing list