Spatialite is the defacto standard to pair with Postgis. It is is a phenomenally useful piece of software and probably the first thing to reach for if you are doing GIS work.