Re: PL/pgSQL HTTP Request

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: PL/pgSQL HTTP Request
Дата
Msg-id CAFj8pRAxX6640h6BXX12GwBcMviUD_A3hGF8VuM2T9s2Y2=n+Q@mail.gmail.com
обсуждение исходный текст
Ответ на PL/pgSQL HTTP Request  (Sathish Kumar <satcse88@gmail.com>)
Ответы Re: PL/pgSQL HTTP Request
Список pgsql-general
Hi

pá 7. 12. 2018 v 14:48 odesílatel Sathish Kumar <satcse88@gmail.com> napsal:
Hi Team,

Do PL/pgSQL support to create a function to make HTTP request. We have a requirement to send data to external server from Postgres DB using HTTP/HTTPS Post Method.


Surely It doesn't support it. You can use some untrusted language - but it is not safe.

you can use https://github.com/pramsey/pgsql-http extension. It is much better, but still it not good idea. Stored procedures are perfect for work inside database. Communication with outer world is not good

a) outer world is not transactional
b) outer world is too slow.

This is task for application (communication) server.

Regards

Pavel

В списке pgsql-general по дате отправления:

Предыдущее
От: Sathish Kumar
Дата:
Сообщение: PL/pgSQL HTTP Request
Следующее
От: Sathish Kumar
Дата:
Сообщение: Re: PL/pgSQL HTTP Request