13 ms·

> it has a reactive "live query" API Very cool! Most of the examples for reactive queries are very basic (only single tables). Do live queries support joins /

• samwillis 2y ago
  Yes, they should all work. We save the query as a view and then introspect it to see what tables it depends on. It then uses pg_notify to watch for changes. The plan is to integrate pg_ivm (https://github.com/sraoss/pg_ivm https://github.com/sraoss/pg_ivm) to make it even more efficient.
  • cheema33 2y ago
    The existing list of extensions is already quite impressive. But addition of pg_ivm would really take it to the next level.
  • ZitchDog 2y ago
    Cool!! Is this available outside of pglite or does it require it for some reason? I could see this being very widely useful.
  • netghost 2y ago
    Oh! That's really clever. The live queries make this a very compelling tool for some form of local first development.