Classes

A type-erased cursor of Element.

This cursor forwards its next() method to an arbitrary underlying cursor having the same Element type, hiding the specifics of the underlying cursor.

A Database connection.

You don’t create a database directly. Instead, you use a DatabaseQueue, or a DatabasePool:

let dbQueue = DatabaseQueue(...)

// The Database is the `db` in the closure:
try dbQueue.write { db in
    try Player(...).insert(db)
}

A Collation is a string comparison function used by SQLite.

An SQL function or aggregate.

A DatabasePool grants concurrent accesses to an SQLite database.

A DatabaseQueue serializes access to an SQLite database.

A type-erased DatabaseReader

Instances of AnyDatabaseReader forward their methods to an arbitrary underlying database reader.

A DatabaseSnapshot sees an unchanging database content, as it existed at the moment it was created.

See DatabasePool.makeSnapshot()

For more information, read about snapshot isolation at https://sqlite.org/isolation.html

A cursor of database values extracted from a single column. For example:

try dbQueue.read { db in
    let urls: DatabaseValueCursor<URL> = try URL.fetchCursor(db, sql: "SELECT url FROM link")
    while let url = urls.next() { // URL
        print(url)
    }
}

A cursor of optional database values extracted from a single column. For example:

try dbQueue.read { db in
    let urls: NullableDatabaseValueCursor<URL> = try Optional<URL>.fetchCursor(db, sql: "SELECT url FROM link")
    while let url = urls.next() { // URL?
        print(url)
    }
}

A future database value, returned by the DatabaseWriter.concurrentRead(_:) method.

let futureCount: Future<Int> = try writer.writeWithoutTransaction { db in
    try Player(...).insert()

    // Count players concurrently
    return writer.concurrentRead { db in
        return try Player.fetchCount()
    }
}

let count: Int = try futureCount.wait()

A type-erased DatabaseWriter

Instances of AnyDatabaseWriter forward their methods to an arbitrary underlying database writer.

A database row.

A cursor of database rows. For example:

try dbQueue.read { db in
    let rows: RowCursor = try Row.fetchCursor(db, sql: "SELECT * FROM player")
}

A statement represents an SQL query.

It is the base class of UpdateStatement that executes update statements, and SelectStatement that fetches rows.

A subclass of Statement that fetches database rows.

You create SelectStatement with the Database.makeSelectStatement() method:

try dbQueue.read { db in
    let statement = try db.makeSelectStatement(sql: "SELECT COUNT(*) FROM player WHERE score > ?")
    let moreThanTwentyCount = try Int.fetchOne(statement, arguments: [20])!
    let moreThanThirtyCount = try Int.fetchOne(statement, arguments: [30])!
}

A subclass of Statement that executes SQL queries.

You create UpdateStatement with the Database.makeUpdateStatement() method:

try dbQueue.inTransaction { db in
    let statement = try db.makeUpdateStatement(sql: "INSERT INTO player (name) VALUES (?)")
    try statement.execute(arguments: ["Arthur"])
    try statement.execute(arguments: ["Barbara"])
    return .commit
}

A cursor of database values extracted from a single column. For example:

try dbQueue.read { db in
    let names: ColumnCursor<String> = try String.fetchCursor(db, sql: "SELECT name FROM player")
    while let name = names.next() { // String
        print(name)
    }
}

A cursor of optional database values extracted from a single column. For example:

try dbQueue.read { db in
    let emails: FastNullableDatabaseValueCursor<String> =
        try Optional<String>.fetchCursor(db, sql: "SELECT email FROM player")
    while let email = emails.next() { // String?
        print(email ?? "<NULL>")
    }
}

The FTS3TableDefinition class lets you define columns of a FTS3 virtual table.

You don’t create instances of this class. Instead, you use the Database create(virtualTable:using:) method:

try db.create(virtualTable: "document", using: FTS3()) { t in // t is FTS3TableDefinition
    t.column("content")
}

The FTS4TableDefinition class lets you define columns of a FTS4 virtual table.

You don’t create instances of this class. Instead, you use the Database create(virtualTable:using:) method:

try db.create(virtualTable: "document", using: FTS4()) { t in // t is FTS4TableDefinition
    t.column("content")
}

See https://www.sqlite.org/fts3.html

The FTS4ColumnDefinition class lets you refine a column of an FTS4 virtual table.

You get instances of this class when you create an FTS4 table:

try db.create(virtualTable: "document", using: FTS4()) { t in
    t.column("content")      // FTS4ColumnDefinition
}

See https://www.sqlite.org/fts3.html

The FTS5TableDefinition class lets you define columns of a FTS5 virtual table.

You don’t create instances of this class. Instead, you use the Database create(virtualTable:using:) method:

try db.create(virtualTable: "document", using: FTS5()) { t in // t is FTS5TableDefinition
    t.column("content")
}

See https://www.sqlite.org/fts5.html

The FTS5ColumnDefinition class lets you refine a column of an FTS5 virtual table.

You get instances of this class when you create an FTS5 table:

try db.create(virtualTable: "document", using: FTS5()) { t in
    t.column("content")      // FTS5ColumnDefinition
}

See https://www.sqlite.org/fts5.html

Experimental

A TableAlias identifies a table in a request.

The TableDefinition class lets you define table columns and constraints.

You don’t create instances of this class. Instead, you use the Database create(table:) method:

try db.create(table: "player") { t in // t is TableDefinition
    t.column(...)
}

See https://www.sqlite.org/lang_createtable.html

The TableAlteration class lets you alter database tables.

You don’t create instances of this class. Instead, you use the Database alter(table:) method:

try db.alter(table: "player") { t in // t is TableAlteration
    t.add(column: ...)
}

See https://www.sqlite.org/lang_altertable.html

The ColumnDefinition class lets you refine a table column.

You get instances of this class when you create or alter a database table:

try db.create(table: "player") { t in
    t.column(...)      // ColumnDefinition
}

try db.alter(table: "player") { t in
    t.add(column: ...) // ColumnDefinition
}

See https://www.sqlite.org/lang_createtable.html and https://www.sqlite.org/lang_altertable.html

A cursor of records. For example:

struct Player : FetchableRecord { ... }
try dbQueue.read { db in
    let players: RecordCursor<Player> = try Player.fetchCursor(db, sql: "SELECT * FROM player")
}

You use FetchedRecordsController to track changes in the results of an SQLite request.

See https://github.com/groue/GRDB.swift#fetchedrecordscontroller for more information.

Record is a class that wraps a table row, or the result of any query. It is designed to be subclassed.