News for hackers. Stuff that matters.
Re:Skip the API, Ship Your Database by oldnet on Thursday September 14, 2023 @04:04AM (#37506243)
Also you shouldn't give up access to your DB for security reasons.

That's why API exists at first place.

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.
Re:Skip the API, Ship Your Database by camgunz on Thursday September 14, 2023 @08:32AM (#37508048)
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.
Re:Skip the API, Ship Your Database by camgunz on Saturday September 16, 2023 @11:26AM (#37535615)
Yeah but this thread became about "you need an API".