paul-a-byford
3 months ago

testing json and enum column types with sqlite

Posted 3 months ago by paul-a-byford

Hey Everyone, I attempted to switch to sqlite (in memory) to speed up running phpunit testing with the RefreshDatabase trait. Currently I'm using mysql and found that RefreshDatabase adds about 2 seconds to the run time to process the migrations.

I discovered sqlite doesn't seem to support column types enum or json.

Can you recommend a way around this with sqlite, or any alternate approaches to speed up testing execution on mysql?

Thanks

Please sign in or create an account to participate in this conversation.