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.
7 views
Things I studied and noted down. For courses, see EDU.
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.
7 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…
5 views
A 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…
5 views
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.
4 views
The word "agent" is used in several senses, which is a confusing situation. Script automation is called an agent, and so is the shape of an LLM calling tools.
4 views
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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, …).
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…
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.
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…
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 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…
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.
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…
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.