Explore using Logical Streaming Replication Protocol for change notifications

[janbjorge]

Explore using Logical Streaming Replication Protocol for change notifications, aiming to bypass the overhead introduced by event triggers. This approach, theoretically, should streamline capturing database changes by leveraging built-in PostgreSQL mechanisms.

[janbjorge]

Seems like an interesting approach; https://github.com/janbjorge/PGStreamReplica dealing with all the types of auth. seems like the biggest hurdle for now.