Re: SQL for multimedia retrieval

Поиск
Список
Период
Сортировка
От Amit Langote
Тема Re: SQL for multimedia retrieval
Дата
Msg-id CA+HiwqGH0WHDuKYXy6DnRgGMD5r6EeFKv-QEKG0SqgM=s_H9ag@mail.gmail.com
обсуждение исходный текст
Ответ на SQL for multimedia retrieval  (Olivier Austina <olivier.austina@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Loïc Rollus
Дата:
Сообщение: Re: Trigger and deadlock
Следующее
От: Giuseppe Broccolo
Дата:
Сообщение: Re: postgres FDW cost estimation options unrecognized in 9.3-beta1