loading...

Asynchronous Notifications in Postgres

Michael Kohl on July 07, 2018

I'm fascinated by Postgres: the more I learn about it, the more I realize how much I still don't know. Recently I discovered its asynchronous commu... [Read Full]
markdown guide
 

Postgresql is full of gems, I still have to explore foreign data wrappers for example.

I wonder how much toll this feature takes on the database in case of an app with heavy writing load. I wouldn't want the db to perform worse because it has a queue of payloads to send back to the app

 

Good point, though probably a bridge I'd not try to cross before hitting that heavy write load. Over the years I saw too many people complicate their architecture before there was a need a for it, so my current approach nowadays is generally "simplest thing that can possibly work". It's way easier to add more layers/tech later than to rip out something that was added at the very beginning of a project.

 

Over the years I saw too many people complicate their architecture before there was a need a for it, so my current approach nowadays is generally "simplest thing that can possibly work". It's way easier to add more layers/tech later than to rip out something that was added at the very beginning of a project.

Yeah, I'm definitely guilty of over engineering in the early days but I think I developed an enzyme that reacts everytime it gets in contact with over engineered stuff sounding an alarm :D

But I still try to keep an eye on the "future direction"

I'm sure we've all been guilty of this at one point or another. I worked a lot with early stage startups, where this is extra important, because if you spend too much time on the wrong thing there is no future. That said, I also do keep the future direction in mind and generally outline the rationale for doing it the current way plus possible future alternatives in comments.

 

Cool, but doesn't it tie you too heavily to the database? I honestly don't see a clear use case here. O.o

 

For example two applications already connected to the same DB.

code of conduct - report abuse