Fix not-regexp operator, add case insensitive regexp operators

Fixes the notRegexp operator and adds the two case-insensitive variants (#139, #90).

See the pgsql docs for reference.

Fix assertion while decoding JSON (non-JSONB)

Fixes JSON / JSONB decoding for text and binary serializations (#177).

Add EventLoopGroupConnectionPool database convenience

This patch was authored and released by @tanner0101.

Adds a method for creating a PostgresDatabase from an EventLoopGroupConnectionPool.

let db = pool.database(logger: .init(label: "test"))

Release Candidate 1

Updates to Swift 5.2 and macOS 10.15.

Release candidates represent the final shift toward focusing on bug fixes and documentation. Breaking changes will only be accepted for critical issues. We expect a final release of this package shortly after Swift 5.2's release date.

Alter table syntax

Implement Postgres alter table syntax in SQLDialect.

Support encoding non-JSON arrays

Adds support for encoding arrays that contain values besides nested structs (JSON and JSONB).

Added create/drop trigger dialect conditions

Updates the package to specify syntax that PostgreSQL supports for triggers.

Add support for configuring connections via UNIX domain socket

Add support for configuring connections via UNIX domain socket (#170).

PostgresConfiguration(
    unixDomainSocketPath: "/tmp/.s.PGSQL.5432",
    username: "postgres",
    password: "postgres",
    database: "postgres"
)

Support JSON or JSONB for decoding structs

Adds support for both JSON and JSONB data types when decoding nested structs. Error messages in PostgresDataDecoder have also been improved.

Enum Support

vapor/sql-kit#85