How to use postgres or SQL Server with nestjs

The docs show examples of how to conenct to a database using TypeORM and Sequilize, or you can roll your own dynamic module with custom providers if you want to use something else. There are a few packages around for knex, pg-promise, and massiveORM. These should all be more than suitable for enterprise applications, but if anything shows up as an issue, make sure to notify the owners of the repository.

Here is the basic structure I created to set up my current project with NestJS and PostgreSQL just in case this helps.

1. I added the following packages:

   $ npm install --save knex objection objection-graphql pg 
   

2. Created the nest database module and added this module to the "imports" and "exports" within the app.module.ts:

./src/database/database.module.ts

2. Then added the following files and folders:

./src/database/migrations

./src/database/models

./src/database/base.model.ts

./src/database/user.model.ts

./src/database/seeds

./src/database/migration.stub

./src/database/seed.stub

3. At the root level, I placed the knexfile.ts

import 'dotenv/config';
import Knex from 'knex';
import { knexSnakeCaseMappers } from 'objection';

module.exports = {
  development: {
    client: 'pg',
    connection: process.env.DATABASE_URL,
    migrations: {
      directory: './src/database/migrations',
      stub: './src/database/migration.stub',
    },
    seeds: {
      directory: './src/database/seeds',
      stub: './src/database/seed.stub'
    },
    ...knexSnakeCaseMappers()
  },
  production: {
    client: 'pg',
    connectio: process.env.DATABASE_URL,
    migrations: {
      directory: __dirname + '/database/migrations',
    },
    seeds: {
      directory: __dirname + '/database/seeds/production',
    },
  },
} as Knex.Config;

4. Then for each new Module, I called the model from the database folder

import { UserModel } from '../database/models/user.model'

That's it. Here you have connected PostgreSQL with NestJS.

As others have mentioned the NestJS manual is a well written resource for a detailed reference.

RON