Hands-On Server-Side Web Development with Swift

Setting up the SQLite database driver

You may follow the same steps for setting up a PostgreSQL database connection to create a SQLite database. All the setup for the SQLite database goes to the initializeJournalRoutes(app:) function in JournalRoutes.swift.

1. Create an instance of Swift-Kuery-SQLite by calling the .createPool method of SQLiteConnection:

let pool = SQLiteConnection.createPool(filename: "sqlite.db",                                        poolOptions: ConnectionPoolOptions(initialCapacity: 10,                                                                         maxCapacity: 30,                                                                          timeout: 10000)) Database.default = Database(pool)

ConnectionPool allows you to support multiple connections to your SQLite database. If you omit a filename, your database will be in-memory.

2. If you want a single connection, you can create SQLiteConnection ...