| From: | Rahila Syed <rahilasyed(dot)90(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: SQL for multimedia retrieval |
| Date: | 2013-07-29 02:32:03 |
| Message-ID: | 1375065123471-5765396.post@n5.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello,
Yes. Multimedia data can be stored in PostgreSQL database using either bytea
and BLOB types. Depending on size either can be used. BLOB is meant for
storing large data.
Various interfaces are provided to access such data.
Following link can be referred for that.
http://www.postgresql.org/docs/9.1/static/lo-interfaces.htm
<http://www.postgresql.org/docs/9.1/static/lo-interfaces.htm> l
Or another way to do it is to store the multimedia files in filesystem and
use database to store metadata about them to make them easily accessible.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/SQL-for-multimedia-retrieval-tp5765353p5765396.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | James Sewell | 2013-07-29 06:32:25 | Re: Snapshot backups |
| Previous Message | Amit Langote | 2013-07-29 00:29:06 | Re: async streaming and recovery_target_timeline=latest |