What is a solution for reading/writing a local datastore for QGIS?
I've got data that's too large for a shapefile, I need lengthy column titles, but don't want to be logging into a remote server. I've been giving Spatialite a good go but seem to bump up against limitations like not being able to delete columns plus it seems there is little development going on in this space. I use the QSpatialite plugin.
I'm thinking I should be getting in db views, but don't see any workflows there for Spatialite.
Is there another option for a FOSS local datastore?