SQLite — A Single-File DB for Local Apps
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.
21 views
Things I studied and noted down. For courses, see EDU.
AI/LLM topics — agents, prompts
HTML, CSS, JS, HTTP, URL basics
TypeScript, Java, Python, Rust
Data structures, Big-O, patterns
React, Next.js, Tauri, Tailwind
Spring, FastAPI, SQL
Claude Code · MCP · Context7 · Figma — overview of AI coding tools
Deployment options and decision criteria
PostgreSQL · Kafka · data strategy notes
Docker, Compose, Caddy, SSH
Windows vs Mac and other dev-environment notes
Cross-platform options compared (Tauri · Flutter · RN)
pnpm, uv, Gradle, Git, regex
KISS · DRY · YAGNI · naming — development philosophy
OAuth · JWT · security fundamentals
Testcontainers, Vitest, pytest
Searching, reading docs, debugging
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.
21 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,…
20 views
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…
13 views
The trend of running large language models directly on personal computers has taken hold rapidly since 2023. Where there used to be only cloud APIs, the combination of quantization formats like GGUF, inference runtimes…
13 views
Even with the same language and the same code, the basics like paths, line endings, shells, and permissions shift once the operating system changes. Linux falls on the macOS side of this split (both are Unix-flavored).
13 views
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…
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.
Trying to fix every problem in one big refactor often fails. A pattern of steady cleanup in small units tends to produce more stable results — a common observation. This article covers the Boy Scout Rule and the Strangl…
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.
A prompt is closer to the design of an input interface itself than just a string sent to an LLM. Message structure · reasoning patterns · sampling parameters · security all entangle at once.
.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.
After building a container image, the next question is where to run it. One option is to run docker directly on EC2; another is to delegate container lifecycle, health checks, rolling deploys, and service discovery to a…
This is a short orientation for someone opening a terminal for the first time. Each OS uses a different shell, so the same task uses slightly different commands. There is no need to memorize them — keep the table nearby…
Linters and formatters look similar but play different roles. This article covers the definition of each, the leading tools, and the trade-offs.
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).
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…
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…
Everything the browser shows on screen ultimately starts from a text document. The format of that text document is HTML. It is the first language a beginner meets, and the place we keep returning to no matter what other…
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…
Material Design is a design system Google announced in 2014. It went through a major revision in 2021 with Material 3 (M3).
Several books and studies discuss what "good names" are. This article organizes facts from Clean Code, Code Complete, Mythical Man-Month, and Cognitive Load theory.
Learning Git commands and learning how a team operates Git are two different things. This article covers branching strategies, commit message conventions, version notation, PR review, and hook tools.
TypeScript is a language that adds static types to JavaScript. This post lays out TypeScript's origins, how it works, and what strict: true actually turns on, all on a factual basis. We also touch on the gap left by run…
Choosing to write docs and comments in a native language other than English is a decision development teams in non-English-speaking regions often face. This article covers the convention of separating identifiers (Engli…
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…