Re: used for large media files

From: "Mike Kay" <mikekay(at)channelk(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: used for large media files
Date: 2009-06-17 15:43:06
Message-ID: 19526.207.236.146.18.1245253386.squirrel@www.channelk.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Now that's an interesting way of doing this I never thought about before.
Using a fileserver though, how would I categorize and index the files?

I was planning on using multiple databases to hold the data - one for each
client and a separate database for each file type. Yes, they would be
hosted on the same server. I see the bottleneck.

I suppose that instead of saving the files, indexes and categories all in
the same database, I could simply reference the location and file names in
the database - and index and categorize in this manner. Does this make
sense?

> When this question comes up every now and again (check the archives)
> the consensus turns out to be that, yes, Postgres will do this for you
> just fine..... just so long as you realize that storing big blobs of
> unchanging data in any relational database may not be the best use of
> a database.
>
> On the plus side, you know that all your media and all its metadata is
> transactionally safe, and that it's all in the same place. On the
> negative side, it's all in the same place, which means the database
> can become more of a bottleneck than it needs to be. Fileservers are
> *cheap* compared to database servers, and scale out much better.
> Databases go faster when they don't have to keep track of as much stuff.
>
> But this is all true of any RDMS. If it's what you want, then Postgres
> will do as good a job of it as you're going to find anywhere else.
>
> On Jun 17, 2009, at 5:12 AM, Mike Kay wrote:
>
>> Greetings. I am in the process of deciding my infrastruture for a web
>> based application dealing with audio, video and image files. In my
>> discussions with web developers PostgreSql came up as a candidate
>> for my
>> database. This is my FIRST introduction to this database, although
>> I've
>> heard of it - I have no knowledge of using it.
>>
>> What I am attempting to build is a database driven web site that
>> allows
>> users to easily upload either audio, video or images of any type -
>> categorize the files, then output the files via streaming. I would
>> like
>> the users to be able to voice annotate images and build presentations.
>>
>> Would PostgreSQL be a good database for this type of application?
>> Database
>> size could grow large very quickly.
>>
>> I have not decided on the rest of my platform yet, for coding the
>> interface and presenting it.
>>
>> Any input most appreciated.
>>
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>
>

The highest achievement possible is compassion.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Whit Armstrong 2009-06-17 15:56:07 Re: how to cancel a query in progress
Previous Message Tom Lane 2009-06-17 15:30:03 Re: GiST or GIN, I feel like I am doing something wrong