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.
18 views
Notes
Things I studied and noted down. For courses, see EDU.
Categories
AI & LLM
9AI/LLM topics — agents, prompts
Web Fundamentals
7HTML, CSS, JS, HTTP, URL basics
Languages
4TypeScript, Java, Python, Rust
Programming
4Data structures, Big-O, patterns
Frontend
18React, Next.js, Tauri, Tailwind
Backend
19Spring, FastAPI, SQL
Agent tooling
15Claude Code · MCP · Context7 · Figma — overview of AI coding tools
Cloud
22Deployment options and decision criteria
Data
20PostgreSQL · Kafka · data strategy notes
Infra
10Docker, Compose, Caddy, SSH
Environment
11Windows vs Mac and other dev-environment notes
Mobile
4Cross-platform options compared (Tauri · Flutter · RN)
Dev tools
12pnpm, uv, Gradle, Git, regex
Philosophy
10KISS · DRY · YAGNI · naming — development philosophy
Security concepts
9OAuth · JWT · security fundamentals
Quality / Tests
11Testcontainers, Vitest, pytest
Learning
6Searching, reading docs, debugging
Popular this week
cmd.exe and batch files
5 mincmd.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
WSL2 — Linux on top of Windows
6 minDeveloping 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
KISS · DRY · YAGNI
4 minThese 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
Embeddings Deep — Models · Dimensions · Benchmarks · Cache
6 minAn 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
Notes
Forms — react-hook-form and zod
6 minForms are the part you meet most often in any app.
CSS — Look and Layout
5 minIf 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…
PostgreSQL First
5 minChoosing a data store is often a burden. NoSQL, distributed SQL, graph DBs, time-series DBs all line up. Yet for many projects, PostgreSQL alone is enough for a long time at the start.
When Folders Become Contracts
5 minA folder structure is not just file classification — it can become a device that promises dependency direction and the scope of change between code modules. This article covers facts about Feature-Sliced Design, Domain-…
i18n — Korean as the First Priority
6 minInternationalization (i18n) is the work of making an app behave naturally across multiple languages and regions.
uv — Python package manager
5 minuv 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.
Three-Layer Cache
5 minCache rarely sits in only one place. It usually stacks across several layers. Closer to the client is faster; closer to the DB is more accurate.
HTML — The Skeleton of a Web Page
5 minEverything 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…
Docker Compose Patterns
6 minWhen running several containers on a single host (web, DB, cache, queue) Compose is the lightest path. One YAML file ties together dependencies, networks, volumes, and healthchecks. Not being a full orchestrator is both…
JavaScript Basics — The Browser's Dynamic Language
5 minIf 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…
Input Validation — Trim at the Boundary
6 minUntrusted input arrives at the edges of the system. HTTP body, query, headers, environment variables, external API responses, file contents. Letting that input flow into the inner code blurs both type and meaning, and s…
Prompt Design — Message Roles · CoT · ReAct · Sampling · Injection
6 minA 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.
SQL Basics
6 minPostgreSQL, MySQL, SQLite, SQL Server, Oracle — they all share similar core syntax. Learn it once and we keep using it for life.
RAG and Search — Chunking · Embedding · Reranking · Hybrid
6 minRAG (Retrieval-Augmented Generation) is an approach to supplement an LLM's limited training cutoff and memory limits with external knowledge. By separating retrieval and generation, you can handle new material without r…
The Many Roles of Redis
5 minRedis started as an in-memory key-value store, but today it covers cache, sessions, queues, ranking, distributed locks, and pub/sub all at once.
VPC and Subnets
5 minA 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.
Data Structures — Containers for Data
7 minAfter variables and functions, data structures are the next topic you meet most often when starting out in programming. The simplicity and speed of code shifts dramatically depending on which container you choose for th…
Minimal observability — logs, metrics, traces
5 minThe word "observability" tends to suggest rolling out a full stack, but introducing a full stack from a small system makes operational cost outpace value pretty quickly.
Spring Multi-Module (Gradle)
5 minWhen several Spring applications live in a single repository, we have to settle the location of shared code, the build unit, and the direction of dependencies. Gradle's multi-project build is the standard tool for handl…
Git Submodule · Subtree · LFS — repos inside repos
7 minWhen a repo needs to carry another repo's code, or when large binary files have to live inside a repo, the options that come to mind are Submodule, Subtree, Sparse Checkout, and Git LFS. Each has different strengths and…