Postgres Pro
Downloads
Home   >   mailing lists

Re: RPC via WebSockets. - Mailing list pgsql-general

From Nikolay Samokhvalov
Subject Re: RPC via WebSockets.
Date
Msg-id CANNMO+JpA8GqUosJMuEgdKeCovCQ0ou2OwuOf9jrMqus4pFGdQ@mail.gmail.com
Whole thread Raw
In response to RPC via WebSockets.  (Dmitry Igrishin <dmitigr@gmail.com>)
Responses Re: RPC via WebSockets.
List pgsql-general
Tree view
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 by date:

Previous
From: Rob Sargent
Date:
Subject: Re: jsonb_set() strictness considered harmful to data
Next
From: Dmitry Igrishin
Date:
Subject: Re: RPC via WebSockets.