JackHopkins
Automatically generate an SQLite DB by default
Currently, we require a Postgres database set up.
This is a pain for new users.
Instead, we should just create an SQLite DB to use by default, instead of relying on the user setting up a service.
Is anyone working on this? if not i can raise a pr, want to start contributing to this project !
I see there's already a partial SQLiteDBClient implementation in db_client.py (about 6 methods need SQLite conversion). I'll complete this implementation to make SQLite fully functional, then we can decide on defaults/migration strategy once it's working?
There is already a sqllite implementation and support, it's included in the readme as well. We might just need to make it the default db and create a script for setting it up more easily
okay I see it, my bad! I hadnt fully gone through the readme and was just going off based on the code itself. Let me run everything end to end, tho i did come across an issue which ive raised #214
