stellar is a tool for creating and restoring database snapshots
Project description
Stellar - Fast database snapshot and restore tool for development.
=======
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.
![Screenshot of Stellar terminal window](http://imgur.com/0fXXdcx.png)
Benchmarks
-------
Stellar is fast. It can restore a database ~140 times faster than using the usual
pg_dump & pg_restore.
![Benchmarking database restore speed](http://imgur.com/Md1AHXa.png)
How it works
-------
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 experimental nature of this tool, it is not recommended to use this in an enviroment where you can't afford possible data loss (eg. production)
How to get started
-------
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! :dancers:
How to take a snapshot
-------
```$ stellar snapshot SNAPSHOT_NAME```
How to restore from a snapshot
-------
```$ stellar restore SNAPSHOT_NAME```
=======
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.
![Screenshot of Stellar terminal window](http://imgur.com/0fXXdcx.png)
Benchmarks
-------
Stellar is fast. It can restore a database ~140 times faster than using the usual
pg_dump & pg_restore.
![Benchmarking database restore speed](http://imgur.com/Md1AHXa.png)
How it works
-------
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 experimental nature of this tool, it is not recommended to use this in an enviroment where you can't afford possible data loss (eg. production)
How to get started
-------
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! :dancers:
How to take a snapshot
-------
```$ stellar snapshot SNAPSHOT_NAME```
How to restore from a snapshot
-------
```$ stellar restore SNAPSHOT_NAME```
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
stellar-0.3.2.tar.gz
(8.6 kB
view details)
File details
Details for the file stellar-0.3.2.tar.gz
.
File metadata
- Download URL: stellar-0.3.2.tar.gz
- Upload date:
- Size: 8.6 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | fbec4bccb7cb0fafa4661474d0ea96edb6b0978bd66cc8ec75739f18ed0ee57d |
|
MD5 | d42537f83a04bbe39a8d873cd98bdc2d |
|
BLAKE2b-256 | 9803130218ae5ff7a60513a9901af3f7db4a4746b459b911ec0eac8d82545e70 |