Wrote an internal tool using SQLite. Encountered countless DBLocked exceptions rendering it useless.
Switched to a mssql db w same exact source code and ran flawlessly.
Sounds to me the problem lies in SQLite default config.
> How do you get around SQLite's write limits?
Listen, SQLite can handle thousands of writes and a ton more reads per second.
If you're hitting these limits, congratulations. You're probably very rich at this point and can hire someone, if not a team, to figure it out for you.
If you're far from these limits, and thinking about workarounds, you're probably doing something wrong.
Feb 17, 2024 · 4:19 PM UTC
