Laravel Packages

PlanetScale Database Migrations for Laravel

Published
PlanetScale Database Migrations for Laravel image

This community PlanetScale package for Laravel adds an artisan pscale:migrate command to your Laravel applications. This command helps you manage database migrations using the PlanetScale API, a process which varies slightly from using the built-in migrate command.

During a deployment, you'd run the following command instead of migrate which does everything necessary to update your database's schema:

php artisan pscale:migrate

Why is this needed?

You might wonder why this command is needed instead of directly using the migrate command.

According to the package's readme, PlantScale handles migrations in a different way that you'd typically see with databases:

PlanetScale has alot of advantages when using it as your application's production database. However it handles your database and schema migrations in a somewhat unusual way.

It uses branches for your database. A branch can be production or development...

This package uses PlanetScale's Public API to automate the process of creating a new development branch, connecting your app to the development branch, running your Laravel migrations on the development branch, merging that back into your production branch, and deleting the development branch.

To get started with this package, check out the package setup instructions on GitHub at x7media/laravel-planetscale.

Related: Speaking of PlanetScale and databases, Aaron Francis published MySQL for Developers. We'd highly recommend you check that out to improve your database skills.

Paul Redmond photo

Staff writer at Laravel News. Full stack web developer and author.

Sponsored

masteringlaravel logo
Laravel Code Review

Get expert guidance in a few days with a Laravel code review

Visit Laravel Code Review

The latest

View all →
Agent Run Observability in Laravel AI SDK 0.11 image

Agent Run Observability in Laravel AI SDK 0.11

Read article
Debounced Queued Event Listeners in Laravel image

Debounced Queued Event Listeners in Laravel

Read article
Statamic Mailables Viewer Previews Laravel Emails in the Control Panel image

Statamic Mailables Viewer Previews Laravel Emails in the Control Panel

Read article
Laravel Tackle: Run an AI Coding Agent in Your Laravel App image

Laravel Tackle: Run an AI Coding Agent in Your Laravel App

Read article
Queue::forward(): Reroute Laravel Queues in One Place image

Queue::forward(): Reroute Laravel Queues in One Place

Read article
Laravel Read-Through Filesystem: Lazy Storage Migration image

Laravel Read-Through Filesystem: Lazy Storage Migration

Read article