Re: SQL for multimedia retrieval

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

In response to

Browse pgsql-general by date

  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