ClickHouse VS DuckDB

ClickHouse Reviews

DuckDB Reviews

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 / 3 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 / 5 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: 6 months ago

DuckDB mentions (14)

• Tactical Cloud Audit Log Analysis with DuckDB - AWS CloudTrail

  More than once, I have been in a situation where I needed to query CloudTrail logs but was working in a customer environment where they weren’t aggregated to a search interface. Another similar situation is when CloudTrail data events are disabled for cost reasons but need to be temporarily turned on for troubleshooting/audit purposes. While the CloudTrail console offers some (very) limited lookups (for management... - Source: dev.to / 1 day ago

• How to choose the right type of database

  DuckDB: An in-process SQL OLAP database management system. While not a traditional OLAP database, DuckDB is designed to execute analytical queries efficiently, making it suitable for analytical workloads within data-intensive applications. - Source: dev.to / 3 months ago

• SIMD-Scan: Ultra Fast In-Memory Table Scan [pdf]

  Easiest way to practically use SIMD table scan database is try out DuckDB: https://duckdb.org/. - Source: Hacker News / 3 months ago

• 🎀 Domaine.nc data as Jupyter on Kaggle 📊

  Duckdb so we can make OLAP like queries on the data. - Source: dev.to / 6 months ago

• The simplicity of DuckDB

  DuckDB is an open source (MIT) high-performance, in-process SQL database for analytics. It is a relatively new project (the first public release was in June 2019), but got tremendously popular in a short period of time. - Source: dev.to / 6 months ago