Skip to main content

Ergonomic and flexible tool for database backup and restore

Project description

Databudgie

Github Actions Build codecov 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.9.2.tar.gz (267.7 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

databudgie-2.9.2-py3-none-any.whl (34.1 kB view details)

Uploaded Python 3

File details

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

File metadata

  • Download URL: databudgie-2.9.2.tar.gz
  • Upload date:
  • Size: 267.7 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: uv/0.10.11 {"installer":{"name":"uv","version":"0.10.11","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"Ubuntu","version":"24.04","id":"noble","libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":true}

File hashes

Hashes for databudgie-2.9.2.tar.gz
Algorithm Hash digest
SHA256 ab51f06a61e2bc81a47c689158660351a9054b9284fe73a186156f626a7cfcbe
MD5 80fe1a9f40b062143b625821a46d52c0
BLAKE2b-256 945bc1f97d69bf89933e1497255fe826028300d8151d039ac6074b18146ea871

See more details on using hashes here.

File details

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

File metadata

  • Download URL: databudgie-2.9.2-py3-none-any.whl
  • Upload date:
  • Size: 34.1 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: uv/0.10.11 {"installer":{"name":"uv","version":"0.10.11","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"Ubuntu","version":"24.04","id":"noble","libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":true}

File hashes

Hashes for databudgie-2.9.2-py3-none-any.whl
Algorithm Hash digest
SHA256 c3943eb061a6c7ba93e8b139ae8947a0b8e75a016b475d61cc2697395327d094
MD5 56ac2a457e9b6712376eeafdc886ec66
BLAKE2b-256 230a7c0749803f068dbe19c0700e899fc97ac29bd1781691ea205734df09e9d9

See more details on using hashes here.

Supported by

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