libsql Use `WAL` as default everywhere

Currently, Turso (the platform), libsql-sever, and embedded replicas use WAL mode and it is the only mode supported. However libsql drivers don't have WAL mode as default. Let's change that to use WAL everywhere.

reported here: https://discord.com/channels/933071162680958986/1154725980183732224/1261642078694150144

Jul 14 '24 03:07 avinassh

Can I work on this? @avinassh please assign me

Jul 20 '24 21:07 imskr

@imskr sure! feel free to work on it

I would start with the Rust driver first: https://github.com/tursodatabase/libsql/tree/main/libsql

Jul 22 '24 09:07 avinassh

Thanks @avinassh I was looking to set

PRAGMA journal_mode = wal

In the rust driver I don't see journal_mode, Can you point me to the right place?

Jul 22 '24 10:07 imskr

Any pointer on this @avinassh ?

Jul 24 '24 14:07 imskr

I don't think it is that simple as we don't set any journal mode and use the defaults. I would probably find the methods where we are creating new connections and setup the journal mode appropriately.

Jul 24 '24 15:07 avinassh