pythonstrup
Notes from a journey of growing one step at a time
A place where I write down what I learn and the problems I run into while building things — the daily questions, how I solved them, and notes worth revisiting.
Start here
A short list I keep by hand for a first visit.
- LLM API Gateway: OpenRouter, LiteLLM, and Cloudflare
- Solving a Concurrency Problem with a Single UPDATE
- Operating a Notification System with BullMQ, Part 1: What Is BullMQ?
- Stopping Concurrent Double Bookings - PostgreSQL EXCLUDE Constraints
- Passwordless DB Access and Least Privilege - IRSA, rds_iam, ALTER DEFAULT PRIVILEGES
Topics
Series already on the site, grouped as places to start.
LLM gateway and proxy
How a gateway gathers repeated provider calls into one layer, what a LiteLLM proxy shows once calls go through it, and when prompt caching pays off.
3 postsReading path
Concurrency control and database locking
The series runs from a single UPDATE through pessimistic locks, Lettuce distributed locks, AOP, and a ticketing system.
6 postsStart with part 1
Notifications with BullMQ
The series on running notification delivery with BullMQ: what the queue takes on, rate limits, where delivery history lives and how to read it, and group sends that do not keep order.
5 postsStart with part 1
Parquet and S3
A walk through the inside of a Parquet file, and an experiment querying JSONL on S3 without Parquet.
2 postsStart with part 1
Recent posts
View all postsRecent notes
Notes indexNotes RSS- A draft is not written from a blank page but assembled by translating notes
- A note-taking habit is built by the environment, not by willpower
- Abstraction arises naturally while searching for a solution
- Deep understanding comes from asking the questions the author did not ask
- Feedback should come more often and be accepted more readily