Drizzle Team•3mo ago

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 :>

1 Reply

Abu Somebody•3mo ago

I was TOTALLY wrong on the database limit part in neon, I can create how many I wish to create! AMAZING! how do I mark solved?

Gaming

Programming

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