Drizzle ORM multiple schemas

[iursevla]

Since I've seen multiple issues popping up related to multiple schemas using Drizzle and since I'm using multiple schemas on a project I'm developing, then I've created the following repository to showcase how to do it: https://github.com/iursevla/nestjs-drizzle-multiple-schemas (special thanks to @frenzzy for the dynamic schema idea)

Related to Drizzle ORM I have the following:

• Multiple schemas and respective tests
• Custom logger (with interpolated queries)
• Example with reusable DAO
  • abstract.dao shows a way to abstract some commonly reused queries, e.g.,
    • getAll - get all entries for a specific entity
    • getById - get entries with specific id
    • getBySingleKey - get all entries with a specific value for the given key
    • insertNewRecord - insert a new entry given a partial entity
    • deleteById - Delete from the table row with the given id
    • updateById - Update row with the given id

Note: I'm using a UUID id as PK for the table I'm showing in this showcase, but you can change it to whatever you want.

This repository also shows many other things but mostly related to NestJS.

[Kokleng-Dev]

Since I've seen multiple issues popping up related to multiple schemas using Drizzle and since I'm using multiple schemas on a project I'm developing, then I've created the following repository to showcase how to do it: https://github.com/iursevla/nestjs-drizzle-multiple-schemas (special thanks to @frenzzy for the dynamic schema idea)

Related to Drizzle ORM I have the following:

• Multiple schemas and respective tests

• Custom logger (with interpolated queries)

• Example with reusable DAO

  • abstract.dao shows a way to abstract some commonly reused queries, e.g.,

    • getAll - get all entries for a specific entity
    • getById - get entries with specific id
    • getBySingleKey - get all entries with a specific value for the given key
    • insertNewRecord - insert a new entry given a partial entity
    • deleteById - Delete from the table row with the given id
    • updateById - Update row with the given id

Note: I'm using a UUID id as PK for the table I'm showing in this showcase, but you can change it to whatever you want.

This repository also shows many other things but mostly related to NestJS.

i have follow you but when drizzle generate sql, for relationship it fix with schema name "public"
after run migrate each schema, it is error because of this.

[iursevla]

@Kokleng-Dev could you kindly create an issue here: https://github.com/intruder-detection/nestjs-drizzle-multiple-schemas/issues

Please add as much information as possible so that I can track it down