Given: There’s a CI system that automatically builds docker images from your VCS (e.g. git), we use self-hosted gitlab.Goal: Both initial and subsequent automated deployments to different environments (staging and production). Rejected ApproachesMost existing blog articles and howtos for this use case, specifically in the context of gitlab, tend to be relatively simple, relatively easy, […]

No.Not satisfied? Fine, fine. I’ll write a longer answer.Let’s talk about what we’re talking about. JWT stands for JSON Web Tokens, a reasonably well defined standard for authenticated tokens. Specifically they have a header with format information, a payload, and a signature or message authentication code. The core idea is that whoever has the corresponding […]

[This is a repost of a thread of mine from a dead social media platform. The original posting date was May 24th, 2022. I have not added new content.]Is there some scientific literature/scenario planning on the End of Bitcoin? With the next two halvings mining income will shift significantly from block reward to transaction fees. […]

One of the lesser known features of modern SQL are so-called “Common Table Expressions” (CTE) or “WITH queries”. I’ll explain the mental model that helped me make sense of them, and how to use them to execute recursive queries. Afterwards I’ll show how to apply these techniques in Django.Syntactically a CTE consists of one or […]