Summary

I hope you now know the steps to handle databases in QGIS. While QGIS can handle multiple databases, we used the GeoPackage as it provides a good amount of functionality with little overhead or administration.

Using the DBManager, you can perform a number of operations on databases. Some operations of note are creating indices, spatial and aspatial views, importing and exporting, and performing queries. From the introduction to the DBManager and GeoPackage (and SpatiaLite) in this chapter, you are now well-equipped to write more complex queries that take full advantage of SQL commands and SpatiaLite SQL extension commands. 

In the next two chapters, we will start to look at styling and rendering options and techniques for vector and raster data. This chapter looks at how to work with vector data especially how to merge vectors, convert vector geometries, how to use...