hrbrmstr's Daily Drop

  • Bonus Drop #95 (2025-08-24): Vibe-less Coding; Vibe-ful Checking

    The weekend Bonus Drop emphasizes the importance of security for vibe or vibe-less personal web apps, highlighting key strategies such as SSRF protection, rate limiting, robust CSRF tokens, & more. It also provides a plethora of prompts to help you infuse security into your vibe-coded creations.

    hrbrmstr

  • Drop #675 (2025-07-03): drop –upgrade

    Today’s Drop features three kind-of-major updates to some froody FOSS. Deno 2.4 enhances developer experience with features like raw imports, OpenTelemetry integration, and improved Node.js compatibility; SQLite marks its 25th anniversary with performance upgrades like the sqlite3_rsync feature for faster sync; and, Ligolo-ng v0.8 introduces a web interface for collaborative tunneling, supporting multiple users effectively.

    hrbrmstr

  • Drop #672 (2025-06-27): If It Walks Like A…

    We have another 🦆-billed Drop today, featuring: DuckPlot — an open-source JavaScript library for generating charts from DuckDB with automatic SQL generation; The mcp-visualization-duckdb package, which allows users to create visualizations through natural language queries, bypassing SQL; & DuckDB-QuickJS which integrates a JavaScript engine for flexible data processing within SQL, enhancing DuckDB’s analytical capabilities.

    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 #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