I had geo data to find a new city to move out, with lat lon, population, price, etc

I just used leaflet, it was fine

spatialite is also good enough as a spatial database

unless you are doing complex stuff with GIS data, I don't see the point of using such a large software

leaflet is a tile rendering library. You can't edit or massage the data in any way, and most GIS work is not that complex--but it does require handling paths and other things that leaflet cannot really do.