Re:SQLite now allows multiple recursive SELECT statements in...
by zimpenfish on Thursday October 22, 2020 @03:58AM
(#24855830)
> You can do this sort of inference in a view if you use relational databases.
You'd need to use recursive queries though, I think, and there be dragons.
> [materialized views] can make it a bit challenging to manage updates
We're not using them with Postgres because refreshing materialized views is very much a blunt hammer and it'd cause more hassle than it would solve. Which is annoying because they've been great when I've used them previously.
You can do this sort of inference in a view if you use relational databases. (A view is a sort of "virtual" table based on the result of some database query. Many databases can also materialize views for improved performance, though this can make it a bit challenging to manage updates.)