Creating a spatial database in QGIS is a simple task to perform. QGIS comes with two spatial database types that can be easily created without the need to install or set up anything.
SpatialLite and GeoPackages are relational databases that are stored as flat files. What this means is that the data is stored within a single file and not on traditional server-based database applications such as Oracle or Postgres/PostGIS.
We will be dealing with GeoPackages in this chapter, which is an OGC compliant GeoSpatial format. It is open source format and is consumed by most GIS packages, including ESRI, MapInfo, and QGIS.
SpatiaLite (SQLite) is built on a single-user architecture, which makes the installation and management virtually nonexistent. The trade-off, however, is that it neither does a good job of supporting multiple concurrent connections, nor does...
