It’s better than running it on a separate server but if you’re using Postgres you’re always hitting the network stack on the machine, with SQLite that isn’t the case.
Postgres is great, but managing a fleet of them (one in each web server) and ensuring they are all working fine would bring a lot of operational complexity.
SQLite, on the other hand, skips all of that with its simple in-process model.
I just start postgres and it's solid. I don't understand this statement. With Dokku it's trivial.
the cool thing with sqlite is that you can compile your whole app into a single binary, so you don't need docker for example (or it's trivial to dockerize it afterwards if you really insist)
It is. I do this on plenty of hobby Laravel apps.
Me too, but I guess there could be even higher gains with SQLite when it's in-process...