Ergonomic and flexible tool for database backup and restore
Project description
Databudgie
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
Release history Release notifications | RSS feed
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.0.tar.gz
(29.5 kB
view hashes)
Built Distribution
databudgie-2.8.0-py3-none-any.whl
(35.9 kB
view hashes)
Close
Hashes for databudgie-2.8.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 298aebcaef994c2e9fa136dfa0a761d02e839d17d3ad361812edc61d00795278 |
|
MD5 | 2e37ee004c64612709c016215a4db14e |
|
BLAKE2b-256 | c03ff2ccd4992b0c00cdd6e44c24c11474f024e4faeb2e257dc57c2e112b2721 |