@zxteam/sql-postgres v6.0.69

ZXTeam's PostgreSQL Facade

Version table

CREATE TABLE "__dbVersion" (
	"version" VARCHAR(64) NOT NULL PRIMARY KEY,
	"utc_deployed_at" TIMESTAMP WITHOUT TIME ZONE NOT NULL DEFAULT (now() AT TIME ZONE 'utc'),
	"log" TEXT NOT NULL
)

NOTE: Name of table may be overriden via migration's opts

Connection URL

Format

postgres://[${user}[:${password}]]@${host}[:${port}]/${databaseName}[?app=${applicationName}&schema=${defaultSchema}]
postgres+ssl://[${user}[:${password}]]@${host}[:${port}]/${databaseName}[?app=${applicationName}&schema=${defaultSchema}]

Examples

Localhost

postgres://localhost:5432/postgres

Remote PostgreSQL server my_pg_host with SSL prefer mode (no certificate validation, just for encryption)

postgres+ssl://my_pg_host:5432/postgres

Note: For full SSL mode you need to pass opts.ssl programically. Passing certificates via URL does not supported.

Development Notes

Postgres inside Docker

Start

docker kill postgres10devdb; docker rm postgres10devdb; docker run --name postgres10devdb --rm --publish 5432:5432 --detach zxteamorg/devel.postgres-10:20200914

Start + run tests

docker kill postgres10devdb; docker rm postgres10devdb; docker run --name postgres10devdb --rm --publish 5432:5432 --detach zxteamorg/devel.postgres-10:20200914; sleep 5; npm run build && npm run test:local