SQLite Storage Adapter

[aaguiarz]

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 #57 before this one.

[golanglemonade]

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.

[rhamzeh]

This has been completed thanks to @DanCech 's contribution.

It will be released shortly in v1.6.1