Postgres Just Cracked the Top Fastest Databases for Analytics

1. pg_mooncake

   1 18 1,313 8.9 C++

   Postgres Data Warehouse, built on Iceberg

   

   Actually, it is, in a diagram right at the top of https://github.com/Mooncake-Labs/pg_mooncake.

   However, the Venn diagram does not tell me anything useful, so I agree with the sentiment. Would love it if someone could explain what mooncake is good for and what its strengths and weaknesses are vs Timescale.

2. InfluxDB

   influxdata.com featured

   InfluxDB high-performance time series database. Collect, organize, and act on massive volumes of high-resolution data to power real-time intelligent systems.

   

3. privaxy

   2 34 2,438 0.0 Rust

   Privaxy is the next generation tracker and advertisement blocker. It blocks ads and trackers by MITMing HTTP(s) traffic. Also check out my new project, https://www.merklemap.com/

   

   Same for https://www.merklemap.com/

   Biggest table is 27B records, a query that uses a btree index completes in a few microseconds…

       EXPLAIN ANALYZE SELECT * FROM table_name WHERE id = [ID_VALUE];

4. ghtorrent.org

   3 1 153 0.0 Ruby

   The GHtorrent project website

   

   Yep. I used it once for a personal project involving GHTorrent [0], and each query was about $20. That may be peanuts for a business, but for someone playing around on their own, it's incredibly prohibitive.

   [0]: https://github.com/ghtorrent/ghtorrent.org/blob/master/gclou...

5. ClickBench

   4 92 788 9.8 HTML

   ClickBench: a Benchmark For Analytical Databases

   

   people tried to run spark (better hadoop) and failed lol. https://github.com/ClickHouse/ClickBench/pull/139

6. pg_duckdb

   5 8 2,174 9.7 C++

   DuckDB-powered Postgres for high performance apps & analytics.

   

   In v0.1, we have a dependency on pg_duckdb which does not support citus (https://github.com/duckdb/pg_duckdb/issues/444).

   With what we're working in v0.2, we re-architecture some of our dependencies there, and will be able to scale out and support Citus.

7. CodeRabbit

   coderabbit.ai featured

   CodeRabbit: AI Code Reviews for Developers. Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.

   

Suggest a related project