DuckDB Alternatives

Apps similar to DuckDB include SQLite, which is free and open source. Other options are ClickHouse, Valentina Server, Apache Pinot and SlateDB. You can choose from more than 10 Relational Databases like DuckDB for Linux, Mac, Windows, self-hosting and the web.

Copy a direct link to this comment to your clipboard
Alternatives
DuckDB alternatives page was last updated

Alternatives list

  1. SQLite icon
     377 likes

    SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world. The source code for SQLite is in the public domain.

    74 SQLite alternatives

    Cost / License

    • Free
    • Open Source

    Application type

    Platforms

    • Mac
    • Windows
    • Linux
    • Android
    • iPhone
    • Self-Hosted
    Good alternative?
     
  2. ClickHouse icon
     5 likes

    ClickHouse is an open source column-oriented database management system capable of real time generation of analytical data reports using SQL queries.

    Cost / License

    Platforms

    • Mac
    • Linux
    • BSD
    • FreeBSD
    • Windows
    • Docker
    • Self-Hosted
    • Online
    • Software as a Service (SaaS)
    Good alternative?
     
  3. Valentina Server is 4 in 1: (Valentina DB / DuckDB / SQLite / Report) Server.

    Cost / License

    • Freemium
    • Proprietary

    Application type

    Platforms

    • Mac
    • Windows
    • Linux
    • Raspberry Pi
    Good alternative?
     
  4. Apache Pinot is a real-time distributed OLAP datastore, built to deliver scalable real-time analytics with low latency. It can ingest from batch data sources (such as Hadoop HDFS, Amazon S3, Azure ADLS, Google Cloud Storage) as well as stream data sources (such as Apache Kafka).

    Cost / License

    Platforms

    • Self-Hosted
    • Kubernetes
    • Docker
    • Amazon Web Services
    • Microsoft Azure
    • Mac
    • Windows
    • Linux
    • BSD
    Good alternative?
     
  5. SlateDB icon
     1 like

    An embedded database built on object storage. Unlike traditional LSM-tree storage engines, SlateDB writes data to object storage to provide bottomless storage capacity, high durability, and easy replication.

    Cost / License

    Platforms

    • Self-Hosted
    Good alternative?
     
  6. StarRocks icon
     2 likes

    StarRocks, a Linux Foundation project, is a next-generation sub-second MPP OLAP database for full analytics scenarios, including multi-dimensional analytics, real-time analytics, and ad-hoc queries. InfoWorld’s 2023 BOSSIE Award for best open source software.

    Cost / License

    Platforms

    • Linux
    Good alternative?
     
  7. Vertica icon
     1 like

    Vertica is a grid-based, column-oriented database designed to manage large, fast-growing volumes of data and provide very fast query performance when used for data warehouses and other query-intensive applications.

    Cost / License

    • Paid
    • Proprietary

    Application type

    Platforms

    • Linux
    Good alternative?
     
  8. PondPilot icon
     1 like

    A blazing-fast, lightweight, 100% client-side AI-enabled data exploration tool that helps you analyze local & remote data with zero setup. Powered by DuckDB-Wasm and integrated AI assistance.

    89 PondPilot alternatives

    Cost / License

    Platforms

    • Online
    • Self-Hosted
    • Docker
    Good alternative?
     
  9. AmberDB icon
     1 like

    AmberDB is a high-performance, flat-file NoSQL database engine for Perl built on top of Berkeley DB (DB_File). It combines the speed of flat-file storage with enterprise features: schema-driven multi-dimensional indexing, ACID-compliant transactions with Strict Two-Phase Locking...

    Cost / License

    • Free
    • Open Source

    Platforms

    • Windows
    • Mac
    • Linux
    Good alternative?
     
  10. DoltLite icon
     Like

    A SQLite fork that replaces the B-tree storage engine with a content-addressed prolly tree, giving Git-like version control on a SQL database. The parser, planner, and VDBE stay upstream-derived above SQLite's btree.

    Cost / License

    Application type

    Platforms

    • Mac
    • Linux
    • Windows
    • SQLite
    • Self-Hosted
    Good alternative?
     
  11. MonetDB icon
     1 like

    MonetDB is an open source column-oriented database management system developed at the National Research Institute for Mathematics and Computer Science (CWI; Centrum voor Wiskunde en Informatica) in the Netherlands.

    Cost / License

    Platforms

    • Mac
    • Windows
    • Linux
    Good alternative?
     
11 of 11 DuckDB alternatives