Online SQL Formatter
https://codebeautify.org/sqlformatter all the way. It is a 3rd of a 4th link on Google, but it provides the best formatting and the best experience. You paste your ugly formatted SQL […]
Hacker’s diary
ARG in docker actually creates an environment variable, at build time
A few days ago I discovered (with the help from my colleagues) that ARG instruction in Docker creates a true environment variable that is available inside the commands invoked at […]
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 […]
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 […]
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 […]
Python: serializing JSON into dataclasses with validation
TL;DR use marshmallow-dataclass. Serializing JSON into dataclasses with validation proved to be unexpectedly difficult. By “validation” here I mean type checking (this must be a valid integer), range checking (this […]