examples
Examples for Oh Krab! (by ohkrab)
pg-clone-schema
Postgres clone schema utility without need of going outside of database. Makes developers life easy by running single function to clone schema with all objects. It is very handy on Postgres RDS. Utility is sponsored by http://elephas.io/ (by denishpatel)
examples | pg-clone-schema | |
---|---|---|
1 | 3 | |
0 | 161 | |
- | - | |
10.0 | 8.1 | |
over 1 year ago | about 1 month ago | |
HCL | PLpgSQL | |
MIT License | MIT License |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
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.
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.
examples
Posts with mentions or reviews of examples.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-02-03.
-
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:
pg-clone-schema
Posts with mentions or reviews of pg-clone-schema.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-10-01.
-
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?
What are some alternatives?
When comparing examples and pg-clone-schema you can also consider the following projects:
gh-ost - GitHub's Online Schema-migration Tool for MySQL
pg_branch - Experimental Postgres extension for quickly branching databases through file system snapshots