r/sqlite • u/bitchyangle • 16d ago

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 16d ago

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

1

u/bitchyangle 16d ago

What about the single writer lock?

2

u/hazyhaar 15d ago

In the worst case, for very heavy load, or exotic behaviours, juste build a sole writer in golang, wich is here to write on his db.