Custom migration files? Triggers in SQLite
I want to do some triggers for sanity checks in my SQLite database and I know how to write the schema. Is there an escape hatch somewhere, that allows me to write my own up/down migrations?
Am I maybe overthinking this, and should just add a .sql file into the migration folder?
1 Reply
https://discord.com/channels/1043890932593987624/1152444126894227556/1152654962795483187
I'd still love a way for this to be done from a .ts file. During development, I'm deleting the DB and the schema folder every once in a while. Also, the SQLite adapter isn't great at alter table.