George Comments - Answer Overflow

George

Explore posts from servers

•Created by alka_99 on 1/27/2024 in #help

How to not loss data everytime i change the schema

I am trying to learn how to also do this for when I eventually go to prod. Right now I lose data everytime I change my schema and just seed the data base afterwards. However when I deal with real customer data this would mean data loss so what are the recommended way to apply db migrations without data loss? Are there any resources u could point me to, to learn more about migrations without data loss?

4 replies

DTDrizzle Team

•Created by George on 12/10/2023 in #help

db.batch is missing

Ohhh ok fair enough. Will this feature eventually be available for postgres. Also are there any differences / downsides for using Promise.all over db.batch. Sorry if this is a noobish question.

9 replies

DTDrizzle Team

•Created by George on 12/10/2023 in #help

db.batch is missing

9 replies

DTDrizzle Team

•Created by George on 12/10/2023 in #help

db.batch is missing

9 replies

DTDrizzle Team

•Created by George on 12/3/2023 in #help

How to create unique constraint on a column for a foreign key?

3 replies

DTDrizzle Team

•Created by Zephury on 11/20/2023 in #help

I swear this infer was working... am I crazy?

try restarting ur ts server

14 replies

DTDrizzle Team

•Created by George on 11/19/2023 in #help

Generate drizzle migrations and push with drizzle kit with github actions for preview environments

6 replies

DTDrizzle Team

•Created by George on 11/19/2023 in #help

Generate drizzle migrations and push with drizzle kit with github actions for preview environments

This is my current DATABSE_URL command

 echo DATABASE_URL=$(neonctl cs --pooled ${{ steps.branch-name.outputs.current_branch }} --project-id ${{ secrets.NEON_PROJECT_ID }} --role-name ${{ secrets.POSTGRES_USERNAME }} --database-name ${{ secrets.POSTGRES_DATABASE_NAME }} --api-key ${{ secrets.NEON_API_KEY }}) >> .env

 echo DATABASE_URL=$(neonctl cs --pooled ${{ steps.branch-name.outputs.current_branch }} --project-id ${{ secrets.NEON_PROJECT_ID }} --role-name ${{ secrets.POSTGRES_USERNAME }} --database-name ${{ secrets.POSTGRES_DATABASE_NAME }} --api-key ${{ secrets.NEON_API_KEY }}) >> .env

6 replies

DTDrizzle Team

•Created by George on 11/19/2023 in #help

Generate drizzle migrations and push with drizzle kit with github actions for preview environments

Does anyone know how to add sslmode=require to a database url via the neonctl?

6 replies

DTDrizzle Team

•Created by George on 11/19/2023 in #help

Generate drizzle migrations and push with drizzle kit with github actions for preview environments

6 replies

DTDrizzle Team

•Created by George on 11/19/2023 in #help

Generate drizzle migrations and push with drizzle kit with github actions for preview environments

6 replies

Gaming

Programming