News for hackers. Stuff that matters.
Re:Stop building databases by johnny22 on Friday December 01, 2023 @01:01PM (#38489936)
postgres has some capability to do that, but does need a server.
Re:Stop building databases by matlin on Friday December 01, 2023 @01:12PM (#38490101)
Yeah you can subscribe to overall changes to the data on a row by row basis but can't subscribe to an actual query. Many apps and libraries imitate reactive queries by just refetching all queries from Postgres when any data changes or just repeatedly polling the query every 10 seconds or so but this puts a lot of strain on the database. You can just subscribe to the replication stream but then you're left trying to reconstruct your queries in your application code which is extremely error prone and painful
Re:Stop building databases by cpursley on Saturday December 02, 2023 @03:19AM (#38496959)
Could you explain in more detail the use case for subscribing to the actual queries (instead of the change events)?