On Sat, Jul 27, 2013 at 10:24 PM, Olivier Austina
wrote:
> Hi,
>
> Can SQL be used to retrieve data from multimedia content such as audio,
> video, image, full text?
> Regards
> Olivier
>
I am not sure if this is really helpful but anyway, if you are willing
to spend some efforts on getting multi
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/d
On 7/27/2013 10:28 AM, Olivier Austina wrote:
Hi John
It doesn't matter where the file is stored. I want to know if I can do
some processing like find similar photos or how many a given word
appear in the multimedia content ( e.g. an audio or video) using a
query language such as SQL.
SQL
Hi John
It doesn't matter where the file is stored. I want to know if I can do some
processing like find similar photos or how many a given word appear in the
multimedia content ( e.g. an audio or video) using a query language such as
SQL.
Regards
Olivier
2013/7/27 John R Pierce
> On 7/27/20
On 7/27/2013 6:24 AM, Olivier Austina wrote:
Can SQL be used to retrieve data from multimedia content such as
audio, video, image, full text?
it can if the data is stored in the sql database. however for large
files like video, I personally would prefer to store it in a file
system, and
