What 200 Concurrent Users Taught Me About SQLite Performance

I was about to release Autentico 2.0. The feature work was done, tests were passing, docs were updated. Before tagging the release I figured I'd spend some time on performance. Run some stress tests, see where things stand, maybe squeeze out some easy wins. What followed was a week-long detour through profiling, architecture design, benchmarking, and a humbling lesson about assumptions. Autentico is a self-contained OAuth 2.0 / OpenID Connect identity provider built with Go and SQLite. One binar