Hi @silverblatt!
The short answer to all of that is yes! You’re basically spot on. When you start a site, that kicks on the database engine along with PHP. Then you can work on your site, or access the database with Adminer. When you stop the site, everything is saved/updated before shutting down.