Scroll to the bottom if you want the recipe and skip story telling. This is a story of software: You have a greenfield project. It s beautiful and fast. Then you add features. For five years. Then you realize your cold start times went from ~1 second to ~5.5 seconds. To be fair, a ton of [ ]
PII, short for Personally Identifiable Information, is often tricky to manage. Many countries have legislation around it. How much can you store, how can you store it, what is your procedure to wipe out all data about a given person? In some regards, the best way to deal with it is to view it as [ ]
Let s explain the situation with a concrete example. Given the following table structure: The two following queries yield the exact same result. To get there, they use different operators though, and, under the hood, it s not clear how different it gets. The first one, using the ANY operator, will loop through the categories array, and [ ]
tl;dr; Let s mock the sqlalchemy calls and look at the generated SQL statements. I ve read a couple of articles about testing when sqlalchemy is involved. None of them really did unit testing: they all ended up doing local integration tests by spinning up a DB of some sort. While that can work pretty well in [ ]
At Local Logic, we rely heavily on lambda functions. We currently monitor our environment with Sentry via their sdk and know that we could use, as an alternative, the sentry layer. As a good developer, I wondered what were the pros and cons. Obviously, one of them is: which option is the fastest? So, I [ ]
Long story short, you create a table with a geometry column that stores points with srid 4326 (read geographic lat/lng, or should I write lng/lat, coordinates). That should be interpreted as geography right? Not at all! To demonstrate, we ll need to use some GIS related functions, as using pg_typeof only yields unknown. Let s use the [ ]
Short story, I have an API that doesn t run on FastAPI, but I still use FastAPI to generate documentation in OpenAPI format. So I have models for endpoints and I want them to work with and without FastAPI, because in their pure version FastAPI is not deployed. (To make a long story short, installing FastAPI [ ]
I ve been wanting to publish my favorite Python tools annually for a long time now. It s practical for a lot of people, and it allows to see how they evolve over time and the projects I contribute to. So here s the first edition of this list. Development tools poetry Poetry is my package manager of [ ]
The blog you are currently on used to be hosted on some Virtual Private Server. My hosting provider decided to quit the business and I had to leave. He kindly suggested that I look at AWS Lightsail as a migration option. I did, and this is where this blog is now hosted. This blog is [ ]
A handy code sample that I keep forgetting about.