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

1