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:
- PostGraphile https://github.com/graphile/postgraphile
- Prisma https://github.com/prisma/prisma
On Fri, Jan 17, 2020 at 13:18 Dmitry Igrishin <dmitigr@xxxxxxxxx> 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.
