Knetik Micro Sql

This package adds the objection sql client to any micro-core application as a multi tenant adaptor.

When a customer connects to a micro-core application, the required app_id is passed into the sql initializer and used for multi tenancy support.

Setup

Install the @knetik/micro-sql package

yarn add @knetik/micro-sql

Add the Adaptor to your config/environments/{env}.json/js

"ADAPTORS": [
  "@knetik/micro-sql"
]

Add the SQL configs as well

SQL_CLIENT: string,
SQL_HOST: string,
SQL_USER: string,
SQL_PASS: string,
SQL_PORT: string,
SQL_DB: string,
SQL_SSL: string

Documentation

More info is available in the DOCS