{ "info": { "author": "Rob Hartzenberg", "author_email": "rob@hartzenberg.net", "bugtrack_url": null, "classifiers": [ "Intended Audience :: Developers", "License :: OSI Approved :: BSD License", "Operating System :: MacOS :: MacOS X", "Operating System :: Microsoft :: Windows", "Operating System :: POSIX", "Programming Language :: Python :: 2", "Programming Language :: Python :: 3", "Topic :: Database", "Topic :: Software Development :: Version Control", "Topic :: Utilities" ], "description": "Stellar - Fast database snapshot and restore tool for development.\n=======\n\n[![Build Status](https://travis-ci.org/fastmonkeys/stellar.svg?branch=master)](https://travis-ci.org/fastmonkeys/stellar) \n![](http://img.shields.io/pypi/dm/stellar.svg) \n![](http://img.shields.io/pypi/v/stellar.svg)\n\n\nStellar 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.\n\n![Screenshot of Stellar terminal window](http://imgur.com/0fXXdcx.png)\n\n\nBenchmarks\n-------\nStellar is fast. It can restore a database ~140 times faster than using the usual\npg_dump & pg_restore.\n\n![Benchmarking database restore speed](http://imgur.com/Md1AHXa.png)\n\nHow it works\n-------\n\nStellar 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.\n\n**Warning: Please don't use Stellar if you can't afford data loss.** It's great for developing but not meant for production.\n\nHow to get started\n-------\n\nYou can install Stellar with `pip`.\n\n```$ pip install stellar```\n\nAfter that, you should go to your project folder and initialize Stellar settings. Stellar initialization wizard will help you with that.\n\n```$ stellar init```\n\nStellar settings are saved as 'stellar.yaml' so you probably want to add that to your `.gitignore`.\n\n```$ echo stellar.yaml >> .gitignore```\n\nDone! :dancers:\n\n\nHow to take a snapshot\n-------\n\n```$ stellar snapshot SNAPSHOT_NAME```\n\nHow to restore from a snapshot\n-------\n\n```$ stellar restore SNAPSHOT_NAME```\n\nCommon issues\n-------\n\n````\nsqlalchemy.exc.OperationalError: (OperationalError) (1044, u\"Access denied for user 'my_db_username'@'localhost' to database 'stellar_data'\") \"CREATE DATABASE stellar_data CHARACTER SET = 'utf8'\" ()\n`````\n\nMake sure you have the rights to create new databases. See [Issue 10](https://github.com/fastmonkeys/stellar/issues/10) for discussion\n\nIf you are using PostreSQL, 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](https://github.com/fastmonkeys/stellar/issues/44) for details)\n", "description_content_type": null, "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/craftypenguins/stellar-p2p", "keywords": "", "license": "BSD", "maintainer": "", "maintainer_email": "", "name": "stellar-p2p", "package_url": "https://pypi.org/project/stellar-p2p/", "platform": "any", "project_url": "https://pypi.org/project/stellar-p2p/", "project_urls": { "Homepage": "https://github.com/craftypenguins/stellar-p2p" }, "release_url": "https://pypi.org/project/stellar-p2p/0.4.5.1/", "requires_dist": null, "requires_python": "", "summary": "stellar-p2p is a modified version of stellar, a tool for creating and restoring database snapshots", "version": "0.4.5.1" }, "last_serial": 3408489, "releases": { "0.4.4": [ { "comment_text": "", "digests": { "md5": "347a45a26930b33d5b039ff5e23ab3cd", "sha256": "55e0865edb0e292d12bd75d853eacb52c8a1025e2385ca74e633d10d2dd7b342" }, "downloads": -1, "filename": "stellar-p2p-0.4.4.tar.gz", "has_sig": false, "md5_digest": "347a45a26930b33d5b039ff5e23ab3cd", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 12857, "upload_time": "2017-12-04T23:54:06", "url": "https://files.pythonhosted.org/packages/47/9d/d551922a10690ffb2eba54bfad37207f320a69b42a6dde619d3f61b30632/stellar-p2p-0.4.4.tar.gz" } ], "0.4.4a0": [ { "comment_text": "", "digests": { "md5": "8ef77738ac93ff062e6756829f8031e5", "sha256": "c5572f3505b441755d87ee14c94e646d4864233d451c5abd36bea4910a6f91ca" }, "downloads": -1, "filename": "stellar-p2p-0.4.4a0.tar.gz", "has_sig": false, "md5_digest": "8ef77738ac93ff062e6756829f8031e5", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 12871, "upload_time": "2017-12-08T19:20:18", "url": "https://files.pythonhosted.org/packages/75/db/cb579f72cbef0812e57c07c93522066289e8fb7d660396818e7f76c3d9f4/stellar-p2p-0.4.4a0.tar.gz" } ], "0.4.4b0": [ { "comment_text": "", "digests": { "md5": "0391e4e6c40f6be727da2eb799077893", "sha256": "c9a26b51318bdc32c658e3ba64cc5b3048007222e6ff93975222f739a6a623f1" }, "downloads": -1, "filename": "stellar-p2p-0.4.4b0.tar.gz", "has_sig": false, "md5_digest": "0391e4e6c40f6be727da2eb799077893", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 12881, "upload_time": "2017-12-08T19:37:18", "url": "https://files.pythonhosted.org/packages/f3/4b/7ff77bb1c6cf3ee7edaf7b7b57f7c1b5a408ee2a8a81b153e243ab135c61/stellar-p2p-0.4.4b0.tar.gz" } ], "0.4.4rc0": [ { "comment_text": "", "digests": { "md5": "e56203a154d1745aaa01d7aa0505ca97", "sha256": "e57da05bd90fdbad5147c46a2b7ec4f756d9b2225bd1b5fe6ce0143d4aad6b7c" }, "downloads": -1, "filename": "stellar-p2p-0.4.4rc0.tar.gz", "has_sig": false, "md5_digest": "e56203a154d1745aaa01d7aa0505ca97", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 12882, "upload_time": "2017-12-11T20:41:44", "url": "https://files.pythonhosted.org/packages/20/60/982a0901cf3f10d4e61d24f33f8f59db106bfce4522d593b9b2491df9b2a/stellar-p2p-0.4.4rc0.tar.gz" } ], "0.4.5": [ { "comment_text": "", "digests": { "md5": "d4264bd60752f6b483e2a78e7ccdaa50", "sha256": "3ead3b0650a9041afd3f62e850a8c896d14e4a602efb97fe82bc3e2c4e3fd142" }, "downloads": -1, "filename": "stellar-p2p-0.4.5.tar.gz", "has_sig": false, "md5_digest": "d4264bd60752f6b483e2a78e7ccdaa50", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 12871, "upload_time": "2017-12-11T20:42:27", "url": "https://files.pythonhosted.org/packages/a1/80/d8d359e818cd88d492c8b7a956960b9562b5a2571318ec40165ac62a804e/stellar-p2p-0.4.5.tar.gz" } ], "0.4.5.1": [ { "comment_text": "", "digests": { "md5": "0eec49125f4514d38597acb62531a01f", "sha256": "8838c4c056d8992169e65bc20923a900fce1271c97ba6d460a915aa82f3f00fb" }, "downloads": -1, "filename": "stellar-p2p-0.4.5.1.tar.gz", "has_sig": false, "md5_digest": "0eec49125f4514d38597acb62531a01f", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 12891, "upload_time": "2017-12-11T20:51:46", "url": "https://files.pythonhosted.org/packages/2b/e9/ed7858a72d7baeec2ed6e4997784b1ad7f03406334a1f8df6effe97b4ef2/stellar-p2p-0.4.5.1.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "0eec49125f4514d38597acb62531a01f", "sha256": "8838c4c056d8992169e65bc20923a900fce1271c97ba6d460a915aa82f3f00fb" }, "downloads": -1, "filename": "stellar-p2p-0.4.5.1.tar.gz", "has_sig": false, "md5_digest": "0eec49125f4514d38597acb62531a01f", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 12891, "upload_time": "2017-12-11T20:51:46", "url": "https://files.pythonhosted.org/packages/2b/e9/ed7858a72d7baeec2ed6e4997784b1ad7f03406334a1f8df6effe97b4ef2/stellar-p2p-0.4.5.1.tar.gz" } ] }