Extensions

Swift’s Optional comes with built-in methods that allow to fetch cursors and arrays of optional DatabaseValueConvertible:

try Optional<String>.fetchCursor(db, sql: "SELECT name FROM ...", arguments:...) // Cursor of String?
try Optional<String>.fetchAll(db, sql: "SELECT name FROM ...", arguments:...)    // [String?]

let statement = try db.makeSelectStatement(sql: "SELECT name FROM ...")
try Optional<String>.fetchCursor(statement, arguments:...) // Cursor of String?
try Optional<String>.fetchAll(statement, arguments:...)    // [String?]

DatabaseValueConvertible is adopted by Bool, Int, String, etc.

CGFloat adopts DatabaseValueConvertible

Data is convertible to and from DatabaseValue.

NSDate is stored in the database using the format yyyy-MM-dd HH:mm:ss.SSS, in the UTC time zone.

Date is stored in the database using the format yyyy-MM-dd HH:mm:ss.SSS, in the UTC time zone.

NSData is convertible to and from DatabaseValue.

NSNull adopts DatabaseValueConvertible

NSNumber adopts DatabaseValueConvertible

NSString adopts DatabaseValueConvertible

NSURL stores its absoluteString in the database.

NSUUID adopts DatabaseValueConvertible

UUID adopts DatabaseValueConvertible

Bool adopts DatabaseValueConvertible and StatementColumnConvertible.

Int adopts DatabaseValueConvertible and StatementColumnConvertible.

Int8 adopts DatabaseValueConvertible and StatementColumnConvertible.

Int16 adopts DatabaseValueConvertible and StatementColumnConvertible.

Int32 adopts DatabaseValueConvertible and StatementColumnConvertible.

Int64 adopts DatabaseValueConvertible and StatementColumnConvertible.

UInt adopts DatabaseValueConvertible and StatementColumnConvertible.

UInt8 adopts DatabaseValueConvertible and StatementColumnConvertible.

UInt16 adopts DatabaseValueConvertible and StatementColumnConvertible.

UInt32 adopts DatabaseValueConvertible and StatementColumnConvertible.

UInt64 adopts DatabaseValueConvertible and StatementColumnConvertible.

Double adopts DatabaseValueConvertible and StatementColumnConvertible.

Float adopts DatabaseValueConvertible and StatementColumnConvertible.

String adopts DatabaseValueConvertible and StatementColumnConvertible.