hrbrmstr's Daily Drop

  • Drop #705 (2025-09-05): If It Walks Like A 🦆…

    Today’s 🦆 Drop showcases DuckDB’s capabilities for processing NGINX logs and integrating with Observable Notebooks 2.0 for interactive SQL querying. It also introduces the Textplot extension for real-time visualizations in #DuckDB SQL queries.

    hrbrmstr

  • Drop #669 (2025-06-23): Monday Morning (Barely) Grab Bag

    The Monday Drop discusses 3 main topics: a Rube Goldberg-inspired data pipeline to archive X posts into #DuckDB, the #RStats package {fplot} for automating distribution plot creation in R, and an article from CSS-Tricks on advanced CSS color techniques, detailing color spaces and models for modern web development.

    hrbrmstr

  • Bonus Drop #86 (2025-06-15): I Think You May Be Projecting

    The Weekend Bonus Drop covers two data engineering projects utilizing #DuckDB. The first project improves rock-climbing trip planning by integrating climbing routes with precise weather forecasts. The second project organizes Garmin activity data into a clean database. Both exemplify real-world engineering challenges for personal projects, emphasizing practical problem-solving and hands-on learning in data management.

    hrbrmstr

  • Drop #640 (2025-04-17): Twisted Topics Thursday

    Today’s Drop discusses MotherDuck’s #DuckDB Model Context Protocol server with a walk through a look at my sensor network data. It further highlights the rise of automated bots, which now constitute 51% of web traffic, and, lastly, emphasizes the privacy concerns surrounding modern web browsers’ telemetry practices.

    hrbrmstr

  • Bonus Drop #82 (2025-04-12): Quick Hits

    The weekend Bonus Drop contains 3 “quick hits”. One highlights Lit web components’ advantages, another showcases FLOCKMTL’s integration of LLMs into #DuckDB SQL workflows, and features Granary’s role as a universal translator for social web data.

    hrbrmstr

  • Bonus Drop #67 (2024-11-09): If It 🚁 Like A 🦆

    Today’s Bonus Drop covers 3 #DuckDB extensions.GSheets allows seamless data interaction with Google Sheets via SQL. MyDuck Server bridges MySQL and DuckDB for improved analytics. And,, the DuckDB HTTP Client extension facilitates direct HTTP requests in queries, enhancing data processing capabilities through API integration. (I’ve got an NVD CVE API example for the last one).

    hrbrmstr

  • Drop #544 (2024-10-21): If It Walks Like A 🦆

    Today’s Drop covers the DuckDB HTTP Server Extension, a project that transforms DuckDB instances into HTTP OLAP API servers. Additionally, it covers “DuckDB in Action,” a practical DuckDB guide, and introduces “masto.sh,” a tool for backing up Mastodon posts in #DuckDB.

    hrbrmstr

  • Drop #423 (2024-02-19): If It Walks Like A…

    In this content, the author discusses three main topics: SQL Workbench with DuckDB-WASM, the Tabulator JavaScript library, and DuckDB Remote Parquet. The SQL Workbench section focuses on building a SQL workbench with DuckDB-WASM, while the Tabulator section introduces the features and versatility of the Tabulator library. The content ends with a link to explore further…

    hrbrmstr