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.
21 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
4 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,…
20 views
iOS App Build — Xcode · Signing · TestFlight
6 miniOS 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
Local LLM — LM Studio · llama.cpp · Ollama · vLLM
6 minThe 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
Windows vs macOS dev environment
5 minEven 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
Notes
Trade-offs, not "best practice"
5 minThe phrase "best practice" is often applied without question, but a single answer that fits every environment equally is rare. This article covers facts from three classics (CAP, PACELC, Conway's Law) that show context…
Cross-platform Mobile — Comparing the Candidates
6 minThe desire to build the same app for iOS, Android, and the web from a single codebase has been around for a long time. The tools that emerged as answers picked different approaches in different eras. Some sit on top of…
JavaScript Basics — The Browser's Dynamic Language
4 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…
Browser DevTools — The First Tool for Debugging
6 minIt 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…
Android App Build — APK · AAB · Signing
5 minBuilding an Android app, regardless of the tool, eventually goes through similar steps. Compile sources, bundle resources, convert to DEX, and sign. The result is an APK or an AAB. This post walks through that flow, the…
Vitest and the grain of testing
7 minVitest is a testing framework that grew out of the Vite ecosystem. It keeps a similar grain to Jest while handling ESM, TypeScript, and watch mode more lightly.
SQL as the single source of truth
7 minWhere should the schema's truth live? ORM models, migration files, DDL SQL — there are several candidates. We compare the cumulative-migration model with the single-SQL-file + CREATE IF NOT EXISTS model.
Docker Basics
6 minA container is an isolated user space that runs on top of the OS, letting the same application run anywhere with the same shape. Docker is the decisive moment that bundled containers into a standard tool and brought the…
uv — Python package manager
4 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.
Rust — why Tauri picked Rust
6 minTauri is a framework for building desktop and mobile apps, with a core runtime written in Rust. This post covers Rust's origins and core concepts, and "why Rust in particular", on a factual basis. It is not a deep dive…
Cross-platform scripts
4 minWhen 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…
SQL Basics
4 minPostgreSQL, MySQL, SQLite, SQL Server, Oracle — they all share similar core syntax. Learn it once and we keep using it for life.
cmd.exe and batch files
4 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,…
Monorepos and lightweight tool choices
4 minA 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…
Choosing test layers — Vitest, pytest, Cypress, and Playwright
4 minSeparate unit, integration, browser, and production smoke checks, then assign Vitest, pytest, Cypress, and Playwright without duplicating responsibilities.
Forms — react-hook-form and zod
4 minForms are the part you meet most often in any app.
Push Notifications — FCM and Web Push
9 minTo deliver messages on mobile or web while the app is closed, the push channels provided by the OS or the browser must be traversed. iOS has APNs, Android has FCM, and the web has the Web Push standard.
Debugging Mindset — The Hypothesis-Verification Cycle
6 minReports that the time spent fixing already-built code is longer than the time spent building new features are common. Debugging is closer to a mindset than a separate skill. We honestly examine what we're assuming and w…
Local LLM — LM Studio · llama.cpp · Ollama · vLLM
6 minThe 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…
Backup and Restore
5 minMaking data is not a backup. Restoring is. The difference only shows up after an incident. Here is a summary of PostgreSQL's tools, policies, and rehearsals.