SQLiteExpress

// Create a new in-memory database `db` and require extended errors to be thrown.
let db = try SQLiteDatabase(extendedErrors: true)

// Create a new table in `db`.
let stmt0 = try db.prepare(sql: """
    CREATE TABLE Contacts (
      id INTEGER PRIMARY KEY,
      name TEXT NOT NULL,
      email TEXT NOT NULL UNIQUE,
      phone TEXT
    );
  """)
try stmt0.step()
stmt0.finalize()

// Enter two rows into the new table.
let stmt1 = try db.prepare(sql: """
    INSERT INTO Contacts VALUES (?, ?, ?, ?);
  """)
try stmt1.bind(integer: 1000, toParam: 1)
try stmt1.bind(text: "Mickey Mouse", toParam: 2)
try stmt1.bind(text: "mickey@disney.net", toParam: 3)
try stmt1.bind(text: "+1 101-123-456", toParam: 4)
try stmt1.step()
try stmt1.bind(integer: 1001, toParam: 1)
try stmt1.bind(text: "Donald Duck", toParam: 2)
try stmt1.bind(text: "donald@disney.net", toParam: 3)
try stmt1.bind(text: "+1 101-123-456", toParam: 4)
try stmt1.step()
stmt1.finalize()

// Cound the number of distinct phone numbers.
let stmt2 = try db.prepare(sql: """
    SELECT COUNT(DISTINCT phone) FROM Contacts;
  """)
try stmt2.step()
let phoneNumbers = try stmt2.int(atColumn: 0)
Swift.print("Number of distinct phone numbers: \(phoneNumbers)")
stmt2.finalize()

// Show all names and email addresses from the `Contacts` table.
let stmt3 = try db.prepare(sql: """
    SELECT name, email FROM Contacts;
  """)
Swift.print("Entries in table:")
while try !stmt3.step() {
 Swift.print("\(try stmt3.text(atColumn: 0)!), \(try stmt3.text(atColumn: 1)!)")
}
stmt3.finalize()