3 ms·
> What about if the DB itself supported a psuedo-PHP runtime, or better yet closer to native code? Note that in PostgreSQL, user defined functions can be writt
by vog 10y ago
> What about if the DB itself supported a psuedo-PHP runtime, or better yet closer to native code?
Note that in PostgreSQL, user defined functions can be written in many languages, including SQL but also Python (very well supported) and PHP (not so well supported, but doable).
- josephg 10y agoPost 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.