SQLite is great for multi-blogs / planets too - I use SQLite for the backend in the pluto tool [1] that helps running Planet Open Suse, Planet KDE and others.
[1] https://github.com/feedreader/pluto.starter
I wish my favorite feed reader, Miniflux, would support SQLite as an alternative to Postgres.