paske
DTDrizzle Team
•Created by paske on 5/13/2025 in #help
weird __drizzle_migrations row id (move from `drizzle-kit push` to `drizzle-kit migrate`)
tl;dr: how is the starting id defined when running
drizzle-kit migrate? i though it was the migration filename id but it doesn't seem to be.
i had to forego the described challenge in the title. seemed trivial, but i found a few pitfalls in the dx.
i tried to manually create the rows in the drizzle table but the it's unclear how the index is defined. i had 10 migrations: locally, the id started in 25. in my remote db, it started in 4.
i worked my way around it by setting SELECT 1; temporarily in my migration files so the drizzle-kit migrate command would fill the __drizzle_migrations table; although the hash doesn't match the contents it doesn't matter because the command uses the index.5 replies