Using multiple databases

You can easily use multiple databases with monolayer-pg.

To define multiple databases, you export more than one database definition from the databases file.

databases.ts

import { defineDatabase } from "@monolayer/pg/schema";

export default defineDatabase({
  // Database configuration options
});

export const stats = defineDatabase({
  id: "stats",
  // Other database configuration options
});

WARNING

When you define multiple databases, make sure each database definition has a unique identifier. Otherwise, you will have multiple databases with the same default identifier.

You can also re-export databases from other files.

databases.ts

import { defineDatabase } from "@monolayer/pg/schema";
export { statsDb } from "./stats";

export default defineDatabase({
  // Database configuration options
});

stats.ts

import { defineDatabase } from "@monolayer/pg/schema";
import { statsSchema } from "./stats-schema";

export const stats = defineDatabase({
  id: "stats",
  schemas: [statsSchema],
  // Other database configuration options
});