Re:Skip the API, Ship Your Database
by vbezhenar on Thursday September 14, 2023 @04:48AM
(#37506471)
Technically you can create different users with very precise access permissions. Might not be the good idea to provide that kind of API to the general public, but if your clients are trustworthy, it might work.
Re:Skip the API, Ship Your Database
by berniedurfee on Thursday September 14, 2023 @07:29PM
(#37516182)
No clients are trustworthy.
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
Re:Skip the API, Ship Your Database
by yencabulator on Friday September 15, 2023 @07:52PM
(#37530468)
The architecture described in the article replicates the SQLite database on the page level.
That's why API exists at first place.