Hello, I didn't find this question in the mailing list archive (although it's difficult to search).
Is there any plan to support materialized views? By that I mean views whose result is stored permanently in a table and that is updated automatically every time the underlying tables are updated. Implementing them manually with triggers can be difficult and error-prone when the query is complex. Having sqlite do it would not only guaranty the correctness of the result, it could also be optimized. For instance by updating the view lazily. In my case the source tables contain time series and are therefore mostly inserted in. The query I need to run has several layers of CTEs with WINDOW and a GROUP BY. I need to run it several times with different GROUP BY conditions and a different time frame selection. So there's a lot of redundant computation between the different queries. And even more when I re-run my program when new data points have been inserted. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
