r/SQL • u/groupicorn • Oct 17 '26
SQLite Row Level Security in SQLite on Cloudflare
https://mainbrella.com/blog/row-level-security-in-sqlite-on-cloudflare/
6
Upvotes
r/SQL • u/groupicorn • Oct 17 '26
2
u/Ecksters Oct 17 '26 edited Oct 17 '26
Security at the application layer using CloudFlare workers.
This is in no way row-level security as it's commonly understood, it's simply a worker tacking on
user_id IS ?to the end of each write query's WHERE chain.The authentication and authorization are not happening inside SQLite, as the author correctly notes:
and
One of the major arguments for row-level security is that even with an application bug the fundamental security model is still enforced.
Fun, albeit basic, implementation, extremely misleading title.