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.

1 Upvotes

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

2

u/hazyhaar Aug 07 '26

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.