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.6.tar.gz
(32.6 kB
view details)
Built Distribution
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
Algorithm | Hash digest | |
---|---|---|
SHA256 | 72228ef1c455901d82165c09aa53002ed955176719b0717154bf6725eccbd958 |
|
MD5 | d16af12a24e73b98820747f163049db1 |
|
BLAKE2b-256 | 3869cc55e8af836fbfc378c001181440065974c3377c05563d219405d556fe80 |
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
Algorithm | Hash digest | |
---|---|---|
SHA256 | 53beb33637a788e03a1bcb9f43cf82567ce5cba49b1a8e9be1f8b8ae19ff09e3 |
|
MD5 | 01a688c8daddd7829da3d959afaec864 |
|
BLAKE2b-256 | 4d5a46e64d9f06378a63503eb73942e6371f46b633bf67a7b78fa502af7643e8 |