Better support for (Materialized) Views

[baderdean]

Nowadays NoSQL db are very widespread because they're easy to use. One of the main key advantages is the ability to retrieve a graph/tree instead of doing a lot of JOINs in SQL. But there's an easy solution in SQL: views, and especially materialized views for better performance. Yet, in Supabase, views are not very well supported:

• no realtime support : https://github.com/orgs/supabase/discussions/3824
• no incremental updates extension support: https://github.com/sraoss/pg_ivm
• less supported in Studio: https://github.com/orgs/supabase/discussions/14981

If the solution you recommend is not views but rather a dedicated flat table "One Big Table" or any other solution, it should be said somewhere in the docs.

[felipe-linares]

+1 our team is looking to use pg_ivm and didn't see it supported... it's even mentioned in a supabase article despite: https://supabase.com/blog/seen-by-in-postgresql

[beaupd]

+1 pg_ivm would also be a solution for a performance problem in my product, would love to see it supported!