4 ms·
You can run postgres on the same host as the web server too. Isn't that going to get you most of that same benefit in speed?
by boxed 3y ago
You can run postgres on the same host as the web server too. Isn't that going to get you most of that same benefit in speed?
- yurishimo 3y agoIt is. I do this on plenty of hobby Laravel apps.
- boxed 3y agoMe too, but I guess there could be even higher gains with SQLite when it's in-process...
- cztomsik 3y agothe 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)
- giovannibonetti 3y agoPostgres 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.
- boxed 3y agoI just start postgres and it's solid. I don't understand this statement. With Dokku it's trivial.
- kevinak 3y agoIt’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.