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?

Improve this question
6
  • 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
    Commented 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
    Commented Apr 4, 2017 at 6:43
  • H2GIS is another single file GIS database. It has many nice features. Hardly anybody is using it.
    – user30184
    Commented 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
    Commented Apr 5, 2017 at 1:16
  • And now I can't seem to get SpatiaLite-Gui established on this machine!! Frustration.
    – BillW
    Commented Apr 5, 2017 at 1:19

1 Answer 1

Reset to default
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.

Improve this answer
4
  • One additional point, Postgres is extremely powerful, and FAST!
    – Matt
    Commented 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
    Commented Apr 5, 2017 at 1:18
  • There is a portable PostGIS archaeogeek.com/portable-gis.html and postgresonline.com/journal/archives/…
    – Martin Hügi
    Commented Apr 5, 2017 at 6:18
  • @BillW Did you come up with a satisfactory solution to a FOSS datastore?
    – Martin Hügi
    Commented Jul 6, 2017 at 21:11

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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