CORS, proxies, and the trailing slash issue
TL;DR On the client side, use trailing slash when requesting the “default” resource from a Flask app. Server: Client: Why it matters In Production If you make a request without […]
Apache mod_wsgi: demystifying WSGIApplicationGroup
Summary WSGIApplicationGroup is a name of the Python sub-interpreter. You don’t need sub-interpreters if you run mod_wsgi in daemon mode (i.e. with dedicated processes). Always set WSGIApplicationGroup to %{GLOBAL}. If […]
Chrome: thisisunsafe!
TL;DR Under certain circumstances you won’t be able to access an HTTPS site with invalid certificate from Chrome, unless you type a magic cheat code “thisisunsave“. I was debugging a […]
C++ regular_invocable and generative AI
I took interest in C++ random number generation because of the concept of regular_invocable. To my understanding, regular_invocable is C++’s notion of a “pure function”, or something really close to […]
C++ random number generation: mt19937 to ranlux24
It’s pretty old stuff, but still… Here’s how you typically generate a random number in C++: Let’s dissect it a little. On the one hand, “random_device” is a rather nebulous […]
Python: the land of abstract static methods
Summary Unlike many other languages, Python allows abstract static methods (see the reference). A class directly or indirectly deriving from abc.ABC cannot be instantiated, unless all its abstract methods are […]
Are Python strings UTF-8? What is the complexity of s[n]?
![Are Python strings UTF-8? What is the complexity of s[n]?](https://ikriv.com/blog/wp-content/uploads/2025/03/string_encoding_comparison.png)
TL;DR Internally CPython stores strings with fixed character size of 1, 2, or 4 bytes, depending on the string [PEP-393]. The indexing operator s[n] takes constant time. UTF-8 representation can […]
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 […]
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 […]
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 […]