mastodon.me.uk is one of the many independent Mastodon servers you can use to participate in the fediverse.
Open, user-supported, corporation-free social media for the UK.

Administered by:

Server stats:

501
active users

James Smith 💾

Anyone out there who's an expert on concurrency, and would be willing to help out a little open source project with some debug advice? Boost for reach?

@lmorchard @Floppy We use rqlite (SQLite server) for that exact thing at $dayjob.

@lmorchard thanks, I’ll take a read and see if that gets me anywhere!

@markus it’s @manyfold - I’ve got some things to try, but basically trying how to learn to avoid the dreaded busy error…

@Floppy @manyfold in my experience, it’s simply a combination of using a busy wait and upgrading transactions to write transactions immediately (BEGIN IMMEDIATE) if you know they’ll write (because the latter doesn’t respect the busy wait). See sqlite.org/c3ref/busy_timeout. and sqlite.org/lang_transaction.ht

www.sqlite.orgSet A Busy Timeout

@markus @manyfold I found a blog just a little while ago that talks about exactly that in Rails apps, and why Rails apps get it wrong. Hoping that will solve the problem, or at least educate me! I shall read those links too 👍