The Curious Engineer

All blogs / Python

rand[om]

ricardoanderegg.com

Hello there! I’m Ricardo, and here are some facts about me and things I’ve done/do: Medical doctor Self-taught software engineer Working on data engineering and machine learning projects …

PythonAI / MLDatabasesDev tools / editors / IDEsJavaScript / TypeScript

’19’20’21’22’23’24’25’26
Posts
62 from 22 Jul 2019 to 27 Jan 2026
Posting
now and then (5 in the last year)
Kind
personal blog
Feed
https://ricardoanderegg.com/atom.xml

2026 4

  1. Two-step structured outputs for LLMs
  2. Software Willy Wonka
  3. Fixing Claude Code's broken file search
  4. Getting better at coding with LLMs

2025 7

  1. Preact without a build step, including routing and signals
  2. Taming your shell for LLMs
  3. Stop reaching for file appends. Create new files instead.
  4. Simple strategy to run Ansible tasks in parallel
  5. Why I use executable scripts instead of shell aliases
  6. Exploiting Cursor to write better code
  7. ZIP as a bundle format

2024 7

  1. From HTML template strings to elements
  2. Handling keyboard shortcuts in JavaScript
  3. Query a list of dictionaries with DuckDB
  4. Cron jobs inside your web app
  5. My take on Web Components
  6. DuckDB as a vector database
  7. Building HTML components from Python functions

2023 16

  1. Python profiling and timing utils
  2. Replacing FFI with a CLI
  3. macOS port 5000 not working
  4. Named parameters in shell scripts and Makefiles
  5. Makefile tricks for Python projects
  6. Using IPython for timing and profiling
  7. Validate Python dataclass types
  8. Using mmap to share data between processes
  9. Running regexes on memory-mapped files
  10. Moving from Apple Notes to Obsidian
  11. This is now a stream of my thoughts
  12. Using Apple Notes as a CMS
  13. Using SQLite for logging and ad-hoc profiling
  14. Python automation utils
  15. Stream a CSV from S3 to a parquet file
  16. Use a subprocess instead of a dependency

2022 7

  1. Passing arrays as parameters to SQLite
  2. Musings about automation
  3. The unreasonable developer experience of SQLite
  4. Building a remote SQLite explorer
  5. Peeking and backtracking Python generators
  6. Extending SQLite with Rust
  7. Python, SQLite, and thread safety

2021 8

  1. The best code is easy code
  2. Heroku-style deployments with Docker and git tags
  3. Bloom filters explained in an image
  4. Understanding Bloom Filters by building one
  5. Hash functions explained in an image
  6. Multiple, shared, in-memory SQLite databases in Python
  7. Vanishing feedback button with FastAPI and hyperscript
  8. Managing Python environments with mamba and pip-tools

2020 9

  1. Single file applications
  2. Notes on Simple Made Easy
  3. Short posts
  4. Connect to remote docker host via SSH.
  5. Run your containers as non-root
  6. Put your bash code in functions
  7. Conda management
  8. Education before innovation
  9. Fixing a bug in the Haskell installer

2019 4

  1. Divide, Search, Abstract
  2. Language identification with fastText
  3. Linking notebooks
  4. Formatting jupyter notebooks with black