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

The desire to build the same app for iOS, Android, and the web from a single codebase has been around for a long time. The tools that emerged as answers picked different approaches in different eras. Some sit on top of…

There is a standard for expressing the shape of an HTTP API as a machine-readable document. That is the OpenAPI Specification (OAS). Once it is written well, doc pages, client SDKs, mocks, and contract tests all flow fr…

There is a model where code runs at the function level without provisioning a server. Compute wakes up when an event arrives, runs the function once, and disappears. AWS's seat for this is Lambda — it played a major rol…

.env files and environment variables show up early for newcomers. This article covers their origins, behavior, and the tools used for secrets management — based on facts.

The three areas of human writing (text in images), human speech (sound), and the reverse of synthesized voice run on different stacks but are often bundled together inside an app.

Caching static files, video, and API responses near users speeds up responses and reduces load on the origin server. The service that does this on globally distributed edges is a CDN (Content Delivery Network).

Solving similar problems repeatedly produces similar shapes. As object orientation went mainstream in the 1990s, a book came out that named and organized those repeated shapes, and patterns became the shared language of…

The word "agent" is used in several senses, which is a confusing situation. Script automation is called an agent, and so is the shape of an LLM calling tools.

What sets desktop and mobile apps apart from web apps is usually OS integration. Toast notifications, system trays, file dialogs, clipboard, autostart, global shortcuts, and deep links are frequent items in that list.

Python is a dynamic scripting language first released in 1991. This post covers Python's flow, the GIL, and how asyncio came about. We also touch on the difference between concurrency and parallelism, where ASGI and Fas…

The longer we use PostgreSQL, the more we run into a few concepts at least once: MVCC, indexes, EXPLAIN, isolation levels, VACUUM, partitioning.

As AI coding assistants multiplied, the convention "write the project rules and context in a single file" took root. Tools differ slightly in name and location, but the intent is similar.

When a project targets users on Windows, macOS, and Linux all at once, the choice of tool for automation scripts becomes a recurring question. There is no single right answer — environment constraints and team familiari…

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.

AWS network firewalling has two layers: the Security Group (SG) attached to instances, and the Network ACL (NACL) attached to subnets. The names are similar, but the operating models differ quite a bit.

The LLM market shifts fast. Closed-API and open-weight, English-centric and multilingual, cloud and self-hosted, models specialized for Korean — all sit alongside each other.

There's a saying that "a good question is half the answer." Faced with the same blocker, one person gets an answer in 5 minutes while another wanders for days. The difference usually sits in two places. First, asking be…

"What happens when you type google.com into the browser" is a classic interview question. Behind that short line, the OSI seven layers, IP, DNS, TCP, TLS, and HTTP appear in turn. This article gives beginners a one-time…

A skeleton flicker on a fast page is unpleasant. A long blank screen on a slow page is anxious. Both share the same root cause — fallback only sits at the route level.

When a service is in its early stage, it is often most reasonable to bring everything up on a single VPS with docker compose. Operational cognitive load is small and costs are predictable. How far this model goes, when…