News for hackers. Stuff that matters.
Re:Listen to your to PostgreSQL database in realtime via Web... by kitd on Friday April 30, 2021 @11:12AM (#26994453)
Nice!

Can you go in the other direction, ie push via WS into a table? Obviously you'd need the correct auth.

I had an idea of doing something similar with MQTT. Data at rest and data in motion in 1 (or maybe 1.5) components.

Re:Listen to your to PostgreSQL database in realtime via Web... by jordan801 on Friday April 30, 2021 @12:16PM (#26995399)
Sure can! I contributed on this project a few months ago. Hoping to use it soon on a project.

I implemented a portion of crud with a vuejs app. It's a pretty neat setup. Just authorize with OAuth2 and then if you have permissions youre good to go!

Re:Listen to your to PostgreSQL database in realtime via Web... by edoceo on Friday April 30, 2021 @11:56AM (#26995109)
yea, thats pretty easy. a small Go/Rust/whatever program to do WS and write (well formed, authenticated) message data via INSERT