9 ms·
Post author here. I actually think it would be much cleaner to support an event log API and run this stuff out-of-process. My database shouldn't have to support
by josephg 10y ago
Post author here. I actually think it would be much cleaner to support an event log API and run this stuff out-of-process. My database shouldn't have to support the language-de-jour, and I don't want my react rendering process slowing down my database servers. You can totally decouple this stuff with a clean kafka-like eventlog API, but postgres doesn't provide one.
- agentultra 10y agoYes it does. There many ways you can do it too. See the docs for NOTIFY/LISTEN for an easy built in solution. Use a trigger to write to a log table for durability. And the time travel functions. All with the powerful query engine. There are projects to stream all operations straight into Kafka. The nice thing about Postgres is that it's also extensible. PipelineDB, Citus, etc.