DuckDB

DuckDB is an analytical in-process SQL database management system (by duckdb)

DuckDB Alternatives

Similar projects and alternatives to DuckDB

  1. ClickHouse

    ClickHouse® is a real-time analytics database management system

  2. InfluxDB

    InfluxDB – Built for High-Performance Time Series Workloads. InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.

    InfluxDB logo
  3. steampipe

    Zero-ETL, infinite possibilities. Live query APIs, code & more with SQL. No DB required.

  4. ClickBench

    ClickBench: a Benchmark For Analytical Databases

  5. db-benchmark

    reproducible benchmark of database-like ops

  6. citus

    73 DuckDB VS citus

    Distributed PostgreSQL as an extension

  7. react-admin

    71 DuckDB VS react-admin

    A frontend Framework for single-page applications on top of REST/GraphQL APIs, using TypeScript, React and Material Design

  8. Stream

    Stream - Scalable APIs for Chat, Feeds, Moderation, & Video. Stream helps developers build engaging apps that scale to millions with performant and flexible Chat, Feeds, Moderation, and Video APIs and SDKs powered by a global edge network and enterprise-grade infrastructure.

    Stream logo
  9. datafusion

    Apache DataFusion SQL Query Engine

  10. sqlglot

    62 DuckDB VS sqlglot

    Python SQL Parser and Transpiler

  11. q

    47 DuckDB VS q

    q - Run SQL directly on delimited files and multi-file sqlite databases (by harelba)

  12. octosql

    OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.

  13. columnar

    Postgres-native columnar storage extension

  14. chdb

    29 DuckDB VS chdb

    chDB is an in-process OLAP SQL Engine 🚀 powered by ClickHouse

  15. pygwalker

    28 DuckDB VS pygwalker

    PyGWalker: Turn your dataframe into an interactive UI for visual analysis

  16. tidy-viewer

    📺(tv) Tidy Viewer is a cross-platform CLI csv pretty printer that uses column styling to maximize viewer enjoyment.

  17. zsv

    zsv+lib: tabular data swiss-army knife CLI + world's fastest (simd) CSV parser

  18. textql

    16 DuckDB VS textql

    Execute SQL against structured text like CSV or TSV

  19. csvq

    14 DuckDB VS csvq

    SQL-like query language for csv

  20. TimescaleDB

    A time-series database for high-performance real-time analytics packaged as a Postgres extension

  21. duckdb-rs

    Ergonomic bindings to duckdb for Rust

  22. 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 better DuckDB alternative or higher similarity.

DuckDB discussion

Log in or Post with

DuckDB reviews and mentions

Posts with mentions or reviews of DuckDB. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2025-05-29.
  • ClickHouse raises $350M Series C
    7 projects | news.ycombinator.com | 29 May 2025
    Thanks for creating this issue, it is worth investigating!

    I see you also created similar issues in Polars: https://github.com/pola-rs/polars/issues/17932 and DuckDB: https://github.com/duckdb/duckdb/issues/17066

    ClickHouse has a built-in memory tracker, so even if there is not enough memory, it will stop the query and send an exception to the client, instead of crashing. It also allows fair sharing of memory between different workloads.

    You need to provide more info on the issue for reproduction, e.g., how to fill the tables. 16 GB of memory should be enough even for a CROSS JOIN between a 10 billion-row and a 100-row table, because it is processed in a streaming fashion without accumulating a large amount of data in memory. The same should be true for a merge join.

    However, there are places when a large buffer might be needed. For example, if you insert data into a table backed by S3 storage, it requires a buffer that can be in the order of 500 MB.

    There is a possibility that your machine has 16 GB of memory, but most of it is consumed by Chrome, Slack, or Safari, and not much is left for ClickHouse server.

  • ClickHouse gets lazier (and faster): Introducing lazy materialization
    5 projects | news.ycombinator.com | 22 Apr 2025
    It does, but the performance isn't great apparently: https://github.com/duckdb/duckdb/discussions/10161
  • DuckDB 1.2.2 Released
    1 project | news.ycombinator.com | 9 Apr 2025
  • The DuckDB Local UI
    21 projects | news.ycombinator.com | 12 Mar 2025
    I agree that the blog post seems to hint at the fact that this functionality is fully baked in in certain places - we've adjusted the blog post to be more explicit on the fact that this is an extension.

    We have collaborated with MotherDuck on streamlining the experience of launching the UI through auto-installation, but the DuckDB Foundation still remains in full control of DuckDB and the extension ecosystem. This has no impact on that.

    For further clarification:

    * The auto-installation mechanism is identical to that of other trusted extensions - the auto-installation is triggered when a specific function is called that does not exist in the catalog - in this case the `start_ui` function. See [1]. The query I mentioned just calls that function. The only special feature here is the addition of the CLI flag (and what that flag executes is user-configurable).

    * The HTTP server is necessary for the extension to function as the extension needs to communicate with the browser. The server is open-source as part of the extension code [2]. The server (1) fetches web resources (javascript/css) from ui.duckdb.org, and (2) communicates with localhost to co-ordinate the UI with DuckDB. Outside of these the server doesn't interface with other external web services.

    [1] https://github.com/duckdb/duckdb/blob/main/src/include/duckd...

  • Should You Ditch Spark for DuckDB or Polars?
    3 projects | news.ycombinator.com | 15 Dec 2024
  • Gah – CLI to install software from GitHub Releases
    8 projects | news.ycombinator.com | 11 Dec 2024
    1) https://github.com/duckdb/duckdb/releases/download/v1.1.3/duckdb_cli-linux- amd64.zip
  • Show HN: Trilogy – A Reusable, Composable SQL Experiment
    5 projects | news.ycombinator.com | 25 Nov 2024
    Any particular examples you have in mind? The demo is just referencing https://github.com/duckdb/duckdb/tree/main/extension/tpcds/d... which I wouldn't regard as a standard of good SQL; (implicit joins, yikes!) - but is a useful capability reference (as is tpc-ds in general).

    As I tried to convey, I like SQL a lot - my frustration is more around the lifecycle and maintainability.

    Happy to add more ergonomic references in other places, if you have some good examples to reference against?

  • SQL-92 in TPC Benchmarks: Are They Still Relevant?
    1 project | dev.to | 25 Oct 2024
    I was reading "pg_duckdb beta release: Even faster analytics in Postgres", which demonstrates that the execution of TPC-DS Query 01 is 1500 times faster on DuckDB compared to PostgreSQL. Naturally, I was curious to see how this query performs in YugabyteDB. However, when I examined the SQL query that was used, which repeatedly accesses the same table and conducts analytics without utilizing analytic functions, I wondered: should we be spending time, in 2024, examining queries from analytics benchmarks that were written on SQL-92 while ignoring the window functions introduced in SQL:2003?
  • DuckDB v1.1.2
    1 project | news.ycombinator.com | 14 Oct 2024
  • DuckDB 1.1.0 Released
    4 projects | news.ycombinator.com | 9 Sep 2024
    The last I read, the Spark API was to become the focus point.

    https://duckdb.org/docs/api/python/spark_api

    Not sure what the current status is.

    ref: <https://github.com/duckdb/duckdb/issues/2000#issuecomment-18...>

  • A note from our sponsor - SaaSHub
    www.saashub.com | 13 Jul 2025
    SaaSHub helps you find the best software and product alternatives Learn more →

Stats

Basic DuckDB repo stats
70
30,765
10.0
8 days ago

Sponsored
InfluxDB – Built for High-Performance Time Series Workloads
InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.
www.influxdata.com

Did you know that C++ is
the 7th most popular programming language
based on number of references?