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@xxxxxxxxxxxxxx) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general > > The highest achievement possible is compassion. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
