Re: SQL for multimedia retrieval - Mailing list pgsql-general

From Amit Langote
Subject Re: SQL for multimedia retrieval
Date
Msg-id CA+HiwqGH0WHDuKYXy6DnRgGMD5r6EeFKv-QEKG0SqgM=s_H9ag@mail.gmail.com
Whole thread Raw
In response to SQL for multimedia retrieval  (Olivier Austina <olivier.austina@gmail.com>)
List pgsql-general
On Sat, Jul 27, 2013 at 10:24 PM, Olivier Austina
<olivier.austina@gmail.com> 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 multimedia content retrieval to work
in PostgreSQL, you could use GiST
(http://www.postgresql.org/docs/9.2/static/gist.html) and write custom
indexing methods. These methods would define your content retrieval
criteria while GiST itself provides an interface so that you could
store and retrieve the indexed content using PostgreSQL.


--
Amit Langote


pgsql-general by date:

Previous
From: Loïc Rollus
Date:
Subject: Re: Trigger and deadlock
Next
From: Giuseppe Broccolo
Date:
Subject: Re: postgres FDW cost estimation options unrecognized in 9.3-beta1