Hacker News new | ask | show | jobs
by samwillis 678 days 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) to make it even more efficient.

3 comments

Oh! That's really clever. The live queries make this a very compelling tool for some form of local first development.
Cool!! Is this available outside of pglite or does it require it for some reason? I could see this being very widely useful.
The existing list of extensions is already quite impressive. But addition of pg_ivm would really take it to the next level.