ClickHouse: An open-source column-oriented database management system

This page summarizes the projects mentioned and recommended in the original post on news.ycombinator.com
Analytics Database SQL distributed-database Big Data

InfluxDB - 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.
www.influxdata.com
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured

  • ClickHouse

    ClickHouse® is a free analytics DBMS for big data

  • hn-search

    Hacker News Search

  • InfluxDB

    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.

    InfluxDB logo

  • clickhousedb_fdw

    PostgreSQL's Foreign Data Wrapper For ClickHouse

    • Maybe you could do something with postgres foreign data wrappers?

    For example this exists, not sure about maturity though https://github.com/Percona-Lab/clickhousedb_fdw

  • Trino

    Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io)

    • Take a look at query engines like Trino (formerly PrestoSQL) [https://trino.io/]. (Disclaimer: I'm a contributor to Trino).

    I used it at a previous job to combine data from MongoDB, Kafka, S3 and Postgres to great effect. It tries to push-down as many operations as possible to the source too to improve performance.

    Full ANSI SQL support over multiple number of backends (Kafka, Cassandra, Postgres, ClickHouse, S3 and many more).

    The best part is it has a plugin ecosystem so you can very easily implement your own connectors and all the heavy lifting gets done by the core-engine while your plugin only has to abstract your backend to concepts that the engine can understand.

  • pirsch

    Pirsch is a drop-in, server-side, no-cookie, and privacy-focused analytics solution for Go.

    • A really nice database. We use it to aggregate web analytical data in real-time for Pirsch [0] and it performs really well. Writing queries for it is close to relational databases, which made the switch from Postgres easier. User data is still managed in Postgres and losely coupled through an ID field.

    [0] https://pirsch.io/

  • SaaSHub

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

    SaaSHub logo
NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts