JOIN on more than just IDs
When we write a JOIN statement in SQL, it usually goes like this SELECT {columns} FROM parent LEFT JOIN child ON child.parent_id = parent.id Does it ever make sense for […]
How do you retrieve GraphQL schema
Just recording my amazement here. Suppose you have a GraphQL server. How do you ask it what’s the query schema? You would expect something like calling https://myserver/graphql/schema? Nah, that would […]
Hello, IT! Have you tried turning it on and off again? (Mobile Hotspot)
Yesterday, I had an Internet outage at home. The Internet was down for several hours. This is a perfect time to use Mobile hotspot. But alas, it wasn’t working. I […]
Python: modifying imported value
TL;DR: Python statement from module import obj creates a copy of the object in the importing scope. In other words, from module import obj is roughly equivalent to obj = __import__(‘module’).obj. […]
RabbitMQ: misleading error message on double [N]ack
Our RabbitMQ client written in Go failed with the following error message: rabbitmq | 2024-10-23 17:54:01.311544+00:00 [error] operation basic.ack caused a channel exception precondition_failed: unknown delivery tag {message_tag} Taken at […]
Python packages: what was deprecated when
Creation of Python packages underwent a few significant changes in the last 3-4 years. Here’s my note to self to remember what was changed/deprecated when: “Eggs” => “Wheel“ “Eggs” was […]
The Night of the Zombie Registrars
TL;DR Before transferring a new domain to a registrar, contact support, and make sure there are still live humans behind the robots. If there aren’t, RUN!!! UPDATE I’ve got my […]
Marshmallow-dataclass: eliminating nulls in the resulting JSON
When serializing a dataclass, by default marshmallow-dataclass emits nulls for all fields that have the value of None. This is not necessariy most of the time and pollutes the resulting […]
Turing Test Passed Successfully
Last night I was talking to something which could be a human or a robot, I could not tell. But that’s not necessarily a good thing: not only AI became […]
Python generator expression can be iterated only once
TL;DR Python generator expressions can be iterated over only once. I mentally mapped Python generator expressions to C# IEnumerables, which can be iterated over multiple times. In reality, Python generator […]