index_advisor
OpenLogReplicator
| index_advisor | OpenLogReplicator | |
|---|---|---|
| 5 | 2 | |
| 1,462 | 249 | |
| 4.4% | - | |
| 2.8 | 8.7 | |
| about 1 month ago | 6 days ago | |
| PLpgSQL | C++ | |
| PostgreSQL License | 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.
index_advisor
-
Bloom Filter Indexes in PostgreSQL
pghero and/or https://github.com/supabase/index_advisor
If you want to pay for a saas then pganalyze is like $400 a month for 4 dbs is a pretty good pricing model
- FLaNK AI-April 22, 2024
-
Supabase Security Advisor & Performance Advisor
The Supabase Index Advisor is now available inside Supabase Studio. We've integrated the Index Advisor into our existing Query Performance tool so that you can find your slowest queries and check recommendations. As its name suggests, this analyzes your queries and make recommendations to add or remove table indexes.
-
Show HN: PostgreSQL Index Advisor
2. Copy/paste the plpgsql file:
https://github.com/supabase/index_advisor/blob/main/index_ad...
We are also developing the Trusted Language Extension with the RDS team, so at some point it should be easier to do this through database.dev:
https://database.dev/olirice/index_advisor
OpenLogReplicator
- FLaNK AI-April 22, 2024
-
Features I'd Like in PostgreSQL
Good luck with that! Oracle have never made anything that they can't extract money from. In this case look to their attempts to kill logminer (which most CDC systems eg. Debezium use) and force you to pay for Goldengate hub/microservices/cloud.
Not tried it, but https://github.com/bersler/OpenLogReplicator
What are some alternatives?
postgres-operator - Postgres operator creates and manages PostgreSQL clusters running in Kubernetes
pg_ivm - IVM (Incremental View Maintenance) implementation as a PostgreSQL extension
pg_hint_plan - Extension adding support for optimizer hints in PostgreSQL
ora2pg - Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL.
gql-sql-pgq-pointers
Hashids.java - Hashids algorithm v1.0.0 implementation in Java
rum - RUM access method - inverted index with additional information in posting lists
orioledb - OrioleDB – building a modern cloud-native storage engine (... and solving some PostgreSQL wicked problems) 🇺🇦
peripheral-emulator-bridge - Pico C++ "Bridge" for microcontroller-web app communication
pg_plan_guarantee - Postgres Query Optimizer Extension that guarantees your desired plan will not change
pg_jsonschema - PostgreSQL extension providing JSON Schema validation
peripheral-emulator-web-app - Svelte-based web app for emulating electronic peripheral devices