DuckDB

DuckDB with Hannes Mühleisen - Software Engineering Daily podcast

DuckDB is an open-source column-oriented relational database that was first released in 2019. It’s designed to provide high performance on complex queries against large databases, and focuses on online analytical processing workloads.

Hannes Mühleisen is the Co-Creator of DuckBD, and is the CEO and Co-Founder of DuckDB Labs. He joins the show to talk about drawing inspiration from SQLite, why DuckDB was written in C++, the novel data processing scenarios it enables, and more.

Hannes Mühleisen | LinkedIn

Professor of Data Engineering

Radboud University Nijmegen, Netherlands

Freie Universität Berlin
Freie Universität BerlinDoctor of Philosophy - PhD, Computer Science

DuckDB – An in-process SQL OLAP database management system

DuckDB is a fast in-process analytical database
DuckDB supports a feature-rich SQL dialect complemented with deep integrations into client APIs.
DuckDB v1.0.0 was released in June 2024.

// Get the top-3 busiest train stations in May
const duckdb = require('duckdb');
const db = new duckdb.Database(':memory:');
db.all(
  `SELECT station_name, count(*) AS num_services
    FROM 'http://blobs.duckdb.org/train_services.parquet'
    WHERE monthname(date) = 'May'
    GROUP BY ALL
    ORDER BY num_services DESC
    LIMIT 3;`,
  (err, res) => {
    if (err) {
      console.log("Error", err);
    } else {
      console.table(res);
    }
  }
);

GitHub - duckdb/duckdb: DuckDB is an analytical in-process SQL database management system @GitHub, MIT license, C++

DuckDB - Wikipedia

DuckDB — SQLite for Analytics. DuckDB is a really interesting project… | by Robby Boney | Short Bits | Medium