Synor Database PostgreSQL

Synor Database Engine - PostgreSQL

Installation

``sh


using yarn:

yarn add @synor/database-postgresql pg

using npm:

npm install --save @synor/database-postgresql pg
`

URI

Format: postgresql://[user[:password]@][hostname][:port]/database[?param=value&...]

Params:

| Name | Description | Default Value |
| ------------------------------ | ----------------------------------------------------------------------------- | ------------------------ |
| schema | PostgreSQL Schema | public |
| ssl | SSL configuration | false |
| synor_migration_record_table | Name for Migration Record Table | synor_migration_record |

Examples:

- postgresql://postgres:postgres@127.0.0.1:5432/synor?synor_migration_record_table=migration_record
- postgresql://postgres:postgres@127.0.0.1:5432/synor?schema=synor

`js
// SSL Example

const ssl = {
ca: '',
cert: '',
key: '',
passphrase: '',
rejectUnauthorized: '',
secureOptions: '',
}

const uri = postgresql://postgres:postgres@127.0.0.1:5432/synor?ssl=${encodeURIComponent(
JSON.stringify(ssl)
)}
``

License

Licensed under the MIT License. Check the LICENSE file for details.