SQLiteStore

import SQLiteStore

do {
    let dbPath = "/path/to/the/database/file"
    try Database.open(dbPath) { db in
        try db.executeStatement("INSERT INTO user (id, name, lastname) VALUES (@id, @name, @lastname)", parameters: [
            "@id": 1,
            "@name": "John",
            "@lastname": "Smith"
        ])
        let user = try db.selectFirst("SELECT name, lastname FROM user WHERE id = ?", parameters: [1])
    }
} catch {
    print(error)
}

do {
    let dbPath = "/path/to/the/database/file"
    try Database.open(dbPath) { db in
        let query = """
        INSERT INTO user (
            id,
            name,
            lastname
        ) VALUES (
            @id,
            @name,
            @lastname
        )
        """
        try db.prepareStatement(query) { stmt in
            try stmt.bindInt(1, forName: "@id")
            try stmt.bindString("John", forName: "@name")
            try stmt.bindString("Smith", forName: "@lastname")
            try stmt.step()
        }

        var users: [User] = []
        try db.prepareStatement("SELECT id, name, lastname FROM user") { stmt in
            while try stmt.step() {
                users.append(User(
                    id: stmt.getInt(forName: "id")!,
                    name: stmt.getString(forName: "name")!,
                    lastname: stmt.getString(forName: "lastname")!
                ))
            }
        }
    }
} catch {
    print(error)
}