News for hackers. Stuff that matters.
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.

There are no comments on this comment yet.