r/sqlite

Dear all,

I have a probably very newbie question but I have a small Python/PySide6 desktop app that uses SQLite databases and our office would like to use it at work, however, my research suggests that SharePoint/OneDrive we use at work could corrupt the database if more of us writes inside them. Is that correct please, and if it is, what options would we have to deploy it? We have an ICT department who would set it up, but I just want to be prepared and know our options before presenting it to them.

This was just a hobby project for me to learn Python but would love to have real use for this little app.

Thank you for all your replies in advance.

i used to use vscode sql DB extension, unfortunately, i am max out with the free version, as i am limited to 3 DB connection instance, and i have to constantly swap out the connection instance...

thus i created this to solve my issue, as i work a lot of development viewing multiple different sqlite DBs

hopefully this simple DB explorer is helpful for everyone

I ordered the cheapest Hetzner CX23 ($4.99/mo, shared-resources tier) and ran a real-workload SQLite benchmark on it. Not a microbenchmark — a 6 GB database on a box with 3.7 GB of RAM, so reads actually have to touch disk.

Mixed OLTP workload (70% reads, 25% updates, 5% inserts): 3.9k ops/s, p99 = 710 µs, p999 = 2.2 ms.

= 14 million ops/hour on a $5 VPS, with sub-3 ms tail latency.