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
PostgreSQL, MySQL, SQLite, SQL Server, Oracle — they all share similar core syntax. Learn it once and we keep using it for life.
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…
When programs exchange data with each other they need an agreed-upon notation. The four we meet most often in config files, API responses, CI workflows, and environment variables are JSON, YAML, TOML, and XML.
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…
Even for the same character, the bytes a computer stores depend on the era and environment. As a result, Korean text breaks or git diff fills with meaningless line changes.
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.
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…
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,…
PowerShell is Microsoft's shell and scripting language. It pipes .NET objects rather than text, which gives it a different grain from the bash family.
The shell most often encountered on Unix-flavored systems is bash. Its roots trace back to sh (Bourne shell).
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.
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).
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.
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.
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.
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.
From Tauri 2, Android and iOS became first-class citizens. Mobile apps have different distribution and monetization models from desktop.
Frontend bundlers have branched out rapidly over the past decade or so.
Forms are the part you meet most often in any app.
Material Design is a design system Google announced in 2014. It went through a major revision in 2021 with Material 3 (M3).