SQLite does really well for locking writes as well as soon as you activate the WAL.