pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: brew@theMode.com
To: pgsql-novice@postgresql.org
Subject: Storing Large Objects
Date: Mon, 18 Apr 2005 02:09:10 -0400 (EDT)
Message-ID: <Pine.BSF.4.58.0504180141480.94918@themode.com> (raw)
In-Reply-To: <70E6659A9338D8418379B4EC0CA5819137928D@erumomw002.eemea.ericsson.se>
References: <70E6659A9338D8418379B4EC0CA5819137928D@erumomw002.eemea.ericsson.se>


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@theMode.com)
  Check out my Stock Option Covered Call website  http://www.callpix.com
     and my Musician's Online Database Exchange http://www.TheMode.com
 ==========================================================================




view thread (5+ messages)  latest in thread

Message-ID: <Pine.BSF.4.58.0504180141480.94918@themode.com>
Permalink:  ../Pine.BSF.4.58.0504180141480.94918@themode.com/
Also on:    postgresql.org/message-id/Pine.BSF.4.58.0504180141480.94918@themode.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: brew@theMode.com, pgsql-novice@postgresql.org
  Subject: Re: Storing Large Objects
  In-Reply-To: <Pine.BSF.4.58.0504180141480.94918@themode.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox