Re: SQL for multimedia retrieval

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 <pierce(at)hogranch(dot)com>

> 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 use SQL simply to reference it by filename.
>
>
>
> --
> john r pierce 37N 122W
> somewhere on the middle of the left coast
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/**mailpref/pgsql-general<http://www.postgresql.org/mailpref/pgsql-general>
>