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
Every cloud call eventually passes through "who · what · where" questions. In AWS, the place that answers them is IAM (Identity and Access Management). Compared with the flashier managed services, IAM has a plain text-p…
Some modern web features simply do not work over HTTP. Service Worker, WebAuthn, parts of the media APIs, and the Secure flag for Cookie SameSite=None are the cases. In production HTTPS is naturally there, but local dev…
AWS effectively defined the cloud services market. The service catalog tops 200, but at the category level it boils down to a handful of larger groupings.
Gradle is one of the most widely used build tools in the JVM ecosystem. This article covers Gradle's origins, how it works, and how it differs from Maven.
A 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-…
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…
Claude Code is Anthropic's terminal-based coding assistant CLI, released in February 2025 (research preview at the time). It later moved to general availability and gained features like IDE integration, GitHub Actions,…
The longer we use PostgreSQL, the more we run into a few concepts at least once: MVCC, indexes, EXPLAIN, isolation levels, VACUUM, partitioning.
When writing an API on top of HTTP, REST is the word that comes up most often. It stands for Representational State Transfer, organized in Roy Fielding's 2000 doctoral dissertation.
GitHub Actions puts CI/CD inside the GitHub repository. It went into beta in 2018 and moved to GA in 2019.
Beyond using LLMs as one-shot calls, more tools bundle multi-step automation and integration flows. The strands vary — connecting nodes without writing code (GUI), or self-hosting to keep operational control.
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.
Feature flags (a.k.a. feature toggles) are a pattern frequently cited from large-company case studies. Small teams sometimes carry the same expectations into them, but cost and benefit vary by environment. This article…
Gemini is the model series Google DeepMind released in late 2023. Multimodal input — handling images · audio · video · code alongside text — and the very long context that came in with 1.5 are the often-cited features.
Fly.io is a PaaS that quickly deploys containers to global edge locations. Internally it converts container images into lightweight Firecracker microVMs.
Supabase emerged as an alternative to Firebase, an open-source backend bundle. PostgreSQL sits at the core, with auth, storage, realtime, and serverless functions stacked around it.
Cache 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.
These 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…
From Tauri 2, Android and iOS became first-class citizens. Mobile apps have different distribution and monetization models from desktop.
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.