Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2003
    Posts
    7

    Post Unanswered: LOB in PostgreSQL

    Hello guys,
    I'm developing a web site and I'm evaluating PostgreSQL as well as other Databases. The purpose of the web site is to share big files, is PostgreSQL good in storing LOBs? I'm thinking also about storing only the pointer to the physical file rather than the file itself in the database.
    Regards

    Matteo

  2. #2
    Join Date
    Sep 2001
    Location
    Vienna
    Posts
    400

    LOBs

    Sure it is

    I knwo from a DB that stores BLOBS ( 2 TB)

    and there is no problem
    http://www.postgresql.org
    --Postgresql is the only kind of thing--

  3. #3
    Join Date
    Apr 2003
    Location
    Tunisia
    Posts
    192

    Arrow Not cool

    I've used to store files in an educational web site , so I'll advice you to store in the database the info about the files, not the files themselves, I'll recommand you to put them in an ftp , or via a htpp access , It could be like this
    => the fils is here
    /mysite/myfile.xxx

    => the table

    Filename : myfile.xxx
    category :xxxxx (where the cat could refer to a directory for example)
    owner : the man who sold the world
    size : 1024 Kb
    seen (or downloaded) : 45454 times
    description : nothing else a matters hunger file

    Hope You understand me
    Open up
    Take a look to my Blog http://www.rundom.com/karim2k

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •