6.0.69 • Published 4 years ago

@zxteam/sql-postgres v6.0.69

Weekly downloads
1
License
MIT
Repository
github
Last release
4 years ago

ZXTeam's PostgreSQL Facade

npm version badge downloads badge commit activity badge last commit badge twitter badge

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
6.0.69

4 years ago

6.0.68

5 years ago

6.0.66

5 years ago

6.0.64

5 years ago

6.0.63

5 years ago

6.0.60

5 years ago

6.0.59

5 years ago

6.0.57

5 years ago

6.0.56

5 years ago

6.0.53

5 years ago

6.0.50

5 years ago

6.0.48

6 years ago

6.0.47

6 years ago

6.0.46

6 years ago

6.0.45

6 years ago

6.0.43

6 years ago

6.0.42

6 years ago

6.0.41

6 years ago

6.0.40

6 years ago

6.0.38

6 years ago

6.0.36

6 years ago

6.0.35

6 years ago