Working with databases

Using QGIS, we can work with various databases, such as SpatiaLite, PostGIS, MSSQL, and Oracle Spatial. We'll learn here how to create a SpatiaLite database. We'll also learn to import shapefiles into such databases.

Creating a SpatiaLite database

The steps for creating a SpatiaLite database are as follows:

1. We need to right-click on SpatiaLite in the Browser panel and then click on Create Database.
2. We browse to the folder where we want to create the database, give it a name (I named it Chapter3_test), and save it.
3. We see an arrow to the left of SpatiaLite. Click on this arrow:

4. We'll see the newly created database under SpatiaLite:

5. Use the DB Manager plugin under Database to check...