gem-hunter
Language: Swift
PostgreSQL Provider for the Vapor web framework.
Adds PostgreSQL support to the Vapor web framework.
The PostgreSQL C driver must be installed in order to use this package.
Follow the README of the cpostgresql repo to get started.
Note that the process is different for Swift 3 and 4.
Add the dependency to project
.Package(url: "https://github.com/vapor-community/postgresql-provider.git", majorVersion: 2, minor: 1)
.package(url: "https://github.com/vapor-community/postgresql-provider.git", .upToNextMajor(from: "2.1.0")) // ... .target(name: "App", dependencies: ["Vapor", "FluentProvider", "PostgreSQLProvider"], ...)
Fetch dependencies and regenerate the Xcode project
vapor update
import Vapor import PostgreSQLProvider let config = try Config() try config.addProvider(PostgreSQLProvider.Provider.self) let drop = try Droplet(config)
Once the provider is added to your Droplet, you can configure Fluent to use the PostgreSQL driver.
Config/fluent.json
"driver": "postgresql"
Here is an example of a simple PostgreSQL configuration file.
Config/secrets/postgresql.json
{
"hostname": "127.0.0.1",
"user": "postgres",
"password": "hello",
"database": "test",
"port": 5432
}Alternatively, you can set a url with the configuration parameters.
Config/secrets/postgresql.json
{
"url": "psql://user:pass@hostname:5432/database"
}Read replicas can be supplied by passing a single master hostname and an array of readReplicas hostnames.
Config/secrets/postgresql.json
{
"master": "master.postgresql.foo.com",
"readReplicas": ["read01.postgresql.foo.com", "read02.postgresql.foo.com"],
"user": "postgres",
"password": "hello",
"database": "test",
"port": 5432
}You can get access to the PostgreSQL Driver on the droplet.
import Vapor import PostgreSQLProvider let postgresqlDriver = try drop.postgresql()