Publishing with Apache Kafka at The New York Times

Re:Publishing with Apache Kafka at The New York Times by qaq on Thursday September 07, 2017 @07:03AM (#15190645)

However, Postgres doesn't have good support for creating derived append-only logs ???? A one line trigger will give you derived append only log that is transactionally consistent.

[ Parent | on HN ]

Re:Publishing with Apache Kafka at The New York Times by elnygren on Thursday September 07, 2017 @07:09AM (#15190671)

so how does that one-liner transform data from log A to log B in realtime?

are talking about creating a new table or materialised views or stored procedures or...?

[ Parent | on HN ]

Re:Publishing with Apache Kafka at The New York Times by qaq on Thursday September 07, 2017 @07:18AM (#15190723)

In your post you are proposing to have a table be equivalent to a kafka topic. So derived "log"/topic can be another table updated with a trigger.

[ Parent | on HN ]