Notes

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

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,…

15 views

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…

13 views

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…

12 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…

12 views

In Python web backends, frameworks rarely enforce a folder layout, so it falls to team agreement. A well-organized layout shortens onboarding for new members; without it, the same patterns get scattered everywhere.

Systems that handle external data reduce to similar steps everywhere. Fetch the data, clean it, store it, and expose it.

As LLM-based code assistants become routine, "how should we mark that AI helped?" has split into different team decisions. This article objectively organizes the relevant facts (lawsuits, OSS license positions, commit t…

If MCP is the standard, the clients are the entry points that actually expose it to users. Multi-client environments, where multiple clients share the same server simultaneously, are the reality.

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.

TypeScript is a language that adds static types to JavaScript. This post lays out TypeScript's origins, how it works, and what strict: true actually turns on, all on a factual basis. We also touch on the gap left by run…

Around the time Cursor went GA in 2023, IDEs where "AI is the main interaction" multiplied fast. Various attempts have been made, either as VS Code forks or new editors. Capability evaluations change quickly with time,…

Making 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.

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…

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.

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…

There's no fixed answer to questions like "how many years to learn full-stack?" There are, however, frequently-cited visual references, frequent traps, and frequently-recommended orders. This article covers the source o…

From Tauri 2, Android and iOS became first-class citizens. Mobile apps have different distribution and monetization models from desktop.

The training-data cutoff of an LLM never quite matches the latest. Library docs and API specs change often, and the model answers with old information confidently. MCP servers and services that expose docs in an LLM-fri…

The Model Context Protocol (MCP) is a protocol for connecting LLM clients to external data, tools, and prompts in a standardized way. Anthropic released it in November 2024 and other AI tools and IDEs adopted it quickly…

Building 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…

The 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…

Next.js is a framework that bundles server rendering, routing, and bundling on top of React.

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…

Python's packaging and dependency management has seen many tools rise and fall over time. This article walks through them in chronological order and notes what each tool solved, and where it fell short — based on facts.