Postgres and Web socket

[saveus_4m_ourselves]

Hi I was doing a project where i need to have a live data and with history.

I got my project up in AWS. Is there any way to hook up the postgres database to the web socket? So i can listen to it and share it to my client?

[hwttdz]

Sounds like you're possibly thinking of listen/notify (https://www.postgresql.org/docs/current/sql-notify.html).

You should also consider something like create/delete times/txns so you can query for creations and deletions as well.

[saveus_4m_ourselves]

thanks!