databudgie

Name	databudgie JSON
Version	2.8.6 JSON
	download
home_page	https://github.com/schireson/databudgie
Summary	Ergonomic and flexible tool for database backup and restore
upload_time	2024-08-08 15:43:05
maintainer	None
docs_url	None
author	Andrew Sosa
requires_python	<4,>=3.8
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": null,
    "docs_url": null,
    "requires_python": "<4,>=3.8",
    "maintainer_email": null,
    "keywords": "sqlalchemy, postgres, database, etl, s3",
    "author": "Andrew Sosa",
    "author_email": "andrewso@known.is",
    "download_url": "https://files.pythonhosted.org/packages/38/69/cc55e8af836fbfc378c001181440065974c3377c05563d219405d556fe80/databudgie-2.8.6.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.6",
    "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": "4d5a46e64d9f06378a63503eb73942e6371f46b633bf67a7b78fa502af7643e8",
                "md5": "01a688c8daddd7829da3d959afaec864",
                "sha256": "53beb33637a788e03a1bcb9f43cf82567ce5cba49b1a8e9be1f8b8ae19ff09e3"
            },
            "downloads": -1,
            "filename": "databudgie-2.8.6-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "01a688c8daddd7829da3d959afaec864",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": "<4,>=3.8",
            "size": 39537,
            "upload_time": "2024-08-08T15:43:03",
            "upload_time_iso_8601": "2024-08-08T15:43:03.782905Z",
            "url": "https://files.pythonhosted.org/packages/4d/5a/46e64d9f06378a63503eb73942e6371f46b633bf67a7b78fa502af7643e8/databudgie-2.8.6-py3-none-any.whl",
            "yanked": false,
            "yanked_reason": null
        },
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "3869cc55e8af836fbfc378c001181440065974c3377c05563d219405d556fe80",
                "md5": "d16af12a24e73b98820747f163049db1",
                "sha256": "72228ef1c455901d82165c09aa53002ed955176719b0717154bf6725eccbd958"
            },
            "downloads": -1,
            "filename": "databudgie-2.8.6.tar.gz",
            "has_sig": false,
            "md5_digest": "d16af12a24e73b98820747f163049db1",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": "<4,>=3.8",
            "size": 32610,
            "upload_time": "2024-08-08T15:43:05",
            "upload_time_iso_8601": "2024-08-08T15:43:05.295456Z",
            "url": "https://files.pythonhosted.org/packages/38/69/cc55e8af836fbfc378c001181440065974c3377c05563d219405d556fe80/databudgie-2.8.6.tar.gz",
            "yanked": false,
            "yanked_reason": null
        }
    ],
    "upload_time": "2024-08-08 15:43:05",
    "github": true,
    "gitlab": false,
    "bitbucket": false,
    "codeberg": false,
    "github_user": "schireson",
    "github_project": "databudgie",
    "travis_ci": false,
    "coveralls": false,
    "github_actions": true,
    "lcname": "databudgie"
}