How to use different tables for production and development environments?

[alexiuscrow]

I am using Drizzle ORM with Next.js + Vercel.
Currently, I am on Vercel's free plan and I only have access to a single Postgres database. However, I need to separate my development and production environments.

How I can use different tables for development and production within the same database using Drizzle ORM?

I have tried using pgTableCreator to create tables with an environment prefix.

import { pgTableCreator } from 'drizzle-orm/pg-core';

const isProduction = process.env.VERCEL_ENV === 'production';
const env = isProduction ? 'prod' : 'dev';
export const pgTable = pgTableCreator(name => `${env}_${name}`);

But when I want to create tables for production with the same schema that I am already using for development, Drizzle ORM first asks if I want to create new ones or rename existing tables.

$ VERCEL_ENV=production drizzle-kit push:pg

drizzle-kit: v0.20.14
drizzle-orm: v0.30.10

No config path provided, using default path
Reading config file '/Users/alexiuscrow/my-project/drizzle.config.ts'

Is prod_user table created or renamed from another table?
❯ + prod_user                                       create table
  ~ dev_user › prod_user                            rename table

And when I choose "create table", Drizzle ORM wants to delete the development env tables.

 Warning  Found data-loss statements:
· You're about to delete dev_user table with 3 items
# ...and 6 other tables listed

THIS ACTION WILL CAUSE DATA LOSS AND CANNOT BE REVERTED

Do you still want to push changes?
❯ No, abort
  Yes, I want to remove 7 tables, 

...or maybe there is a way to avoid deleting the dev tables at the last step and create tables with new names (with the prod prefix in my case)?

Please advice.

[chenyuncai]

maybe you should take a different database for prod mode