Features I'd Like in PostgreSQL

• rum

  11 694 4.0 C

  RUM access method - inverted index with additional information in posting lists (by postgrespro)

  

>Reduce the memory usage of prepared queries

Yes query plan reuse like every other db, this still blows me away PG replans every time unless you explicitly prepare and that's still per connection.

Better full-text scoring is one for me that's missing in that list, TF/IDF or BM25 please see: https://github.com/postgrespro/rum

• OpenLogReplicator

  2 248 8.7 C++

  Open Source Oracle database CDC

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

• InfluxDB

  www.influxdata.com featured

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• ora2pg

  3 960 9.0 Perl

  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.

Have you heard of "ora2pg"? It works for both MySQL and Oracle:

https://github.com/darold/ora2pg

https://ora2pg.darold.net/

• Hashids.java

  32 1,012 0.0 Java

  Hashids algorithm v1.0.0 implementation in Java

  

I found hashids [1] to be a great compromise between integer ids in the database and copyable non-enumerable strings on the client.

[1] https://hashids.org/

• peripheral-emulator-bridge

  1 0 10.0 C++

  Pico C++ "Bridge" for microcontroller-web app communication

Not sure if Web Serial APIs count, but I'll run with it.

I created a two-part project: a web app you configure ad simulate a few* peripherals in, and a bridge device that can interact with the simulated peripherals. Essentially, a bridge between the physical microprocessor you've programmed, and the web app. Doesn't work on Firefox because those APIs aren't available however.

* few being one of seven-segment display, "ultrasonic sensor", and a simple LED.

https://github.com/sk0g/peripheral-emulator-bridge

• peripheral-emulator-web-app

  1 0 10.0 Svelte

  Svelte-based web app for emulating electronic peripheral devices

• pg_plan_guarantee

  4 83 0.0 C

  Postgres Query Optimizer Extension that guarantees your desired plan will not change

  

For 4) I've heard there's this available https://github.com/DrPostgres/pg_plan_guarantee

• SaaSHub

  www.saashub.com featured

  SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

  

• postgres-operator

  36 3,989 8.6 Go

  Postgres operator creates and manages PostgreSQL clusters running in Kubernetes

  

In Kubernetes a service call end an operator watches for CRD specifying databases to be created and manages upgrade and backs for those databases.

https://github.com/zalando/postgres-operator

• orioledb

  25 2,640 9.2 C

  OrioleDB – building a modern cloud-native storage engine (... and solving some PostgreSQL wicked problems)  🇺🇦

  

> I’d love to see B-Tree primary storage option. Aka store the row data inside the primary index.

It is coming: https://github.com/orioledb/orioledb

• pg_ivm

  19 779 6.3 C

  IVM (Incremental View Maintenance) implementation as a PostgreSQL extension

  

• pg_hint_plan

  12 650 7.5 C

  Extension adding support for optimizer hints in PostgreSQL

  

• pg_jsonschema

  15 937 6.6 Rust

  PostgreSQL extension providing JSON Schema validation

  

Sounds dumb, but I want JSON field schema validation. I added a JSON column for flexible data, and although I'm happy with its flexibility, I kinda hope I can validate the JSON data structure. Recently I just found an extension [1] and will try soon.

[1] https://github.com/supabase/pg_jsonschema

• ClickHouse

  208 34,269 10.0 C++

  ClickHouse® is a free analytics DBMS for big data

  

Simply by larger sizes of compressed blocks, which are limited to page size in Postgres, and by improving the data locality by sorting, which is inherent for LSM-trees.

But if you want higher compression, you need to consider column-oriented DBMS, such as ClickHouse[1]. They are unbeatable in terms of data compression.

[1] https://github.com/ClickHouse/ClickHouse

Disclaimer: I'm a developer of ClickHouse.

• gql-sql-pgq-pointers

  1 37 5.6

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

• SaaSHub

  www.saashub.com featured

  SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

  

Suggest a related project