SQLite Storage Adapter - Githubissues

openfga / roadmap

OpenFGA Public Roadmap

2 stars 0 forks source link

SQLite Storage Adapter #56

Open aaguiarz opened 3 months ago

aaguiarz commented 3 months ago

There are different use cases for which a SQLite storage adapter would be useful:

Embedded/Mobile scenarios, where you want to bundle OpenFGA as a library + SQLite
Deploying OpenFGA instances as a sidecar with static data in SQLite, or synchronized to a centralized OpenFGA instance using the /changes endpoint.
If you are using SQLite as you main database and you don't want to operate a different one

We'd like to do https://github.com/openfga/roadmap/issues/57 before this one.

golanglemonade commented 3 months ago

Thanks @aaguiarz! Happy to help contribute here. We are using turso for our main databases, and were interested in this to lessen the sprawl of our state machines. They maintain a fork of sqlite, libsql and they also have golang clients. We were also throwing around the idea of sidecar scenario you mentioned in the use cases. Let me know how I can help.