What changed

Write-ahead logging removed most concurrency pain, and modern hardware made single-node capacity far larger than assumed. Zero network latency turns out to be a considerable advantage.

Where it fits

Read-heavy applications with a single writer, edge deployments and anything valuing operational simplicity. No server to run, no connection pool to tune.

Where it does not

Multiple concurrent writers across machines. That constraint is architectural and no amount of tuning removes it.