I hear you about the need for simplistic hosting.
However I doubt shoving everything into the DB will get us there - besides some hardcore PG enthusiasts like OP & co.
Sqlite together with the application layer of your choice seems to make much more sense to me, but hey we don't have to all like the same stuff (better we don't).
Also without reading too much in detail but I wonder how testing/monitoring etc would be supported