In simplest case, you do sudo apt install ... in both cases, connect to database and do your work..

I have never had a Postgres install go that easily. There’s still initialization and setup of the server and users. And you’ll have to do something about upgrades as well. Postgres isn’t difficult to set up but SQLite is just a file. It’s much simpler.

And that’s only the installation. Interaction with SQLite as a database is also simpler.

They both have uses but it’s strange to me to assert that they’re equally complex.

> There’s still initialization and setup of the server and users.

that command will create postgres user in the system, you do su to that user, run psql and you all set.

> And you’ll have to do something about upgrades as well

apt will take care of it too

> but SQLite is just a file

there is some "file" in postgresql distribution, people just don't use it, because why they would?

> Interaction with SQLite as a database is also simpler.

any specifics?

SQLite datatypes are advisory so it pretty much just accepts anything you give it.

PostgreSQL definitely says no to schema violations.

These are both features.