Was really interested in just the Sqlite portion, and am so glad you showed ignoring designating types for the field. You have likely saved me many future minutes! Thank you.
I know in my bones that the concept presented here about 1 process programming makes a ton of sense. I just don't get how I practically implement it, for say a simple REST API reading from a SQLite database.
It comes with time don't worry about it. This level of engineering happens when you start to understand that reliable software is a many-thousand-hour exercise not a late night and a red bull away - and believe me the feeling is miserable because simultaneously you'll understand all those cool apps you always wanted to build aren't actually worth the time.
24:24 "I can scale my server until I hit a limit" if you multiply your server N times and put a simple proxy in front of it which redirects traffic "tenant => server" (with some kind of in-memory tenant table), then you can scale further. So far doesn't sound like rocket science to me tbh.