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?

  • these words from Sandro himself anyway please carefully consider just a couple of further details: - in SQLite implementing a Writable View is certainly possible, but critically depends on Trigger actions - in very few words: it's like walking on thin ice.
    – BillW
    Apr 4, 2017 at 6:35
  • 2
    I would stil suggest to use either SpatiaLite or GeoPackage. Keep Spatialite-gui available if you want to drop columns or create views.
    – user30184
    Apr 4, 2017 at 6:43
  • H2GIS is another single file GIS database. It has many nice features. Hardly anybody is using it.
    – user30184
    Apr 4, 2017 at 7:42
  • user30184, I spent some time looking there at H2GIS, but it is not able to connect to QGIS?
    – BillW
    Apr 5, 2017 at 1:16
  • And now I can't seem to get SpatiaLite-Gui established on this machine!! Frustration.
    – BillW
    Apr 5, 2017 at 1:19

1 Answer 1


How about a local PostGIS instance? PostgeSQL can be downloaded from https://www.postgresql.org/download/ to which a PostGIS extension can be created to make it a spatial database. Also recommended would be to download pgAdmin https://www.pgadmin.org/

See How do I setup a PostGIS database and open it in QGIS on Windows? which may help with the set up.

  • One additional point, Postgres is extremely powerful, and FAST!
    – Matt
    Apr 4, 2017 at 8:37
  • 1
    Yes, I have had some experience with PostGIS, but the establishment, maintenance and lack of portability of that is a discouragement. Thanks
    – BillW
    Apr 5, 2017 at 1:18
  • There is a portable PostGIS archaeogeek.com/portable-gis.html and postgresonline.com/journal/archives/… Apr 5, 2017 at 6:18
  • @BillW Did you come up with a satisfactory solution to a FOSS datastore? Jul 6, 2017 at 21:11

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.