It's a basic pub/sub system. The DB sends events to connected clients. You have a channel where a client can be in listening mode on and the DB or other clients can send events to. For example: tapoueh.org/blog/2018/07/postgresq...
Wow, I haven't worked with SQL Server since Rails came out in 2004.
I have to say, it must have been a cold day in hell when they approved porting SQL Server to Linux. Good for them, though. The irony is that I am now back on Windows 10, running PG inside of a headless WSL2 Ubuntu VM.
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
Tell us more about PG notifications? I'd love to see an example of how it works.
It's a basic pub/sub system. The DB sends events to connected clients. You have a channel where a client can be in listening mode on and the DB or other clients can send events to. For example: tapoueh.org/blog/2018/07/postgresq...
To be fair for comparison, SQL Server has service broker, which does the same. It also has became available on Linux recently 👌
But both are great RDBMSes!
Wow, I haven't worked with SQL Server since Rails came out in 2004.
I have to say, it must have been a cold day in hell when they approved porting SQL Server to Linux. Good for them, though. The irony is that I am now back on Windows 10, running PG inside of a headless WSL2 Ubuntu VM.