SQLite Forum

Concurrency not working
Login
No need to assume; see section "3.3 Persistence of WAL mode".

I hesitate to answer your 2nd question as both "concurrency-related features" and "default" are somewhat nebulous concepts for the SQLite project. There are whole doc pages on threading provisions and behavior, and what features get into a build with no options specified is a set that changes over time.