News for hackers. Stuff that matters.
Re:SQLite now allows multiple recursive SELECT statements in... by zozbot234 on Wednesday October 21, 2020 @07:30PM (#24853444)
> But can also infer transitive relations based on those predicates - `A canSee B`, `B canSee C` => `A canSee C` - which is handy when you're trying to discover those relationships in your data.

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.)

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.