Re: RPC via WebSockets.

Поиск
Список
Период
Сортировка
От Nikolay Samokhvalov
Тема Re: RPC via WebSockets.
Дата
Msg-id CANNMO+JpA8GqUosJMuEgdKeCovCQ0ou2OwuOf9jrMqus4pFGdQ@mail.gmail.com
обсуждение исходный текст
Ответ на RPC via WebSockets.  (Dmitry Igrishin <dmitigr@gmail.com>)
Ответы Re: RPC via WebSockets.
Список pgsql-general
This is a very common task, definitely.

As for WebSockets, there is an addition to PostgREST, postgrest-websockets 

PostgREST is not only for "give me contents", you can write functions (in any PL) and call them using POST /rpc/functionname.

There is also an attempt to build similar tool in Go (although I'm not sure how popular and powerful it is): pREST https://github.com/prest/prest

Finally, there is a whole line of trendy and quite popular tools for having GraphQL on top of Postgres, including but not limited to:

On Fri, Jan 17, 2020 at 13:18 Dmitry Igrishin <dmitigr@gmail.com> wrote:
Hello!

Who needs to talk to Postgres right from a WEB-browser via WebSockets? For example, conveniently call storable functions/procedures?

Yes, i know about PostgREST. But I want to focus on RPC via WebSockets without all these REST or "give me contents of that table by this URL" stuff...

I'm thinking about writing an application which is simple to install/deploy, simple to configure, with a connection pool built-in. Ideally, one binary and one config in JSON format.

I need some feedback before start. So please don't hesitate to share any of your thoughts/ideas/comments/scepticism here :-)

Thanks.

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

Предыдущее
От: Rob Sargent
Дата:
Сообщение: Re: jsonb_set() strictness considered harmful to data
Следующее
От: Dmitry Igrishin
Дата:
Сообщение: Re: RPC via WebSockets.