zhest
zhest
PostsComments
DTDrizzle Team
Created by zhest on 11/8/2023 in #help
Migration Failed LibsqlError
thanks! I ended up getting push to work, and have been using that to develop... I should probably try migrating more often
14 replies
DTDrizzle Team
Created by zhest on 11/8/2023 in #help
Migration Failed LibsqlError
migrate throws a table already exists error push throws a FOREIGN KEY constraint failed
14 replies
DTDrizzle Team
Created by zhest on 11/8/2023 in #help
Migration Failed LibsqlError
ok so I did get push to work, but still have some issue, but at least I was able to get tables loaded into turso
14 replies
DTDrizzle Team
Created by zhest on 11/8/2023 in #help
Migration Failed LibsqlError
thanks, I do want to keep looking for the issue though, as I want to fix things so it is "automatic/out of the box"
14 replies
DTDrizzle Team
Created by zhest on 11/8/2023 in #help
Migration Failed LibsqlError
hey @Angelelz thanks for responding. I see you doing a lot of community support all by yourself, so you're a rockstar by my book. I did some more work looking through my files, cleaning up my schema/etc. breakpoints look fine to me, I do have this note from the migration file, but am having trouble tracking down where I am changing column types.
/*
 SQLite does not support "Changing existing column type" out of the box, we do not generate automatic migration for that, so it has to be done manually
 Please refer to: https://www.techonthenet.com/sqlite/tables/alter_table.php
                  https://www.sqlite.org/lang_altertable.html
                  https://stackoverflow.com/questions/2083543/modify-a-columns-type-in-sqlite3

 Due to that we don't generate migration automatically and it has to be done manually
*/
/*
 SQLite does not support "Changing existing column type" out of the box, we do not generate automatic migration for that, so it has to be done manually
 Please refer to: https://www.techonthenet.com/sqlite/tables/alter_table.php
                  https://www.sqlite.org/lang_altertable.html
                  https://stackoverflow.com/questions/2083543/modify-a-columns-type-in-sqlite3

 Due to that we don't generate migration automatically and it has to be done manually
*/
The other problem with better-sqlite is that it conflicts with my auth adapter via lucia. 
 WARN  Issues with peer dependencies found
.
└─┬ @lucia-auth/adapter-sqlite 2.0.0
  └── ✕ unmet peer better-sqlite3@^8.0.0: found 9.0.0
 WARN  Issues with peer dependencies found
.
└─┬ @lucia-auth/adapter-sqlite 2.0.0
  └── ✕ unmet peer better-sqlite3@^8.0.0: found 9.0.0
14 replies