pg-clone-schema
examples
| pg-clone-schema | examples | |
|---|---|---|
| 3 | 1 | |
| 176 | 0 | |
| - | - | |
| 8.7 | 10.0 | |
| about 20 hours ago | almost 2 years ago | |
| PLpgSQL | HCL | |
| MIT License | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
pg-clone-schema
-
Pg_branch: Pre-alpha Postgres extension brings Neon-like branching
For ad hoc copies I’ve found the third party schema cloning function useful. I assume performance would be an issue for huge databases though. https://github.com/denishpatel/pg-clone-schema
- Does PostgreSQL have schema creation command which replicates all the objects of another schema?
examples
-
Does PostgreSQL have schema creation command which replicates all the objects of another schema?
If you insist on using schema cloning I could point you to my pet project: Oh, Krab! - still wip but problem you mentioned was one of factors why I started developing this. In this example I create two migration sets (one that is always in public schema, the other is the parametrized template that is applied to each tenant). So if you want to have multiple schemas you could call:
What are some alternatives?
pg_branch - Experimental Postgres extension for quickly branching databases through file system snapshots
gh-ost - GitHub's Online Schema-migration Tool for MySQL
database-lab-engine - DBLab enables 🖖 database branching and ⚡️ thin cloning for any Postgres database and empowers DB testing in CI/CD. This optimizes database-related costs while improving time-to-market and software quality. Follow to stay updated.
terragrunt-infrastructure-live-example - A repo used to show examples file/folder structures you can use with Terragrunt and Terraform
pgcow - Bringing copy-on-write semantics to PostgreSQL.
terragrunt-infrastructure-modules-example - A repo used to show examples file/folder structures you can use with Terragrunt and Terraform
dolt - Dolt – Git for Data
terraform-aws-components - Opinionated, self-contained Terraform root modules that each solve one, specific problem
bytebase - The GitHub/GitLab for database DevSecOps. World's most advanced database DevSecOps solution for Developer, Security, DBA and Platform Engineering teams.