SQLite concurrent writes and "database is locked" errors (tenthousandmeters.com)

This is an interesting and approachable write-up.