{"data":{"slug":"ducklake","name":"DuckLake","tagline":"MIT lakehouse table format on SQL + Parquet — a DuckDB extension","category":"databases","categoryName":"Databases","url":"https://ducklake.select","github":"https://github.com/duckdb/ducklake","pricing":"open-source","hook":"DuckLake is an open lakehouse format from the DuckDB team: table metadata lives in an ordinary SQL database, data lives in Parquet files on disk or object storage — snapshots, time travel, and schema evolution without a custom catalog server.","whatsGood":"MIT (Stichting DuckDB Foundation). DuckLake v1.0 is out; `INSTALL ducklake;` then `ATTACH 'ducklake:metadata.ducklake' AS lake (DATA_PATH 'files/');` and use plain SQL. Catalog can be DuckDB, PostgreSQL, SQLite, or MySQL; Parquet on local disk or S3-compatible storage; multiple clients against one catalog. The first lakehouse table format on Stack Gems. ★~3k.","theCatch":"Needs a separate catalog database you run and back up (DuckDB file for one writer, Postgres/MySQL for multi-client). Engines outside DuckDB support it far less widely than Iceberg or Delta Lake — check your Spark/Trino/warehouse story before committing. Younger format with a shorter production track record. Vs the duckdb gem: DuckDB is the engine; DuckLake is the table format and catalog layer on top.","verdict":"MIT SQL-catalog lakehouse format when DuckDB is your engine and Iceberg’s catalog stack feels heavy — confirm multi-engine support first.","addedAt":"2026-10-08","featured":false,"domain":"Databases","subSpecialty":"Lakehouse","subcategory":"Analytics & Time-series","tags":["self-host","permissive","active"],"capabilities":["lakehouse","parquet","sql"],"surfaces":["Self-host"],"ecosystem":["Multi-platform"],"licenseModel":"OSS/MIT","githubStars":3316,"starsPerWeek":39,"access":"free","archived":false,"repo":{"createdAt":"2025-03-03","pushedAt":"2026-10-17","license":"MIT","archived":false,"checkedAt":"2026-10-19"}},"related":[{"slug":"supabase","name":"Supabase","tagline":"Open-source Firebase alternative built on Postgres"},{"slug":"turso","name":"Turso","tagline":"SQLite at the edge with libSQL"},{"slug":"redis","name":"Redis","tagline":"The in-memory data store everyone uses"},{"slug":"upstash","name":"Upstash","tagline":"Serverless Redis and Kafka"},{"slug":"pinecone","name":"Pinecone","tagline":"Vector database for AI applications"}],"links":{"self":"/api/gems/ducklake","html":"/gems/ducklake","markdown":"/gems/ducklake.md","category":"/api/gems?category=databases","categoryPage":"/stacks/databases"}}