@sqlpm/tag-postgresql

tag-postgresql

support tagging including domains and hierarchical tags via ltree (https://www.postgresql.org/docs/14/ltree.html).

Introduction

This package contains re-usable Postgresql sql ddl. The package is installed using a traditional node package manager such as npm, yarn or pnpm. Applying the sql located in the package to a Postgresql database instance can be done by using Sql Package Manager or a migration tool of your choosing.

This package has:

• definitions - Sql is stored within the package.
• Testing, BDD/TDD - Testing is done using the jest testing framework but the tests are written in Sql. True behavior driven development is supported via yarn test:postgresql:watch.
• versioned - Versioning is used and supported via lerna.
• dependencies - The dependency features of the javascript package manager are leveraged. Sql Package Manager projects can depend on other projects.

Usage

// TODO

Generated

This package was generated form the root of this repository as follows:

yarn sqlpm generate '{"packageName": "tag", "databaseSystem": "postgresql", "description": "support tagging including domains and hierarchical tags via ltree (https://www.postgresql.org/docs/14/ltree.html).", "author": "...", "email": "...", "purposes": ["readwrite"], "actions": ["run", "test", "reset"]}'

yarn lerna add @sqlpm/sqlpm-lib-ts --scope=@sqlpm/tag-postgresql

# Add the universal schema dependency
yarn lerna add @sqlpm/universal-postgresql --scope=@sqlpm/tag-postgresql

# Add the iso schema dependency
yarn lerna add @sqlpm/iso-postgresql --scope=@sqlpm/tag-postgresql