3 ms·
I really want to do streaming queries over updates and inserts in a normal SQL database. Imagine writing SUBSCRIBE SELECT customers.id, customers.name
by strken 5y ago
I really want to do streaming queries over updates and inserts in a normal SQL database. Imagine writing
SUBSCRIBE SELECT customers.id, customers.name
FROM EVENTS(customer_purchases) AS cpe
LEFT OUTER JOIN customers ON cpe.row.customer_id = customers.id
WHERE cpe.row.product_id = '123abc' AND cpe.type IN ('update', 'insert')
in postgres itself and just getting every incoming purchase for a particular product.
- gigatexal 5y agoI wonder if Materalize gets you close?
- strken 5y agoMaterialize excites me, but probably can't be used for the current problems I'm working on, because of the operational overhead we'd be putting on our clients. Streaming SQL queries inside an existing well-understood database would be the killer feature.
- hchasestevens 5y agohttps://ksqldb.io/ https://ksqldb.io/ is great for this, assuming you're already using Kafka.
- splike 5y agoSomeone with more in depth knowledge can tell me why this isn't a good idea, but I'm pretty sure you can get something very close to this with graphql subscription query against hasura backed with postgres