Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.
Hello guys. I have an old project that has some migrations issues related to the sqlite. And Sqlite doesnot support dropping foreign key, renaming column names etc. So I created a test mysql database for testing and iam currently testing like that. But the testing process has become very slow because of using mysql database. Anyone has a better experience on replacing sqlite database which is fast and supports new migrations feature?
Don't be so precious about your migrations, especially older migrations - the only relevant schema is the current one (or just the recent changes). Take a snapshot of your current schema using the schema:dump artisan command, or using a Migrations Generator package and work from there. You should see an improvement in the performance of a Mysql test database, and probably should be able to revert to Sqlite if you wish.
Please or to participate in this conversation.