In part 1: “Getting started with GRDB”, we covered how to setup a local SQLite database for your iOS app, how to write migrations, how to adopt GRDB’s protocols within a struct that can then be saved to the database, and lastly we went over some basic querying. In part 2, we’ll have a look at how to observe and react to changes in the database, how to define relationships between tables, and how to save a custom types.

Designed to provide local data storage for individual applications and devices, SQLite is a small, fast, highly reliable SQL database engine that I have a lot of love for. GRDB is a fantastic SQLite toolkit maintained by Gwendal Roué that does all the hard work for us: it provides, amongst other features, a query interface so we don’t have to write raw SQL (though you can still do that if you need to), migrations, database observation, and encryption.