Skip to content
项目

fastmonkeys/stellar has 3,847 GitHub stars and 123 forks. GitHot measured 0 stars in 24 hours, -2 in 7 days, and -3 in 15 days. Last checked 2026-11-21 14:49 UTC. Last push 2024-12-13.

这些数字如何统计

实测星标增长

24小时
0
7天
-2
15天
-3
1个月
正在收集历史

各周期内的星标净变化,周期相互重叠,并非每日新增。缺失的测量保持空白。星标代表关注度,不代表软件质量。

关于

用于开发的快速数据库快照与恢复工具

数据

README.md

原文

Stellar - Fast database snapshot and restore tool for development.

Build Status   

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

Screenshot of Stellar terminal window

Benchmarks

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

Benchmarking database restore speed

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 make too many snapshots or you will eventually run out of storage space.

Warning: Please don't use Stellar if you can't afford data loss. It's great for developing but not meant for 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

Common issues

sqlalchemy.exc.OperationalError: (OperationalError) (1044, u"Access denied for user 'my_db_username'@'localhost' to database 'stellar_data'") "CREATE DATABASE stellar_data CHARACTER SET = 'utf8'" ()

Make sure you have the rights to create new databases. See Issue 10 for discussion

If you are using PostgreSQL, make sure you have a database that is named the same as the unix username. You can test this by running just psql. (See issue #44 for details)

探索相关项目

加载中…