Skip to main content

Ergonomic and flexible tool for database backup and restore

Project description

Databudgie

Github Actions Build Coverage Status Documentation Status

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:

# 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

pip install databudgie

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

databudgie-2.8.6.tar.gz (32.6 kB view details)

Uploaded Source

Built Distribution

databudgie-2.8.6-py3-none-any.whl (39.5 kB view details)

Uploaded Python 3

File details

Details for the file databudgie-2.8.6.tar.gz.

File metadata

  • Download URL: databudgie-2.8.6.tar.gz
  • Upload date:
  • Size: 32.6 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: poetry/1.2.2 CPython/3.9.19 Linux/6.5.0-1025-azure

File hashes

Hashes for databudgie-2.8.6.tar.gz
Algorithm Hash digest
SHA256 72228ef1c455901d82165c09aa53002ed955176719b0717154bf6725eccbd958
MD5 d16af12a24e73b98820747f163049db1
BLAKE2b-256 3869cc55e8af836fbfc378c001181440065974c3377c05563d219405d556fe80

See more details on using hashes here.

File details

Details for the file databudgie-2.8.6-py3-none-any.whl.

File metadata

  • Download URL: databudgie-2.8.6-py3-none-any.whl
  • Upload date:
  • Size: 39.5 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: poetry/1.2.2 CPython/3.9.19 Linux/6.5.0-1025-azure

File hashes

Hashes for databudgie-2.8.6-py3-none-any.whl
Algorithm Hash digest
SHA256 53beb33637a788e03a1bcb9f43cf82567ce5cba49b1a8e9be1f8b8ae19ff09e3
MD5 01a688c8daddd7829da3d959afaec864
BLAKE2b-256 4d5a46e64d9f06378a63503eb73942e6371f46b633bf67a7b78fa502af7643e8

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page