Stellar allows you to quickly restore database when you are e.g. writing database migrations, switching branches or messing with SQL. PostgreSQL and MySQL are supported.

Stellar is fast. It can restore database ~140 times faster than using the usual pg_dump & pg_restore.

Stellar works by storing copies of the database in the RDBMS (named as stellar_xxx_master and stellar_xxxx_slave). When restoring the database, Stellar simply renames the database making it lot faster than the usual SQL dump. However, Stellar uses lots of storage space so you probably don't want to mae too many snapshots or you will eventually run out of storage space.

Due to nature of the this tool, it is not recommended to use this in enviroment where you can't afford data loss (eg. production)

You can install Stellar with pip.

$ pip install stellar

After that, you should go to your project folder and initialize Stellar settings. Stellar initialization wizard will help you with that.

$ stellar init

Stellar settings are saved as 'stellar.yaml' so you probably want to add that to your .gitignore.

$ echo stellar.yaml >> .gitignore

Done! 👯

$ stellar snapshot SNAPSHOT_NAME

$ stellar restore SNAPSHOT_NAME