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

Beyond using LLMs as one-shot calls, more tools bundle multi-step automation and integration flows. The strands vary — connecting nodes without writing code (GUI), or self-hosting to keep operational control.

Markdown is a lightweight markup language for writing structured documents while keeping the source readable as plain text. It shows up everywhere: dev docs, READMEs, issues, blogs, notes.

Tauri is a framework for building desktop and mobile apps, with a core runtime written in Rust. This post covers Rust's origins and core concepts, and "why Rust in particular", on a factual basis. It is not a deep dive…

Whether a subnet is "public" or "private" is decided by routing, not by labels. Once we understand how Internet Gateway (IGW), NAT Gateway, route tables, and VPC endpoints combine, the meaning of subnet design becomes c…

What does the browser ask the server for, and how does the server reply? Almost everything on the web sits on top of that simple question. This article covers HTTP's origins, methods and status codes, headers, REST's or…

This article is aimed at people who are about to begin programming, mapping out the areas commonly encountered early in learning, on a fact basis. A guide for when there is no clear sense of where to start.

Distributing traffic across backends, removing dead servers, and managing certificates from a single place are common needs across nearly every web service. AWS's seat for this is ELB (Elastic Load Balancing) — four fla…

The single phrase "deploy on AWS" hides choices that span very different abstraction levels. From managing one EC2 box directly all the way to function-level hosting like Lambda. Including other clouds and PaaS, the pic…

When writing an HTTP API, the code around the handler body (auth, validation, logging, error translation, rate limiting) often outweighs the body itself. Where and how this cross-cutting code lives decides consistency a…

> The multi-emulator paths and commands below are an architectural example, not a claim about a particular repository. Select only the providers and cost envelope you actually need.

S3 (Simple Storage Service) was the first AWS service to reach GA, in 2006, and it popularized the object storage category. Neither file system nor block storage, the model of "an infinitely large bucket accessed by key…

Separate unit, integration, browser, and production smoke checks, then assign Vitest, pytest, Cypress, and Playwright without duplicating responsibilities.

When a large task is handed to one LLM instance in a single shot, the context fills quickly and responsibility blurs. Subagents are the pattern of slicing a task into smaller units and delegating each to a separate mode…

iOS app builds go through similar steps to Android (compile → bundle resources → sign → package), but the tools, distribution channels, and policies look quite different. The biggest difference is that macOS and the App…

A repository hosts documents for two kinds of readers: humans, and code-assistant agents (LLM-based IDE assistants and AI coders). This article covers the standards and conventions for both.

HTTP is fundamentally a one-request-then-one-response model. It is hard for the server to speak to the client first. In places like chat, notifications, and live updates, the server must be able to push data actively.

Kafka is often called a "queue," but more precisely it is a distributed commit log. Its strengths show beyond queues. At the same time, it is overkill for a simple work queue.

Periodic tasks show up in any backend. Nightly aggregates, external data collection, expired-token cleanup. At small scale, cron or an in-process scheduler is enough; at larger scale, distributed queues and workers appe…

Flutter is a UI toolkit from Google that targets mobile, web, and desktop from a single codebase. Its own rendering engine, the Dart language, and the widget tree as an expression model are the core. This post covers Fl…

The trend of combining large language model responses with external knowledge has settled under the name RAG (Retrieval-Augmented Generation). At its core sits vector similarity search, and PostgreSQL's pgvector extensi…