Not in WAL mode: readers and writers can proceed without blocking one another. Checkpoints can be an issue for concurrency, but that can be worked around.