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
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.
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…
Internationalization (i18n) is the work of making an app behave naturally across multiple languages and regions.
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…
pnpm is one of the package managers in the Node.js ecosystem. This article covers pnpm's origins, how it works, and how it differs from other managers — based on facts.
A shell is the interpreter that takes user input and hands it to the operating system. On the same OS we can pick from several shells, each with slightly different syntax and capabilities.
React 19 marks one of React's larger inflection points. Among its changes, React Compiler automates some of the memoization that used to be written by hand.
There are places where you want external behavior to run before or after an LLM agent's tool call. Auto-formatter execution, change watching, logging, policy validation, secret-leak blocking — that kind of work.
Everyone has felt lost after being told "read the official docs." Open them and the volume is the size of a book — there's no clear sense of where to start. Documentation is not material to read cover-to-cover like a bo…
A VPC (Virtual Private Cloud) is the virtual network where compute, databases, and load balancers live in AWS. If the shape of the VPC is not defined first, every decision inside it stays unstable.
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…
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.
There's no fixed answer to questions like "how many years to learn full-stack?" There are, however, frequently-cited visual references, frequent traps, and frequently-recommended orders. This article covers the source o…
"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…
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.
The flow of AI moving inside the browser progressed quickly between 2023 and 2025. It started with sidebar assistants, expanded into page summarization, translation, and drafting, and reached the place where agents hand…
Python's packaging and dependency management has seen many tools rise and fall over time. This article walks through them in chronological order and notes what each tool solved, and where it fell short — based on facts.
Around the time Cursor went GA in 2023, IDEs where "AI is the main interaction" multiplied fast. Various attempts have been made, either as VS Code forks or new editors. Capability evaluations change quickly with time,…
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.
The editor is where most of the typing and reading actually happens. This article covers the leading editors, the standard protocols (LSP, DAP), and EditorConfig.