From: | Amit Langote <amitlangote09(at)gmail(dot)com> |
---|---|
To: | Olivier Austina <olivier(dot)austina(at)gmail(dot)com> |
Cc: | Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: SQL for multimedia retrieval |
Date: | 2013-07-29 09:11:24 |
Message-ID: | CA+HiwqGH0WHDuKYXy6DnRgGMD5r6EeFKv-QEKG0SqgM=s_H9ag@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sat, Jul 27, 2013 at 10:24 PM, Olivier Austina
<olivier(dot)austina(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Giuseppe Broccolo | 2013-07-29 10:00:46 | Re: postgres FDW cost estimation options unrecognized in 9.3-beta1 |
Previous Message | Loïc Rollus | 2013-07-29 08:35:33 | Re: Trigger and deadlock |