How to use libsql features in migrations
Hey there, first time using sqlite here, AFAIK, you can't modify a sqlite column to, for instance, change its ON DELETE action from nothing to cascade. However, libsql mentions this in its docs https://github.com/tursodatabase/libsql/blob/main/libsql-sqlite3/doc/libsql_extensions.md#altering-columns which makes me think there is actually a way to do this without using a mirror table.
I understand that running 'drizzle-kit generate' with schema changes like this one will output a warning saying you should write the migration yourself. What I don't understand is where should I do this. Should I edit my 0001_etc.sql file and write my code there?
If i do that, and write something like
then I get an error because libsql> is not recognized, but then what is the point of writing
I understand that running 'drizzle-kit generate' with schema changes like this one will output a warning saying you should write the migration yourself. What I don't understand is where should I do this. Should I edit my 0001_etc.sql file and write my code there?
If i do that, and write something like
libsql> ALTER TABLE emails ALTER COLUMN user_id TO user_id INTthen I get an error because libsql> is not recognized, but then what is the point of writing
driver: "turso"GitHub
libSQL is a fork of SQLite that is both Open Source, and Open Contributions. - tursodatabase/libsql
