Notes

SQLite is an embedded database that holds a SQL database in a single file. It is one of the most frequently chosen options for local storage in desktop and mobile apps.

18 views

cmd.exe is the command processor on Windows NT-family systems. It debuted in 1993 with Windows NT 3.1 and ships with every Windows release. Since PowerShell arrived, cmd's role as an entry point for new code has shrunk,…

15 views

Developing on Windows often runs into "Linux-only tools" — Docker, certain CLIs, shell scripts, compilation environments. WSL2 raises a real Linux environment inside the same machine without dual-booting or a heavyweigh…

13 views

These three acronyms are often cited together as software design principles. Their origins and meanings differ slightly, and some interpretations even conflict. This article covers the origin, intent, and frequently con…

12 views

An embedding is the result of mapping text (or images · code) to fixed-dimensional real-valued vectors. On top of the assumption that semantically close items sit close in the vector space, search · clustering · classif…

12 views

Operating a relational DB directly is an area heavy with backup, recovery, HA, tuning, and version upgrades. RDS (Relational Database Service) takes a large share of those operational responsibilities off the user's han…

GitHub Actions puts CI/CD inside the GitHub repository. It went into beta in 2018 and moved to GA in 2019.

The single line in the browser's address bar has a more precise structure than it looks. It's a small grammar that expresses how to access which resource. This article covers each part of a URL, encoding rules, the diff…

EC2 (Elastic Compute Cloud) is the first compute service AWS released, and it popularized the cloud "virtual machine" abstraction. As managed services have grown, the share of direct usage has diversified, but EC2 remai…

Gradle is one of the most widely used build tools in the JVM ecosystem. This article covers Gradle's origins, how it works, and how it differs from Maven.

AWS effectively defined the cloud services market. The service catalog tops 200, but at the category level it boils down to a handful of larger groupings.

Aside from in-IDE assistants, AI coding tools in terminal CLI form are growing on their own track. The motivations are friendliness with shells, SSH, and CI; script automation; and a lighter interface.

It is no exaggeration to say that half of the first few months of frontend work is learning how to use DevTools. Logging values to the console, inspecting network requests, tweaking styles on the fly, simulating mobile…

The idea of building desktop apps with HTML/CSS/JS is not new. The two largest branches are Electron and Tauri, and although they look similar, their architectures are quite different.

A container is an isolated user space that runs on top of the OS, letting the same application run anywhere with the same shape. Docker is the decisive moment that bundled containers into a standard tool and brought the…

DNS, which resolves domain names to IPs, is one of the oldest pieces of internet infrastructure. AWS's managed DNS service is Route 53 — named after the standard DNS port (53).

PowerShell is Microsoft's shell and scripting language. It pipes .NET objects rather than text, which gives it a different grain from the bash family.

The shell most often encountered on Unix-flavored systems is bash. Its roots trace back to sh (Bourne shell).

FastAPI moved into the Python web framework mainstream in a relatively short time. Behind that quick rise is a design that ties type hints, Pydantic, and async into a single coherent sentence.

Material Design is a design system Google announced in 2014. It went through a major revision in 2021 with Material 3 (M3).

SSOT (Single Source of Truth) started as a data governance term and has expanded into a principle for code, documentation, and schema operations. This article covers the origin, areas of application, and trade-offs.

Collecting public web data touches not only technology but ethics and law. Hitting too often burdens the target server, and skipping the terms of service can spill into legal trouble.

To deliver messages on mobile or web while the app is closed, the push channels provided by the OS or the browser must be traversed. iOS has APNs, Android has FCM, and the web has the Web Push standard.

The gap between a strong developer and a beginner is closer to "finds what they don't know quickly" than "knows a lot." Search is not a supplement to memorization; it's a separate skill. This article covers how to craft…

Most of AWS lives in magical data centers across the internet, charging money to do work. To verify on a developer machine, three costs apply daily: (1) creating a PoC account on real AWS, (2) paying somewhere, (3) stal…