Johni Douglas Marangon·4d agoDatabase Sharding Explained: A Hands-On Guide with Python, FastAPI, and SQLiteLearn how sharding works, how to pick a shard key, and build a working sharded to-do API from scratch
Johni Douglas Marangon·6d agoCharge Once, Retry Forever: Idempotency Keys in Python with FastAPI and RedisA hands-on guide to making your POST endpoints safe to retry (within a time window you choose)
Johni Douglas Marangon·Nov 9SQL Sessions: Common Table Expressions, from Basics to RecursionI was working on a project where we needed to build non-trivial SQL queries involving nested subqueries, complex joins between tables, and…
Johni Douglas Marangon·Nov 6Solving the N+1 Query Problem in Drizzle ORM: A Practical GuideThe N+1 query problem is one of the most common performance killers in database-driven applications. Your code looks clean, your tests…
Johni Douglas Marangon·Nov 6Testing GitHub Actions Locally with act: Stop Committing Just to DebugA few weeks ago, I came across a tool that allows you to run GitHub Actions locally, making it easier to develop and test workflows before…
Johni Douglas Marangon·Nov 6Building Real CLIs with Python’s argparse: From a Single Flag to SubcommandsIn Python, we have some good libraries for building command-line interfaces. For example:A response icon1A response icon1
Johni Douglas Marangon·Nov 4Using NGINX as an API GatewayAPI Gateway is one of the most common concepts in system design, especially when working with complex architectures involving multiple…
Johni Douglas Marangon·Nov 3How to Solve the N+1 Query Problem in DjangoA few weeks after my team and I set up Sentry monitoring for a Python API service, Sentry flagged several endpoints making repeated…A response icon2A response icon2
Johni Douglas Marangon·Nov 2The Simplest Way to Build a REST API in .NET — Minimal APIJava and .NET are well-known platforms for building complete REST API projects, offering a rich set of built-in features (authorization…A response icon1A response icon1
Johni Douglas Marangon·Oct 28Getting a list of available proxies to use with Selenium and Requests in PythonRecently, I was part of a project where my team and I needed to run multiple crawlers on the same websites. We faced several challenges…