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.

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

In any app with an auth gate, there's a spot that decides which routes anonymous users may see. That spot is usually a public-route allow-list. When you add a new domain and forget to update it, users hit informational…

A dashboard is a mirror of the domains your product owns. With 5 domains and only 3 widgets, users instinctively suspect "the other 2 must be unfinished." Uniformity is less an aesthetic concern than a feature-recogniti…

When a project ships content (Markdown, JSON, CSV…) as DB seed, where those files live is a surprisingly big decision. The obvious place — inside the app folder that consumes them (frontend/myapp/content/) — turns out t…

Browser tabs, SEO snippets, OG share cards — the same page often shows three different titles in three places. Cause is straightforward: the title template isn't composed from a single source, and pages also stamp the s…

The Supabase note covered Storage in just one paragraph. This note goes deep on exactly that spot — bucket design, upload/delete code, per-file permissions (RLS), the S3-compatible API, and signed URLs. The practical qu…

Signup confirmation, password reset, one-time verification codes — when a service needs to send something directly to a user, email is usually the first channel it reaches for. Unlike push notifications, it needs no sep…

Whether to use Kafka at all is covered in another note. This one is the next step — how to name topics, how to size partitions and choose keys, how to write Producer and Consumer code. Concepts settle once you learn the…

NotebookLM is Google's source-first AI notebook. It only answers from the PDFs, Google Docs, web pages, YouTube videos, and audio files you upload — so hallucinations are far rarer than a generic chatbot. Where 04-gemin…

Google Stitch is a Google Labs tool that turns natural language and reference images into UI designs and front-end code. Think Figma's auto-layout brain plus v0.dev's component generation, with a Google look. Where 14-a…

If 10-ai-coding-ides covers desktop IDEs (Cursor · Windsurf · Kiro · Trae · Antigravity), this note covers their browser cousins — AI Web IDEs and AI app builders — that turn a prompt into code, DB, and deployment with…

Replit puts the IDE, real-time collaboration, deployment, and AI code generation in one URL. No local setup — go from a natural-language prompt to a deployed app in a browser tab. It's one of the flagship products in th…

Google AI Studio (aistudio.google.com) is the in-browser home for the Gemini family. It started as a prompt playground, but since 2024 it has grown into a notebook + app builder + auto-deploy environment — squarely in t…

GitHub Pages turns a GitHub repository into a free static website. It serves plain HTML/CSS/JS or the build output of any static site generator (Jekyll, Hugo, Vite, Astro, …).

Public contact forms, comment boxes, suggestion pages. The most abused surface on any site. Before jumping to "we must use CAPTCHA", there are lower-cost measures that already stop a lot.

An admin console or back office may need one process to access separate content, catalog, and operations databases. Direct pools can be useful, but connection budgets, permissions, and failure isolation must be designed…

In an admin app with dozens of pages and hundreds of API routes, the most common E2E mistake is forgetting to add a new route to the spec. Instead of hand-maintaining spec files, derive a route manifest from the filesys…

An internal admin site, viewed numerically, is the sum of dozens of list pages. Users, posts, point transactions, reports. If each page is built differently, operators re-learn the UI per page and developers re-copy the…

In a backend with admin capabilities, capturing who-when-what-why is more than mere tradition. It is how you satisfy privacy law (PIPA · GDPR), investigate incidents, and deter privilege misuse.

First released in 1995, Java has lived for nearly 30 years. This post lays out Java's flow, the LTS cycle, and a few features in Java 21 that carry real weight, all on a factual basis. We also briefly touch on neighbors…

The single phrase "deploy on AWS" hides choices that span very different abstraction levels. From managing one EC2 box directly all the way to function-level hosting like Lambda. Including other clouds and PaaS, the pic…