hrbrmstr's Daily Drop

  • Drop #658 (2025-06-02): The [Duck] Lake House

    Today’s Drop has a primer on data lakes and features DuckLake, which introduces a novel lakehouse architecture from the DuckDB folks that separates data management into three layers: storage, metadata, and computation. Using a database for metadata enhances performance and consistency, addressing issues present in traditional lakehouses. This design supports ACID transactions, schema evolution, and…

    hrbrmstr

  • Drop #656 (2025-05-26): A Different Kind Of Memor[y|ial] Day

    Today’s Drop emerges from a brutal travel/work week for a Memor[y|ial] focused issue that takes a peek at the DuckDB 1.3.0 release, which enhances data analysis with external file caching, improving performance by 75%, and introduces recursive query functionality for complex data structures. It further showcases jOOQ enables type-safe SQL queries in Java/Kotlin and features…

    hrbrmstr

  • Bonus Drop #81 (2025-04-06): Bonus²

    This weekend Bonus Drop discusses DuckDB’s integration with dbt for effective data transformation, enhancing workflows with features like spatial functions and reverse ETL. It also highlights shell command efficiency improvement tools and introduces Ollamacommit for generating Git commit messages locally, improving privacy and workflow for developers.

    hrbrmstr

  • Drop #626 (2025-03-24): Monday Morning Grab Bag

    Today’s Drop discusses Djot, a new markup language enhancing Markdown’s capabilities, and Bean CMS, a minimal content management system built on redbean. It also outlines a “Clean Slate Protocol” to remove ⭐️’d GH repos.

    hrbrmstr

  • Drop #621 (2025-03-14): If It Walks Like A…

    Today’s Drop discusses DuckDB version 1.2.1, which features a web-based UI for easier SQL query management and data exploration. It highlights the Netquack extension for URL analysis in SQL and introduces the PSQL extension, enabling a pipe operator for clearer, sequential data transformations.

    hrbrmstr

  • Drop #613 (2025-02-27): Let’s Get Visual

    Today’s Drop sports a timeline visualizing the evolution of Unix shells, the rDNS Map project mapping the IPv4 space using ClickHouse, and a digital recreation of Moses Harris’ 1766 color theory work.

    hrbrmstr

  • Drop #605 (2025-02-14): Free-For-All Friday

    Today’s Drop sports Cockpit, a user-friendly web-based server management tool; an in-depth look at HTML whitespace challenges and solutions; and the latest DuckDB 1.2.0 release featuring improved performance, enhanced CSV/Parquet handling, and new SQL features.

    hrbrmstr

  • Drop #602 (2025-02-03): Monday Morning Grab Bag

    Today’s missed flight-enabled Drop talks Kata Containers, a secure container runtime using lightweight VMs for enhanced workload isolation; LosslessCut, a cross-platform, FFmpeg-based video editing tool that allows lossless trimming and manipulation of media files; and a CMU seminar series addressing SQL optimization and potential alternatives.

    hrbrmstr

  • Drop #590 (2025-01-13): A SQL Trio

    Today’s Drop looks at three database tools: libSQL, Beekeeper Studio, and Outerbase Studio. libSQL is an SQLite fork enabling network operations. Beekeeper is a freemium SQL editor w/multiple db support. Outerbase is a browser-based management tool w/user-friendly features for various SQL databases, enhancing database interaction and management.

    hrbrmstr

  • Drop #583 (2025-01-01): Wrapping Day

    The inaugural Drop of 2025 takes a look back at the Drops of 2024, my 2025+ daily drivers, and covers a new-to-me tool: Mise.

    hrbrmstr