database

• Why CTE is non-optional, but a Requirement in Financial Systems

  14 Oct 2025 — You might think "CTE" (Common Table Expression) is just a syntactic sql sugar, a nice-to-have feature for readability or organizing subqueries. In most domains, you might be right.

• Why UUIDs are bad, and why you should consider the alternative

  5 Mar 2024 — Universally Unique Identifier, or UUID for short, is widely used as a unique identifier across systems. Their appeal lies in their simplicity and universality. But they come with costs (and they are huge).