hrbrmstr's Daily Drop

  • 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

  • Bonus Drop #70 (2024-12-14): Knowledge Drop

    Today’s Bonus [Knowledge] Drop takes you on my journey to add CIDR handling to DuckDB’s INET extension, which stores IPv4 and IPv6 addresses. It outlines the process of developing a function to expand CIDR notation into a list of IP addresses, detailing technical steps and functions involved.

    hrbrmstr

  • Bonus Drop #68 (2024-12-08): All Strings ATTACHed (CLI Version)

    Today’s Bonus Drop discusses GoReleaser, an open-source tool designed to simplify cross-platform releases of Go projects, supporting various formats and integrations. It also introduces a project for a CLI version of the DuckDB Drop viewer.

    hrbrmstr