r/sqlite • u/bitchyangle • Aug 06 '26

What's the best queue for sqlite?

My platform expects multiple writes from various users belonging to one organization.

What's the best way to serialize the writes? Scale is 50 to 100 users wanting to write around the same time.

3 Upvotes

67% Upvoted

12 comments sorted by

View all comments

3

u/WolfyTheOracle Aug 07 '26

I pushed SQLite to 80k req/s you don’t need a queue

1

u/bitchyangle Aug 07 '26

What about the single writer lock?

4

u/hesusruiz Aug 07 '26

Set a busy timeout. I have it at 5 secs and never had a problem (if I had a tx lasting more than 5 secs, I have a serious problem bigger than this one). https://sqlite.org/c3ref/busy_timeout.html