To use Swift-Kuery-SQLite you must install SQLite.
You can install SQLite with Homebrew:
$ brew install sqlite
Or, if you prefer MacPorts, you can use that too, though note that you need to symlink a file into the place that Homebrew installs it:
$ port install sqlite3 $ mkdir -p /usr/local/opt/sqlite/include $ ln -s /opt/local/include/sqlite3.h /usr/local/opt/sqlite/include/
$ sudo apt-get install sqlite3 libsqlite3-dev
Swift-Kuery-SQLite package to the dependencies within your application’s
Package.swift file. Substitute
"x.x.x" with the latest
.package(url: "https://github.com/IBM-Swift/Swift-Kuery-SQLite.git", from: "x.x.x")
SwiftKuerySQLite to your target's dependencies:
.target(name: "example", dependencies: ["SwiftKuerySQLite"]),
First create an instance of
Swift-Kuery-SQLite by calling:
let connection = SQLiteConnection(filename: "myDB.db")
You don't have to pass a filename, if you choose not to pass in a filename then your database will be in-memory.
To establish a connection call:
connection.connect(onCompletion: (QueryError?) -> ())
If you want to have multiple connections to your database you can create a
ConnectionPool as follows:
let pool = SQLiteConnection.createPool(filename: "myDB.db", poolOptions: ConnectionPoolOptions(initialCapacity: 10, maxCapacity: 30, timeout: 10000)) let connection = pool.getConnection()
Note, you don't have to pass a filename to the
createPool method, if you choose not to pass in a filename then your pool will be shared in-memory.
You now have a connection that can be used to execute SQL queries created using Swift-Kuery. View the Kuery documentation for more information, or see the Database Connectivity with Kuery chapter of the Kitura Until Dawn guidebook/tutorial.
For more information visit our API reference.
We love to talk server-side Swift, and Kitura. Join our Slack to meet the team!
This library is licensed under Apache 2.0. Full license text is available in LICENSE.
Help us keep the lights on
1.1.0 - Jun 4, 2018
- Handle Mixed Casing
- Support Auto Increment
- Update Swift-Kuery to 2.0.0
1.0.0 - Apr 6, 2018
- Convert to Swift 4 package
- Support Swift 4.1