On the whole I've found that the tooling around postgres/postgis is always slightly better. Most other people publising scripts and tools for doing various type

On the whole I've found that the tooling around postgres/postgis is always slightly better. Most other people publising scripts and tools for doing various types of analysis also seem to use postgres/postgis so it's more likely to be able to borrow someone else's good idea. Postgres/PostGIS has a whole bunch of features and commands that sqlite/spatialite don't have and even if don't think I'll need them it's always nice to have the option. And since installing and setting up Postges on windows and mac is just a single download and double-click these days, there really isn't a good reason not to do so.