databudgie

Name	databudgie JSON
Version	2.8.4 JSON
	download
home_page	https://github.com/schireson/databudgie
Summary	Ergonomic and flexible tool for database backup and restore
upload_time	2023-07-06 13:49:07
maintainer
docs_url	None
author	Andrew Sosa
requires_python	>=3.7,<4
license	MIT
keywords	sqlalchemy postgres database etl s3
VCS
bugtrack_url
requirements	No requirements were recorded.
Travis-CI	No Travis.
coveralls test coverage	No coveralls.

            # Databudgie

![Github Actions Build](https://github.com/schireson/databudgie/actions/workflows/build.yml/badge.svg)
[![Coverage Status](https://coveralls.io/repos/github/schireson/databudgie/badge.svg?branch=main&t=6I0aU6)](https://coveralls.io/github/schireson/databudgie?branch=main)
[![Documentation
Status](https://readthedocs.org/projects/databudgie/badge/?version=latest)](https://databudgie.readthedocs.io)

![](docs/source/_static/databudgie.png)

Databudgie is a CLI & library for database performing targeted backup and
restore of database tables or arbitrary queries against database tables.

# Usage

A minimal config file might look like:

```yaml
# databudgie.yml or config.databudgie.yml
backup:
  url: postgresql://postgres:postgres@localhost:5432/postgres
  tables:
    - name: public.product
      query: "select * from {table} where store_id > 4"
      location: s3://my-s3-bucket/databudgie/public.product
restore:
  url: postgresql://postgres:postgres@localhost:5432/postgres
  tables:
    - name: public.product
      location: s3://my-s3-bucket/databudgie/public.product
```

With that config in place, backing up the defined tables (using the specified
config) is as simple as `databudgie backup`; and restore `databudgie restore`.

## Installation

```bash
pip install databudgie
```

            

Raw data

            {
    "_id": null,
    "home_page": "https://github.com/schireson/databudgie",
    "name": "databudgie",
    "maintainer": "",
    "docs_url": null,
    "requires_python": ">=3.7,<4",
    "maintainer_email": "",
    "keywords": "sqlalchemy,postgres,database,etl,s3",
    "author": "Andrew Sosa",
    "author_email": "andrewso@known.is",
    "download_url": "https://files.pythonhosted.org/packages/0f/2a/f9a0a22b17bbca7eac714a7a33b6dba21abee260b97da7cf00ad00318e92/databudgie-2.8.4.tar.gz",
    "platform": null,
    "description": "# Databudgie\n\n![Github Actions Build](https://github.com/schireson/databudgie/actions/workflows/build.yml/badge.svg)\n[![Coverage Status](https://coveralls.io/repos/github/schireson/databudgie/badge.svg?branch=main&t=6I0aU6)](https://coveralls.io/github/schireson/databudgie?branch=main)\n[![Documentation\nStatus](https://readthedocs.org/projects/databudgie/badge/?version=latest)](https://databudgie.readthedocs.io)\n\n![](docs/source/_static/databudgie.png)\n\nDatabudgie is a CLI & library for database performing targeted backup and\nrestore of database tables or arbitrary queries against database tables.\n\n# Usage\n\nA minimal config file might look like:\n\n```yaml\n# databudgie.yml or config.databudgie.yml\nbackup:\n  url: postgresql://postgres:postgres@localhost:5432/postgres\n  tables:\n    - name: public.product\n      query: \"select * from {table} where store_id > 4\"\n      location: s3://my-s3-bucket/databudgie/public.product\nrestore:\n  url: postgresql://postgres:postgres@localhost:5432/postgres\n  tables:\n    - name: public.product\n      location: s3://my-s3-bucket/databudgie/public.product\n```\n\nWith that config in place, backing up the defined tables (using the specified\nconfig) is as simple as `databudgie backup`; and restore `databudgie restore`.\n\n## Installation\n\n```bash\npip install databudgie\n```\n",
    "bugtrack_url": null,
    "license": "MIT",
    "summary": "Ergonomic and flexible tool for database backup and restore",
    "version": "2.8.4",
    "project_urls": {
        "Homepage": "https://github.com/schireson/databudgie",
        "Repository": "https://github.com/schireson/databudgie"
    },
    "split_keywords": [
        "sqlalchemy",
        "postgres",
        "database",
        "etl",
        "s3"
    ],
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "036d73fe1b0d246fc52320a447d0328c2b57f24b430b3db710db85bb6f31fa27",
                "md5": "2f844de7be8a61132a7566ca1ba0f97d",
                "sha256": "6aecb3c0d6e780c8df8b33f5ad1e80a8076839ad5168b763eaf438cd97c763bb"
            },
            "downloads": -1,
            "filename": "databudgie-2.8.4-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "2f844de7be8a61132a7566ca1ba0f97d",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": ">=3.7,<4",
            "size": 37609,
            "upload_time": "2023-07-06T13:49:06",
            "upload_time_iso_8601": "2023-07-06T13:49:06.199685Z",
            "url": "https://files.pythonhosted.org/packages/03/6d/73fe1b0d246fc52320a447d0328c2b57f24b430b3db710db85bb6f31fa27/databudgie-2.8.4-py3-none-any.whl",
            "yanked": false,
            "yanked_reason": null
        },
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "0f2af9a0a22b17bbca7eac714a7a33b6dba21abee260b97da7cf00ad00318e92",
                "md5": "7d18a9a2d9f1a3271a13d451d379363b",
                "sha256": "63b5b0717579d578b399c90d9ca416d496d418990ba30364f6cccc0f6c281491"
            },
            "downloads": -1,
            "filename": "databudgie-2.8.4.tar.gz",
            "has_sig": false,
            "md5_digest": "7d18a9a2d9f1a3271a13d451d379363b",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": ">=3.7,<4",
            "size": 30603,
            "upload_time": "2023-07-06T13:49:07",
            "upload_time_iso_8601": "2023-07-06T13:49:07.518590Z",
            "url": "https://files.pythonhosted.org/packages/0f/2a/f9a0a22b17bbca7eac714a7a33b6dba21abee260b97da7cf00ad00318e92/databudgie-2.8.4.tar.gz",
            "yanked": false,
            "yanked_reason": null
        }
    ],
    "upload_time": "2023-07-06 13:49:07",
    "github": true,
    "gitlab": false,
    "bitbucket": false,
    "codeberg": false,
    "github_user": "schireson",
    "github_project": "databudgie",
    "travis_ci": false,
    "coveralls": false,
    "github_actions": true,
    "lcname": "databudgie"
}