TiDB VS ClickHouse

TiDB Reviews

ClickHouse Reviews

TiDB mentions (15)

• A MySQL compatible database engine written in pure Go

  Tidb has been around for a while, it is distributed, written in Go and Rust, and MySQL compatible. https://github.com/pingcap/tidb. - Source: Hacker News / 18 days ago

• Ask HN: Who is hiring? (January 2023)

  PingCAP | https://www.pingcap.com | Database Engineer, Product Manager, Developer Advocate and more | Remote in California | Full-time We work on a MySQL compatible distributed database called TiDB https://github.com/pingcap/tidb/. - Source: Hacker News / over 1 year ago

• Apache Pegasus – A a distributed key-value storage system

  Isn't TiDB built on top of TiKV?[0] [0]: https://github.com/pingcap/tidb. - Source: Hacker News / over 1 year ago

• What is your experience with mixed workload (OLTP and OLAP) databases?

  OLTP usually comes with high throughput of transactions, which means usually write(e.g., IUD - insert, update, delete) to read (e.g., select) ratio is above 4 or 5 or even higher. There are some good benchmarks to test OLTP workload like TPC-C (https://www.tpc.org/tpcc/), and some benchmarks to test OLAP workload like TPC-H (https://www.tpc.org/tpch/). For mixed or hybrid OLTP and OLAP (it's called HTAP, see this... - Source: Hacker News / almost 2 years ago

• NewDB: Fate of an Open Source Database

  I am very agree with some options of this blog. As the maintainer of the open source distributed database TiDB https://github.com/pingcap/tidb, we also face the same problem of choice. We have a community version, an enterprise version(of course, we must sell it to our customers to earn money) and also a cloud service named TiDB cloud. Seven years before, we started to build TiDB to solve MySQL sharding problem,... - Source: Hacker News / almost 2 years ago

ClickHouse mentions (43)

• The 2024 Web Hosting Report

  For the third, examples here might be analytics plugins in specialized databases like Clickhouse, data-transformations in places like your ETL pipeline using Airflow or Fivetran, or special integrations in your authentication workflow with Auth0 hooks and rules. - Source: dev.to / 2 months ago

• Choosing Between a Streaming Database and a Stream Processing Framework in Python

  Online analytical processing (OLAP) databases like Apache Druid, Apache Pinot, and ClickHouse shine in addressing user-initiated analytical queries. You might write a query to analyze historical data to find the most-clicked products over the past month efficiently using OLAP databases. When contrasting with streaming databases, they may not be optimized for incremental computation, leading to challenges in... - Source: dev.to / 3 months ago

• Real-Time Data Enrichment and Analytics With RisingWave and ClickHouse

  To achieve seamless real-time data ingestion, transformation, and analytics, a powerful combination to explore is RisingWave and ClickHouse. RisingWave is a PostgreSQL-compatible database specifically designed for stream processing. It excels at ingesting real-time data streams, performing diverse transformations, and enabling instant querying of results. ClickHouse® is a high-performance, column-oriented SQL... - Source: dev.to / 4 months ago

• Ask HN: Is there a Hacker News takeout to export my comments / upvotes, etc.?

  You can export the whole dataset as described here: https://github.com/ClickHouse/ClickHouse/issues/29693

      curl https://clickhouse.com/ | sh.

  - Source: Hacker News / 5 months ago

• Best alternative

  Nowadays I am looking at the clickhouse and how it might help me maybe you can check it out: https://clickhouse.com/. Source: 5 months ago