4 releases (1 stable)
|1.0.0||Mar 16, 2023|
|0.4.3||Oct 26, 2022|
|0.3.1||Mar 9, 2022|
|0.3.0||Mar 8, 2022|
#110 in Database interfaces
21 downloads per month
A very minimal subset of
pg_dump --data-only with multi-tenancy in mind. A solution to: https://postgrespro.com/list/thread-id/1715772
Most options are specified via config file.
column_name = "customer_id" schema_name = "public" database_url = "postgres://localhost:15432/postgres" features = ["currency", "audit"] skip_tables = [ "_backup&", "^obsolete_" # ... more regular expressions ] [overrides] # We only want the one customer identified by --id on the command line customers = """ select * from customers where id in :ids """ # The `user_files` table doesn't have a customer_id column, so we need to join. user_files = """ select user_files.* from users_files join users on users.id = user_files.user_id where users.customer_id in :ids """ daily_exchange_rates = """ select * from daily_exchange_rates where 'currency' = any (current_setting('pg_parcel.features')::text) """ audit_log = """ select * from audit_log where customer_id in :ids and ( ARRAY['audit'] && (current_setting('pg_parcel.features')::text) or created_at >= NOW() - INTERVAL '30 days' or updated_at >= NOW() - INTERVAL '30 days' ); """
||The list of all values passed with
||The list of features defined in the
||Same rules as
We publish binaries for both Linux x86_64 (any distro, using musl) and macOS Universal (both Intel and Apple Silicon in a single binary).
To create a new release, update
Cargo.toml and create a tag like
v1.2.3 (SemVer, prefixed with
Licensed under either of
- Apache License, Version 2.0 (LICENSE-APACHE or http://www.apache.org/licenses/LICENSE-2.0)
- MIT license (LICENSE-MIT or http://opensource.org/licenses/MIT)
at your option.
Unless you explicitly state otherwise, any contribution intentionally submitted for inclusion in the work by you, as defined in the Apache-2.0 license, shall be dual licensed as above, without any additional terms or conditions.