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.4.tar.gz (30.6 kB view hashes)

Uploaded Source

Built Distribution

databudgie-2.8.4-py3-none-any.whl (37.6 kB view hashes)

Uploaded Python 3

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