@toa.io/storages.sql NPM

SQL Connector

TL;DR

sql: pg://host0.example.com/production

Supported Databases

Implemented using Knex, therefore could support same databases.

Integrations only with PostgreSQL and Amazon Redshift are tested and pg is the only driver installed.

Annotation

Uses Pointer Annotation.

Drivers

Pointer annotation URIs must contain protocol identifying the driver to access the database.

Protocol	Database
`pg:`	PostgreSQL, CockroachDB and Amazon Redshift
`mysql:`	MySQL or MariaDB
`tedious:`	MSSQL

See Knex documentation for details.

Database, Schema, Table

Pointer annotation URIs must contain path following convention /database/schema/table, where table and schema are optional. Default values for schema and table are component's namespace and name respectively.

Namespace-wide or default values must not contain table name and default value must not contain schema.

Local Environment

On local environment protocol is pg:. Database name can be set by TOA_STORAGES_SQL_DATABASE environment variable. Also see Pointer's local environment.

PostgreSQL is using username's value as default name for the database and Pointer is using developer as default username on local environment. That is, default database name on local environment is developer.

Examples

sql:
  default: pg://host0.example.com:5432/production
  dummies.dummy: mysql://host1.example.com/marketing/stats/dummies

Migration

Migration only supports local environments and is used for development and testing purposes.

See tests for details.

@toa.io/console @toa.io/generic @toa.io/pointer knex pg

@everything-registry/sub-chunk-924 @toa.io/runtime

13 days ago

13 days ago

13 days ago

13 days ago

16 days ago

19 days ago

17 days ago

19 days ago

23 days ago

23 days ago

1 month ago

2 months ago

2 months ago

2 months ago

2 months ago

2 months ago

2 months ago

2 months ago

2 months ago

2 months ago

2 months ago

2 months ago

2 months ago

3 months ago

3 months ago

3 months ago

3 months ago

3 months ago

3 months ago

3 months ago

3 months ago

3 months ago

3 months ago

3 months ago

3 months ago

3 months ago

3 months ago

3 months ago

3 months ago

3 months ago

6 months ago

5 months ago

5 months ago

6 months ago

6 months ago

6 months ago

7 months ago

7 months ago

6 months ago

11 months ago

6 months ago

6 months ago

6 months ago

6 months ago

6 months ago

6 months ago

6 months ago

6 months ago

6 months ago

6 months ago

6 months ago

6 months ago

7 months ago

9 months ago

8 months ago

8 months ago

7 months ago

9 months ago

9 months ago

9 months ago

9 months ago

9 months ago

9 months ago

11 months ago

11 months ago

7 months ago

11 months ago

11 months ago

11 months ago

11 months ago

11 months ago

11 months ago

11 months ago

12 months ago

11 months ago

11 months ago

11 months ago

12 months ago

1 year ago

12 months ago

12 months ago

1 year ago

12 months ago

12 months ago

12 months ago

12 months ago

12 months ago

12 months ago

12 months ago

12 months ago

1 year ago

12 months ago

12 months ago

12 months ago

12 months ago

12 months ago

1 year ago

12 months ago

1 year ago

12 months ago

12 months ago

12 months ago

12 months ago

1 year ago

12 months ago

12 months ago

1 year ago

1 year ago

1 year ago

1 year ago

12 months ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago