Re: Video storage in Postgres? - Mailing list pgsql-advocacy

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Bob Zurek wrote:
> What hear from the video companies is that they would find it easier
> than using a file system and that they could have the database handle
> backups, fault tolerance, security, recovery and replication.

I assume then that the performance hit the database is going to take is
acceptable? Keep in mind that if you stored in Bytea, a 700 Meg video,
you are going to use 700 Meg of ram to pull that video out "per pull".

Joshua D. Drake


>
> Z.
>
> -----Original Message-----
> From: pgsql-advocacy-owner@postgresql.org
> [mailto:pgsql-advocacy-owner@postgresql.org] On Behalf Of JoshuaKramer
> Sent: Thursday, August 16, 2007 11:43 PM
> To: pgsql-advocacy@postgresql.org
> Subject: Re: [pgsql-advocacy] Video storage in Postgres?
>
>
> This, along with the "appropriate apps for mySQL", reminds me of the
> Parable of the Porsche that I just made up.
>
> My buddy Bob wanted to tow a horse trailer with a Porsche.  He could
> haul
> the jockeys around to drive horses listed in the directories at
> different
> stables, but he'd love to haul his horses with his Porsche.
>
> Bob decided to seek the expertise of wise men Chris Titus and Tim
> Taylor.
> "Yes, you can haul a horse trailer with a Porsche, but it won't be easy.
>
> You see, the Porsche is not designed to haul trailers.  You need
> something
> that is, but is also a Porsche."
>
> So the wise men thought some more.  "You must get a Volkswagen Toureg
> with
> the diesel V10, for diesels are designed to tow trailers.  Then, to
> satisfy the requirement of it being a Porsche, you must purchase the
> fenders, bumpers, and other bling from a Porsche Cayenne and fix it to
> your Toureg.  Then you will have a Porsche that can tow a horse
> trailer."
>
> Moral of the story: Yep, you can tow a horse trailer with a Porsche, or
> serve video with your DB server, or base your enterprise app on MySQL -
> but it just isn't right.  :)
>
> In all seriousness, what advantages accrue by serving video from the DB?
>
> Cheers,
> JK
>
> BTW - there's a guy near where I live who drives a Cayenne.  I've always
>
> wanted to go up to him and comment on how nice his Taureg is - but that
> just wouldn't be right, now would it? ;) The two SUV's are actually the
> same platform; the Porsche just has differently styled bling.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly
>


- --

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564   24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997  http://www.commandprompt.com/
            UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGxcrPATb/zqfZUUQRAjuNAJ4+fMO4QA1lRRGJPyK30sqq0YsDkACcDi6G
BLn31ICs0fxElAYWpz/WcLM=
=cFqY
-----END PGP SIGNATURE-----