How does drizzle-kit push:sqlite order its SQL statements?

[michaeldebetaz]

EDIT : Since I asked this question, I had the opportunity to work a lot with drizzle ☀ I think the problems I encountered came from a misconception I had about the references properties. I made them go both ways (each one had a foreign key constrain that pointed to the other), which should never be the case. Maybe drizzle-kit check could validate the schema against looping references.

I hope this would help other people wondering the same things!

---

I'm currently developping an app using better-sqlite and drizzle. I am happy to abuse drizzle-kit push:sqlite for quick development. However, I encountered some obstacles as my database schema became more complex.

As I understand it, push sequentially:

• renames the old table "table" → "__old_push_table"
• creates a new table "table" with the new changes in the schema file
• copies the old table data into the new table
• drop the "old_push_table".

My database has tables with foreign keys and some of them have the on delete restrict constrain. In some cases, I noticed that the SQL executed during a push altered the foreign table before the tables with the constrained foreign key, which errored the whole operation.

I changed the fields to on delete cascade for the time being, but I would like to know how the drizzle-kit push decides the order in which the tables are altered. I tried to change the order of the tables in my schemas but with no success.

I'm loving dirzzle so far! Thank you so much for making such a cool ORM 🔥

[nevthereal]

what do you mean by both ways?

[nevthereal]

ah so you mean in the users table you also point back to the e. g. posts table?

[michaeldebetaz]

That's right. My own skill issue with SQL in summary ;)

[nevthereal]

ok because i am getting a similar issue here. but i don't know what i did wrong. https://discord.com/channels/1043890932593987624/1245751584487374900
here is the discord discussion link if you are on discord

[michaeldebetaz]

I checked it out and I don't see anythniewrong in your schema 🤷🏽‍♂️ Maybe it comes from turso.

[nevthereal]

I see... thank you!