The sqlite model is that only one write transaction can be run at a time. That's kind of a defining trade-off because it allows simplifying locking.