Re: [SLE] File Server

From: Tom Allison (tallison_at_tacocat.net)
Date: 02/23/04

  • Next message: Kenneth Schneider: "Re: [SLE] Linux software RAID, LVM, is this right?" 
    Date: Mon, 23 Feb 2004 08:16:17 -0500
To: Javier Omella <jota.suse@developers.com.py>

    Javier Omella wrote:
    > John dijo:
    >
    >>Everything must be done via perl.
    >>
    >>I have already download vsftp for trasferring the files (Net::FTP) BUt
    >>is it a good idea to store gifs (~100 Kb) in a Mysql database or to
    >>store the images in the file system directly?
    >>
    >
    >
    > I donīt think it is a good idea, some guys maybe think is ok but in my
    > personal experience is more slow and you have much development, and in the
    > future if for some reason you are adding more weight images, your system
    > will be even more slow. Maybe in DB like Oracle or M$SQL with store
    > procedures!!
    > Security? yes, it is more secure in the DB, but, itīs just question of
    > doing things right
    >
    > Maybe someone here have a different experience than me, and can share it.
    >
    > cheers.
    >
    > Sorry, my english sucks :)
    >

    Even in Oracle this is a really bad idea.
    I know because I had this conversation with someone who is an Oracle DBA
    last week about it.

    You store the links to the images (/var/spool/pictures/winter/p001.jpg)
    before you store the body in the database.

    This way you can do a few things with the database.
    Back up is easier because you don't have to manage a binary block of
    data that never changes.
    You can visually verify that the images called are the images seen.
    You can do debugging more easily by keeping the images in a space that
    is readily accessable for you to look at.

    Putting it into a database gaurantees that you will never be able to
    debug it without building a bunch of software to pull the image out of
    the database for you, but that software has to be 100% bug free... 

    -- 
Check the headers for your unsubscription address
For additional commands send e-mail to suse-linux-e-help@suse.com
Also check the archives at http://lists.suse.com
Please read the FAQs: suse-linux-e-faq@suse.com
  • Next message: Kenneth Schneider: "Re: [SLE] Linux software RAID, LVM, is this right?"

    Relevant Pages

    • Re: design question
      ... I need to store java objects in my oracle database. ... The database shall scale up at least to 100 million objects. ... storage to relational theory is to shred XML into its constituent ...
      (comp.databases.oracle.server)
    • Re: Storing images in postgreSQL (with PHP)
      ... > I am wanting to learn how to store images in a postgreSQL database. ... Some code to load a picture might be: ...
      (comp.lang.php)
    • Re: storing path only to database
      ... Do not store the images in the file, rather store them on the hard drive and ... store the path to them in the Access database. ... Alternatively, you can store images in multiple tables, each one of which is ... Dim MyFolder As String ...
      (microsoft.public.access.formscoding)
    • Re: Image problem
      ... This sounds like one of the symptoms of hitting the database size limit? ... Using Photo Editor to store JPEGs causes a huge overhead, since it stores each image uncompressed, then ... Either store the images externally as files, or as blobs if you want them in the database. ...
      (microsoft.public.access.tablesdbdesign)
    • Re: file upload storage - database vs folder
      ... Suppose I do store my images for a web site in a BLOB ... > I have used both techniques whilst working with oracle database. ...
      (microsoft.public.dotnet.general)