[3np]

I disagree. If you don't need any database-specific funtionality, are OK with the least-common denominator, why not?

I run a large number of open-source software privately. It would be a way smaller number if I couldn't use them with Postgres.

Many users and projects will start on sqlite but as they mature migrate to clustered instances of a hosted database. It's great that this can be supported without each project implementing every DB.

I have been the user hitting a bug (which I was able to submit a fix for) in the scenario you describe. I much prefer that to not using the software at all or setting up a MySQL instance.