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

From Lukas Kahwe Smith
Subject Re: Video storage in Postgres?
Date
Msg-id 46C53913.4030401@pooteeweet.org
Whole thread Raw
In response to Re: Video storage in Postgres?  (JoshuaKramer <josh@globalherald.net>)
Responses Re: Video storage in Postgres?  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-advocacy
JoshuaKramer wrote:

> In all seriousness, what advantages accrue by serving video from the DB?

Well all the advantages people associate with LOBs:
- single place for all data * for backups * for replication * for ACLs

I often just care about the first two, in which case I simply employ a
mod_rewrite rule, that points to the on disc version of the file and
fals back to serving directly from the database (but also dump a file to
the proper location on disc).

regards,
Lukas

pgsql-advocacy by date:

Previous
From: JoshuaKramer
Date:
Subject: Re: Video storage in Postgres?
Next
From: "Bob Zurek"
Date:
Subject: Re: Video storage in Postgres?