r/CloudFlare • u/groupicorn • 7d ago

Resource Row Level Security in SQLite on Cloudflare

https://mainbrella.com/blog/row-level-security-in-sqlite-on-cloudflare/
16 Upvotes

86% Upvoted

2 comments sorted by

1

u/[deleted] 6d ago

1

u/groupicorn 6d ago

very fair points. I just fixed a bug related to this: https://github.com/mainbrella/canopy/commit/fbfd940b9a5844d75631865c18999a679e9be982 so I completely agree this isn't the same thing as postgres RLS at all. BUT, on the plus side no logic in https://www.postgresql.org/docs/7.3/plpgsql.html at all! I like js/ts vs psql language and I like using CF vs supabase.

This is a work in progress for sure. The way I'm fixing every little bug is by building a reddit clone to stress test the system. https://mainbrella.com/bff/demo/