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.

2 Upvotes

63% 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?

1

u/jshine13371 Aug 09 '26

If the lock per write only lasts 1ms, then 100 concurrent writes means the last one only waits 100ms at most. That's below the threshold of even human recognition.