Level 102
2 solutions.
- Use mysql for testing
- Never use database alter in migrations. But be aware that you might run into others small differences
https://www.aaronsaray.com/2019/stop-using-sqlite-in-laravel-unit-tests
1 like
Mar 13, 2022
3
Level 1
Laravel testing SQLite Alter Column Issue
I am using sqlite for our feature test with in-memory database. I found that SQLite had a problem with modifying column with alter table query. please tell us any solution to solve it or any replacement way like using MySQL for testing database and how to deal with that. thank you. Our laravel version is 8. and we use MySQL for main database
Level 1
@Sinnbeck thanks bro, You right I will use MySQL, but how about performance and make it faster
Level 104
You could consider squashing your migrations
1 like
Please or to participate in this conversation.