Re: Video storage in Postgres?

Bob,

> Anyone aware of companies using techniques in Postgres to store videos?
> My understanding from talking to a bunch of online video companies is
> that they typically store the links in the DBMS that points to the video
> file to a file system. Thoughts? Most say they would love to store the
> video in the DBMS itself.

APC has a server room security/environment solution which stores up to 1TB
of annotated video frames in each PostgreSQL database.  I know there's
another as well, but I can't remember it right now.

For most applications, it makes more sense to store video in the filesystem
and not in the DB.  Also for *retrieval* of video, we have an issue; libpq
really needs a way to retrive large data 1MB at a time and not wait for
the whole field/row.

--
--Josh

Josh Berkus
PostgreSQL @ Sun
San Francisco