[camgunz]

PostgreSQL 9.5 (7.5 years old) shipped row-level security [0] which solves this.

[0]: https://www.postgresql.org/docs/15/ddl-rowsecurity.html

[yencabulator]

The architecture described in the article replicates the SQLite database on the page level.

[camgunz]

Yeah but this thread became about "you need an API".