DuckLake is an open Lakehouse format that combines a SQL catalog with Parquet storage to provide ACID-aware table semantics on data lakes. Metadata is kept in a catalog database while actual data lives in Parquet files; a DuckDB extension enables direct read/write access from DuckDB. It supports standard SQL operations (CREATE, INSERT, UPDATE), schema evolution (ALTER TABLE ADD COLUMN), time travel queries by version, and a change-data feed function (table_changes) that returns snapshot and row-level change records. Examples in the usage show attaching a DuckLake catalog (ATTACH 'ducklake:metadata.ducklake' AS my_ducklake (DATA_PATH 'file_path/')), issuing queries through the attached namespace, and retrieving historical snapshots or incremental changes.
Installation and development are command-line driven: the extension can be installed inside DuckDB with INSTALL ducklake; or FORCE INSTALL ducklake FROM core_nightly for nightly builds. Building from source requires initializing submodules, running make (with options for parallel builds), and launching the bundled duckdb shell. A comprehensive test harness is provided with commands to run unit tests, run subset patterns, and exercise different catalog backends (Postgres, SQLite) or features like deletion vectors. Contributions target the main branch, the codebase is MIT-licensed, and the project includes documentation, examples, and CI/test configuration to support development and integration.
Summary generated by AI from the linked article. hn.today is not affiliated with Hacker News or Y Combinator.
Moore's Law has slowed as physical and economic limits hinder semiconductor progress, leading to Eroom's Law, which describes declining productivity in drug discovery. Power constraints are a key factor in this slowdown across technological fields. (papers.ssrn.com)
Margaret Hamilton, who led the software development for the Apollo moon missions, died at age 90. She spent over two decades at MIT and was awarded the Presidential Medal of Freedom for her pioneering work in computer science and engineering. (news.mit.edu)
Emerging economies are rapidly adopting solar power, bypassing fossil fuels at a faster rate than Europe or the US. This shift is significantly transforming their energy landscapes and development trajectories. (dw.com)
Jonathan, a 194-year-old Aldabra giant tortoise, is the oldest land animal on Earth and has lived since before the Civil War. Scientists sequenced his genome to uncover genetic factors behind his extraordinary longevity, revealing unique gene variants related to aging pathways. (404media.co)
Rosalind Franklin was the first to understand the structure of DNA, contrary to some claims made by Watson. Her work was crucial in the discovery of DNA's double-helix structure. (link.springer.com)
OpenAI released a proof of the longstanding Unique Games Conjecture, a major breakthrough in mathematics. The complexity of the proofs has made AI assistance essential for understanding and verification. (scottaaronson.blog)
Today's best Hacker News stories, summarized and screenshotted, one email a day.