2 replies

Drizzle: recreate tables with different prefix, without deleting the old ones

TLDR; Recreate tables for instances of same appllication (on the same database)
I have an application which I'll deploy a unique instance of for each client, I'm using neon for storing data
Neon's free plan allows 1 database and unlimited table
what I'm doing right now is:

import { pgTableCreator } from "drizzle-orm/pg-core";
import { env } from "~/env";
export const createTable = pgTableCreator((name) =>
  `${env.PROJECT_NAME}_${name}`
);

import { pgTableCreator } from "drizzle-orm/pg-core";
import { env } from "~/env";
export const createTable = pgTableCreator((name) =>
  `${env.PROJECT_NAME}_${name}`
);

This should theoritically allow me to create different tables for different clients, and store them in the same database.
HOWEVER, when I try to push drizzle updates, I'm faced with this (in the picture, alt: it's trying to delete old tables for some reason)

Any idea on how to get around this? would be REALLY thankful to whoever helps

I'm literally starting with 0$ and wanna make my first buck online, this is a little SaaS chat-app I'm building :>

Drizzle Team•2y ago•

2 replies

Abu Somebody

Drizzle: recreate tables with different prefix, without deleting the old ones

import { pgTableCreator } from "drizzle-orm/pg-core";
import { env } from "~/env";
export const createTable = pgTableCreator((name) =>
  `${env.PROJECT_NAME}_${name}`
);

import { pgTableCreator } from "drizzle-orm/pg-core";
import { env } from "~/env";
export const createTable = pgTableCreator((name) =>
  `${env.PROJECT_NAME}_${name}`
);

Drizzle: recreate tables with different prefix, without deleting the old ones

Similar Threads

Drizzle: recreate tables with different prefix, without deleting the old ones

Similar Threads

Similar Threads

Similar Threads