search

tursodatabase / libsql

libSQL is a fork of SQLite that is both Open Source, and Open Contributions.
https://turso.tech/libsql
MIT License
9.53k stars 251 forks source link

Users, access restrictions, GRANT etc #10

Open dyasny opened 1 year ago

dyasny commented 1 year ago

sqlite has no access restrictions, it is assumed that anyone with access to the OS, has access to the data. In a distributed system, we might want to add some security features, like authentication, authorization. RBAC etc.

coxley commented 1 year ago

Is this really in scope for libsql?

If the SQLite use-case is to package a lightweight database with your application to be closer, and the libsql goal is to do that but distributed, would access be treated the same as the rest of the application?

Then again, building something like Cloudflare's D1 would likely need it. ¯_(ツ)_/¯

dyasny commented 1 year ago

Right now we're simply tossing in ideas, this one can either get prioritized or dropped, but it's good to have it listed to start with.