Add an option to allow WAL mode for sqlite connections

[ricardo-elevenpaths]

Hello,

I'm looking into the possibility to share database data/missions among other team members, since jok3r is using sqlite there is not too much we can do, for that reason I am trying to share local.db using a docker volume within a bucket in Google Cloud Storage (https://www.youtube.com/watch?v=4Z4mQqQ92tc), theorically, sharing a volume with the db location of one jok3r instance, and enabling WAL mode for the sqlite connections, it should allow to work with multiples jok3r container instances pointing to the same db.

I am not an expert programming in python but as far as I know the way it can be done either:

pragmas = [ ('journal_mode', 'wal'), ('cache_size', -1000 * 32)] db = SqliteExtDatabase('blog.db', pragmas=pragmas)

OR
db:sqlite:foo.db?foreign_keys=ON;journal_mode=WAL

OR
conn.execute('pragma journal_mode=wal')

I didn't find any place where to set and test it, has anyone try it before?

[koutto]

Sorry for the delayed reply. I am currently working on a lot of improvment. Among them, sqlite will be replaced by postgresql with a dedicated container for the database. Stay tuned !