hrbrmstr's Daily Drop

  • Drop #567 (2024-12-06): In Defense Of…

    Today’s Drop explores three distinct topics centered around safety. We take a deep look into DuckDB’s sophisticated query optimization capabilities, examine a new security tool for GitHub Actions workflows, and review the Electronic Frontier Foundation’s comprehensive guide to surveillance self-defense. Each section provides practical insights and actionable guidance for their respective domains.

    hrbrmstr

  • Drop #563 (2024-12-02): Awash In Advents

    December features various “technical” advent calendars, such as Advent of Code and Advent of Rust, offering daily programming challenges to enhance skills. Today’s Drop showcases a bonkers number of code, “no-code”, and absolutely no-code challenges to keep you occupied throughout December.

    hrbrmstr

  • Bonus Drop #69 (2024-11-24): Blue Skies, Four Squares, And Federated Blogs

    Today’s Bonus Drop covers spatial data visualization using Foursquare’s open-source POI dataset and decentralized blogging via WhiteWind’s platform built on AT Protocol. It also covers setting up an ATproto Personal Data Server (PDS).

    hrbrmstr

  • Drop #560 (2024-11-22): Quack • Post • Code

    Today’s Drop features DuckDB’s API integration with Hono.js for SQL queries, turning RSS feeds into automated Bluesky posts, and resources for learning Deno 2.x.

    hrbrmstr

  • Bonus Drop #68 (2024-11-17): Drinking From A More Civilized Firehose

    Bluesky introduced “Starter Packs” to help users build their feeds, accumulating nearly 30,000 packs. The Jetstream service, replacing the more complex firehose, simplifies data streaming, using JSON for easier access. Today’s Bonus Drop discusses leveraging Deno, Red Panda, and DuckDB for effectively managing and processing Starter Pack events via the Jetstream.

    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 #543 (2024-10-20): Dev-Mode Engage

    Today’s Drop discusses the introduction of JavaScript Import Maps, allowing cleaner alias management for module imports even in vanilla JS + CDN projects, thus enhancing code cleanliness and dependency management. It also covers a microservice built with Deno to convert PDFs to text, and highlights the “pancake SQL pattern” for optimizing SQL queries using window…

    hrbrmstr

  • Drop #537 (2024-09-30): It’s About Time

    Today’s Drop covers three resources centered on time: “Time as a Grid,” a visual representation of time using grids; Greptime, a database for managing time series data; and Primitive, an image processing tool that uses geometric shapes.

    hrbrmstr

  • Drop #519 (2024-08-22): Cache Me If You Can

    Today’s Drop discusses creating a lightweight internet research setup by integrating SearXNG, Jina, and a small Go program to provide a caching layer for search results. SearXNG is a self-hostable metasearch engine, while Jina’s Reader endpoint converts URLs to Markdown. Through a combined CLI, we can preview search results in the terminal and access cached…

    hrbrmstr