Author here. Built this after writing the same D1 boilerplate across multiple Workers projects. Main idea: Kysely for type-safe query building, simple DSL for migrations, zero runtime overhead.
Leafletjs was the only oss frontend option back in 2015-2016 when we ditched Esri and created our own in-house app, based on Electron. Apart from Mapbox, which was freemium.
It's been around for a long time and is really powerful when compared to other open source web-based mapping/GIS options - unfortunately I never really need the advanced features in the projects I tend to work on.
We do use ansible for provisioning in combination with AWS CDK. The cases are simple as when you don't utilize container services, but roll out your own server infrastructure using EC2.
The point is that had they worked well, containers may not have become as popular as they are now.
Containers are only somewhat used for scalable microservices. They're mostly just an easier way to deploy software than creating your own RPM package and using orchestration tools to deploy it on VMs.
I hope that you do understand the difference of server provisioning and container orchestration, as mentioned above, solve completely different problems.