[ENG-685] Sqlite Multithreaded

[oscartbeaumont]

IDK if this is actually gonna help but it can't hurt.

[linear[bot]]

ENG-685 Sqlite multithreaded

Try and sort this out once and for all

[vercel[bot]]

The latest updates on your projects. Learn more about Vercel for Git ↗︎

Name	Status	Preview	Comments	Updated (UTC)
spacedrive-landing	✅ Ready (Inspect)	Visit Preview	💬 Add feedback	Jun 20, 2023 8:10pm
spacedrive-web	✅ Ready (Inspect)	Visit Preview	💬 Add feedback	Jun 20, 2023 8:10pm

[fogodev]

We already enabled the WAL pragma on SQLite?

[oscartbeaumont]

I tried using pragma's in a raw execute statement but Prisma doesn't like it due to something about its return type. From the upstream issues I am fairly sure the param I have set here will make it so each query waits instead of just erroring if it can't acquire the DB lock.