[ZitchDog]

> 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 / aggregations?

[samwillis]

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) to make it even more efficient.

[netghost]

Oh! That's really clever. The live queries make this a very compelling tool for some form of local first development.

[ZitchDog]

Cool!! Is this available outside of pglite or does it require it for some reason? I could see this being very widely useful.

[cheema33]

The existing list of extensions is already quite impressive. But addition of pg_ivm would really take it to the next level.