8

Does anyone know if there is some kind of documentation on which database types that you can connect to in QGIS? I would also like to know if:

Can I use the databases for read only or read & write.

GforGIS
  • 3,126
  • 3
  • 19
  • 38
Andersson
  • 383
  • 5
  • 12

2 Answers2

12

QGIS supports

  • PostGIS - including a dedicated PostGIS Manager plugin for seamless work
  • Spatialite - there is also Spatialite Manager
  • MSSQL 2008 Spatial - also supported by default starting from version 1.8
  • Oracle Spatial - via OGR but not by default & Oracle Spatial GeoRaster plugin
  • ESRI File/(Personal) Geodatabase - via OGR

All database connections support read&write access (except for the Personal Geodatabase which is read-only via OGR).

Glorfindel
  • 1,096
  • 2
  • 9
  • 14
underdark
  • 84,148
  • 21
  • 231
  • 413
  • Thanks, I'm working on my Bachelor dissertation. Comparing QGIS with ArcGIS Desktop Basic. Hopefully to turn some eyes on a great software in ESRI-dominating world ;) – Andersson May 30 '12 at 19:09
  • 1
    Direct connection to PostGIS was the main reason we moved to QGIS. Cost is usually the most important factor to business. – Mapperz May 30 '12 at 20:30
  • @Andersson As an end user of their APIs I can tell you that, at least up to 2005, ESRI was dominating because they provided the highest quality solution. The primary area of complaint for me was that address interpolation used by the majority of other providers, was woefully inadequate for anything more than consumer internet driving directions, and sometimes not even for all of those use cases. Secondarily, no other providers had the scope of data that ESRI did. Finding free data was a piecemeal, time consuming and unreliable task. That said, a lot can change in six years time. –  May 30 '12 at 20:59
  • @Joshua. Well, I'm a fresh to the GIS-area compared to others here, but in Sweden (Where Im from) ESRI is dominating the field and sometimes It's seems, without reason. Many users are sitting on expensive software when non-charge open source-software can do the same thing. – Andersson May 31 '12 at 05:09
2

The first place I would start looking is the QGIS.org website. Here is a link to the page for Documentation

In general, QGIS supports the GDAL/OGR Feature Libraries. To quote the OGR main page:

The OGR Simple Features Library is a C++ open source library (and commandline tools) providing read (and sometimes write) access to a variety of vector file formats including ESRI Shapefiles, S-57, SDTS, PostGIS, Oracle Spatial, and Mapinfo mid/mif and TAB formats.

Here is a list of supported formats, including a number of different databases, that are supported by GDAL/OGR, and thus, QGIS. OGR Vector Formats.

Some of the databases include

  • PostGreSQL
  • SQLite/Spatialite
  • ESRI Personal/File Geodatabase
  • MySQL
Get Spatial
  • 13,259
  • 6
  • 41
  • 68