Cloudflare DevelopersCD
Cloudflare Developers•2y ago
Web Bae

D1 Best Practices dev/prod modes and --local and --remote flags

Hi!

What are best practices around databases with D1 for building web apps that have dev and prod modes?

I tried creating a wrangler.toml like this:

#:schema node_modules/wrangler/config-schema.json
name = "server"
main = "src/index.ts"
compatibility_date = "2024-06-14"

[env.dev]
d1_databases = [
    { binding = "DB", database_name = "d1", database_id = "8574d62f-02ae-4843-a25a-3700a2b5ebc1" }
]

[env.prod]
d1_databases = [
    { binding = "DB", database_name = "d1", database_id = "8574d62f-02ae-4843-a25a-3700a2b5ebc1" }
]


notice the ids are the same.

when I create migrations, I have to use --env=dev and --env=prod flags. But not I have duplicated migrations in the same folder.

What's the right way to do this? Should I have two databases in each env? A dev and a prod?

Or should I control using the --local and --remote flags somehow?
Was this page helpful?