hrbrmstr's Daily Drop

  • 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

  • Drop #517 (2024-08-15): Thursdataday

    Three data-focused resources are featured in today’s Drop. “committed” offers lightweigth, remote monitoring of GitHub repository commits, “sq” enables query and manipulation across various structured data sources, and “CSVs Are Kinda Bad” proposes replacing CSV with DSV for improved data handling and parsing.

    hrbrmstr

  • Drop #514 (2024-08-09): DuckDB Vector Search

    Today’s Drop showcases DuckDB’s nascent vector search superpowers by walking through an example of how to generate embeddings for CISA KEV vulnerabilities, performing similarity search, and having Ollama guess good titles for clustered groups of KEV vulns. Tis def a code block-heavy post. #DuckDB #RStats

    hrbrmstr

  • Drop #510 (2024-08-02): SQLite Vector Search

    Today’s Drop covers the introduction of two SQLite extensions, sqlite-vec and sqlite-rembed, designed to facilitate vector search operations. These extensions provide fast and efficient vector search functionality, sponsored by the Mozilla Builders project, and enable easy integration of text embeddings from “remote” APIs (which included ollama/llamafile). With further development potential, these extensions aim to democratize…

    hrbrmstr