ora2pg
| ora2pg | gql-sql-pgq-pointers | |
|---|---|---|
| 3 | 1 | |
| 960 | 37 | |
| - | - | |
| 9.0 | 5.6 | |
| 24 days ago | 4 months ago | |
| Perl | ||
| GNU General Public License v3.0 only | - |
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.
ora2pg
-
Oracle Auto indexes missing after ora2pg migration? Look at CONSTRAINT_INDEX
It seems that Oracle customers started using the Auto Index feature. I can see that when they migrate to YugabyteDB. YugabyteDB Voyager is a tool to ease the migration of schema and data. As YugabyteDB is PostgreSQL compatible, ora2pg is used when the source is Oracle. It extracts the schema and data. Some customers moving from Oracle ATP managed service (Autonomous Transaction Processing) reported that a few indexes were not extracted: the ones that have been created automatically by the Automatic Indexing feature of Oracle 19c.
-
Features I'd Like in PostgreSQL
Have you heard of "ora2pg"? It works for both MySQL and Oracle:
https://github.com/darold/ora2pg
https://ora2pg.darold.net/
- Using Ora2Pg to Migrate Data from Oracle to openGauss
gql-sql-pgq-pointers
-
Features I'd Like in PostgreSQL
a great project that shows that such a convergence is not out of the question!
It seems that some sort of graph querying will be part of an upcoming sql:2023 standard but detail is sparse. This repo seems to have collected some relevant links [0]
[0] https://github.com/szarnyasg/gql-sql-pgq-pointers
What are some alternatives?
pg_plan_guarantee - Postgres Query Optimizer Extension that guarantees your desired plan will not change
pg_hint_plan - Extension adding support for optimizer hints in PostgreSQL
pg_ivm - IVM (Incremental View Maintenance) implementation as a PostgreSQL extension
OpenLogReplicator - Open Source Oracle database CDC
rum - RUM access method - inverted index with additional information in posting lists
postgres-operator - Postgres operator creates and manages PostgreSQL clusters running in Kubernetes
Hashids.java - Hashids algorithm v1.0.0 implementation in Java
peripheral-emulator-web-app - Svelte-based web app for emulating electronic peripheral devices