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

Supabase appeared in 2020 with the slogan "open source Firebase." If Firebase is one giant managed box with its own NoSQL · Auth · Storage, Supabase took the path of placing Postgres at the center and stacking small com…

Firebase started as a small startup in 2011 and was acquired by Google in 2014. Being a managed-first service, "no way to run it locally" was the right answer for a long time, but in March 2020 the picture changed when…

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

OAuth 2.0 is the standard for delegating authorization without exposing user credentials. OpenID Connect sits on top to add authentication (who is this). This article covers the Authorization Code Flow with PKCE, state…

Rate limiting protects resources, controls cost, and reduces abuse. It looks simple, but in distributed systems decisions accumulate around accuracy, fairness, and UX. This article covers the fixed window, sliding windo…

Fly.io is a PaaS that quickly deploys containers to global edge locations. Internally it converts container images into lightweight Firecracker microVMs.

The question "is this code fast?" has different answers depending on environment, hardware, and input. So computer science describes — as a function — how time (or memory) grows as input size grows. That notation is Big…

The flow of AI moving inside the browser progressed quickly between 2023 and 2025. It started with sidebar assistants, expanded into page summarization, translation, and drafting, and reached the place where agents hand…

State management in React apps creates confusion because there are many libraries. The biggest fork, however, is not the library choice but whether the state belongs to the client or to the server.

Tailwind CSS is the flagship of the so-called utility-first approach to styling.

React 19 marks one of React's larger inflection points. Among its changes, React Compiler automates some of the memoization that used to be written by hand.