There is a [Swift](https://hackernoon.com/tagged/swift) library that I enjoy almost daily because many apps I write use a database for local storage. [GRDB.swift](http://groue.github.io/GRDB.swift/) puts all bets on [SQLite](https://hackernoon.com/tagged/sqlite), a library that is both tremendously famous, and not very well-known.

![](https://pbs.twimg.com/profile_images/617237438822379521/6S3d-vMd_bigger.png)

SQLite is designed to be embedded, and to access local databases. This puts it quite apart from client-server databases, and brings a lot of unique features. Unfortunately very few developers use them, assuming they even know about their existence. This is because those features are usually unavailable unless you program in C.

There are also strong cultural assumptions about database libraries, from low-level drivers to full-fledged ORMs, with SQL query builders right in the middle. Breaking those assumptions requires a lot of communication and pedagogy, as exemplified by [Realm](https://realm.io), a database engine supported by a vivid community and a very active company.

The rest of this article lists a few unexpected features of SQLite and GRDB.

#### WAL Mode, aka Efficient Multithreading

WAL means [Write Ahead Logging](https://sqlite.org/wal.html). It is a technique that allows SQLite to support concurrent database readers and writers, and greatly improves multi-threaded applications. For example, the UI thread is never blocked when it loads data from the database.

GRDB supports WAL mode through the [DatabasePool](https://github.com/groue/GRDB.swift#database-pools) class, and provides a [concurrency guide](https://github.com/groue/GRDB.swift#concurrency) that covers the best practices for efficient multithreaded applications.

#### Reactive SQLite

SQLite provides [Data Change Notification Callbacks](https://sqlite.org/c3ref/update_hook.html), and [Compile-Time Authorization Callbacks](https://sqlite.org/c3ref/set_authorizer.html). The first notify of modified rows, when the latter tell which tables and columns are involved in an SQL statement.

When you combine them, you are able to tell if an SQL statement has the opportunity to affect the results of another query. This is the recipe for database observation through [RxGRDB](http://github.com/RxSwiftCommunity/RxGRDB) (a reactive extension for GRDB over RxSwift), or [FetchedRecordsController](https://github.com/groue/GRDB.swift#fetchedrecordscontroller) (a Swift version of Core Data’s NSFetchedResultsController).

#### A Protocol-Oriented ORM

An ORM ([Object-Relational Mapping](https://en.wikipedia.org/wiki/Object-relational_mapping)) maps the raw database rows to easy objects named records.

Features commonly found in ORMs are fetching and persistence methods, relationships, lazy loading, record auto-updating, and record uniquing. The last three of them are typical of ORMs that _manage_ records and pretend they directly map database rows. This illusion generally introduces a base class for all record types, and fences between application threads in order to avoid mutation of shared data.

The focus on immutability and [value types](https://developer.apple.com/swift/blog/?id=10) introduced by languages like Swift and Rust brings a new way to write an ORM: it is now possible to drop the common base class, share records across threads, and use the database as the single source of truth for the whole application. GRDB [records](https://github.com/groue/GRDB.swift#records) and Rust’s [Diesel](https://diesel.rs) build on those new foundations.

#### Useful Errors

Too many database libraries pretend database errors don’t happen, make it easy to overlook them, or emit inscrutable error messages. GRBD uses the full range of [Swift errors](https://github.com/apple/swift/blob/master/docs/ErrorHandlingRationale.rst), and provides as detailed [errors](https://github.com/groue/GRDB.swift#error-handling) as possible.

#### Hassle-Free SQL

GRDB welcomes developers who are not familiar with SQL and SQLite: its [query interface](https://github.com/groue/GRDB.swift#the-query-interface) makes it possible to access the database without writing a single line of SQL.

In the same time, no query builder can generate all possible queries, and the occasional complex query may be easier to read when written as plain SQL. That’s why GRDB makes sure that you never pay for your SQL skills.

For example, you can load records from SQL as well as from Swift requests:

// Two one liners that load the same array of Person:  
try Person.filter(emailColumn != nil).fetchAll(db)  
try Person.fetchAll(db, """  
    SELECT \* FROM persons  
    WHERE email IS NOT NULL  
    """)

[Reactive extensions](http://github.com/RxSwiftCommunity/RxGRDB) are just as versatile:

let request = SQLRequest("SELECT \* FROM persons")  
request.rx.changes(in: dbPool)  
  .subscribe(onNext: { db: Database in  
    print("Persons table has changed.")  
  })  
  
try dbPool.write { db in  
  try Person(name: "Arthur").insert(db)  
  try Person(name: "Barbara").insert(db)  
} // Prints "Persons table has changed."

In the same spirit, GRDB supports all kinds of primary, unique, and foreign keys: you can freely design the integrity of your relational schema, and escape the dreary `id` column when it does not fit the bill.

SQLite and GRDB are two libraries that deliver both simple and advanced tools that help developing applications. Check out the [documentation](http://github.com/groue/GRDB.swift#documentation) for more unexpected goodies such as advanced unicode support, record changes tracking, care for memory-constrained devices, tailored SQLite builds, customized full-text indexation…

[http://groue.github.io/GRDB.swift/](http://groue.github.io/GRDB.swift/)

This article is part of the GRDB Stories:

1.  [Fetching Values](https://medium.com/@gwendal.roue/grdb-stories-993b9d016867)
2.  [Memory Consumption](https://medium.com/@gwendal.roue/grdb-stories-cae49d47dc21)
3.  [Querying the Database from the Debugger](https://medium.com/@gwendal.roue/grdb-stories-592d03b42384)
4.  [Primary Key Freedom](https://medium.com/@gwendal.roue/grdb-stories-8c37a03ef72d)
5.  [FetchedRecordsController](https://medium.com/@gwendal.roue/grdb-stories-1da44bdb53ab)
6.  [Loose Coupling between Objects and Database](https://medium.com/@gwendal.roue/grdb-stories-9bfcfb8b6a88)
7.  [Four different ways to handle SQLite concurrency](https://medium.com/@gwendal.roue/four-different-ways-to-handle-sqlite-concurrency-db3bcc74d00e)
8.  [How to build an iOS application with GRDB.swift](https://medium.com/@gwendal.roue/how-to-build-an-ios-application-with-sqlite-and-grdb-swift-d023a06c29b3)
9.  **Unexpected SQLite with Swift**

> [Hacker Noon](http://bit.ly/Hackernoon) is how hackers start their afternoons. We’re a part of the [@AMI](http://bit.ly/atAMIatAMI)family. We are now [accepting submissions](http://bit.ly/hackernoonsubmission) and happy to [discuss advertising & sponsorship](mailto:partners@amipublications.com) opportunities.

> To learn more, [read our about page](https://goo.gl/4ofytp), [like/message us on Facebook](http://bit.ly/HackernoonFB), or simply, [tweet/DM @HackerNoon.](https://goo.gl/k7XYbx)

> If you enjoyed this story, we recommend reading our [latest tech stories](http://bit.ly/hackernoonlatestt) and [trending tech stories](https://hackernoon.com/trending). Until next time, don’t take the realities of the world for granted!

Apple

Facebook

Too Long; Didn't Read

Cassandra Forward a free Cassandra-focused community event

Unexpected SQLite with Swift

Too Long; Didn't Read

Companies Mentioned

@gwendal.roue

RELATED STORIES