Skip site navigation (1) Skip section navigation (2)

Storing Large Objects

From: brew(at)theMode(dot)com
To: pgsql-novice(at)postgresql(dot)org
Subject: Storing Large Objects
Date: 2005-04-18 06:09:10
Message-ID: Pine.BSF.4.58.0504180141480.94918@themode.com (view raw or flat)
Thread:
Lists: pgsql-novicepgsql-performance
Hi All......

I'm writing a php web application which sells mp3 music for production
use (a rather limited audience, as opposed to a general mp3 download
site).

Since I've heard large objects were a bother I've written it so the mp3s
were in files with long obfuscated filenames and have put them in a
directory hidden behind basic authentication, planning a php front end to
the basic authentication and storing the file urls in the database.  Now
I'm considering shortlived symbolic filenames to further make it difficult
to rip off the mp3 files by other users with valid log in credentials that
can get past the basic authentication.

Basically it's turning into one big unwieldy kluge.

I'm reading about large object php functions and am considering storing
the mp3s themselves as large objects in postgreSQL, rather than just the
filenames, and it's starting to look better and better!  It would be very
easy to make it so that only the valid user could pull the mp3 large
object out of postgreSQL.

Is storing large objects as easy as the php functions make it look?  What
about the pg_dump difficulties with large objects?

I'm using Debian Stable which has postgreSQL 7.2.1 and PHP 4.1.2 which so
far has been working fine with my small text databases, but I suspect if I
want to consider large objects I should really upgrade, eh?

TIA....

brew

 ==========================================================================
                  Strange Brew   (brew(at)theMode(dot)com)
  Check out my Stock Option Covered Call website  http://www.callpix.com
     and my Musician's Online Database Exchange http://www.TheMode.com
 ==========================================================================


In response to

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2005-04-18 06:11:35
Subject: Re: Postgresql works too slow
Previous:From: Steve PoeDate: 2005-04-18 05:42:21
Subject: Re: Postgresql works too slow

pgsql-performance by date

Next:From: Tom LaneDate: 2005-04-18 06:11:35
Subject: Re: Postgresql works too slow
Previous:From: Steve PoeDate: 2005-04-18 05:42:21
Subject: Re: Postgresql works too slow

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group