3

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 '17 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 '17 at 6:43
  • H2GIS is another single file GIS database. It has many nice features. Hardly anybody is using it. – user30184 Apr 4 '17 at 7:42
  • user30184, I spent some time looking there at H2GIS, but it is not able to connect to QGIS? – BillW Apr 5 '17 at 1:16
  • And now I can't seem to get SpatiaLite-Gui established on this machine!! Frustration. – BillW Apr 5 '17 at 1:19
11

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.

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.