SQLite — A Single-File DB for Local Apps
6 min
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.
7 views
Things I studied and noted down. For courses, see EDU.
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.
7 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…
5 views
A monorepo keeps the source for many projects in a single version-controlled repository. This article covers what a monorepo is, its history, how far a lightweight setup like pnpm workspaces can take us, and what full-s…
5 views
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.
4 views
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.
4 views
.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.
uv is the most recent entrant among Python package and project managers. This article covers uv's origins, role, and relationship to existing tools — based on facts.
A monorepo keeps the source for many projects in a single version-controlled repository. This article covers what a monorepo is, its history, how far a lightweight setup like pnpm workspaces can take us, and what full-s…
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.
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…
"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…
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…
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…
If HTML is the skeleton and CSS is the look, JavaScript is the behavior. Pressing a button to open a modal, validating input, fetching data from the server and rendering it — all of these belong to JS. This article cove…
If HTML describes what something is, CSS describes how it looks and how it is arranged. Color, size, spacing, alignment, responsiveness — most of the visual decisions on screen belong to CSS. This article covers CSS's o…
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…