Every two weeks I send out a newsletter containing lots of interesting stuff for the modern PHP developer. You can expect quick tips, links to interesting tutorials, opinions and packages. Want to learn the cool stuff? Then sign up now!

A Laravel package to quickly dump and load the database

Last week our team released a new package called laravel-db-snapshots. It provides a few artisan commands to quickly dump and load a database. We’ve built this for is to help us develop features in an app that require the database to be in a specific state. With this package we can take a dump of the db, try out the feature that modifies the db. When there are bugs, we can fix them, load up the dump and try again.

Here’s how the package can be used:

# Create a dump
php artisan snapshot:create my-first-dump

# Make some changes to your db
# ...

# Create another dump
php artisan snapshot:create my-second-dump

# Load up the first dump
php artisan snapshot:load my-first-dump

# List all snapshots
php artisan snapshot:list

Currently the package has support for MySQL, PostgreSQL and Sqlite databases. To learn more about it head over to the readme on GitHub. If you like it, be sure to take a look at the other Laravel packages our team has previously built.

Freek Van der Herten is a partner and developer at Spatie, an Antwerp based company that specializes in creating web apps with Laravel. After hours he writes about modern PHP and Laravel on this blog. When not coding he’s probably rehearsing with his kraut rock band. He loves waffles and butterflies.