Articles
Technical articles and updates.
Introduction How CREATE TABLE Generation From a Visual Table Design Works | DDL Builder
A look inside DDL Builder, which turns a visually designed table into CREATE TABLE statements and an ER diagram. Covers the MySQL/PostgreSQL/SQLite type-mapping rules and the column-inference algorithm used for JSON samples.
Use Case GitHub Actions needs Design Patterns: Speed Up CI, Avoid the Anti-Patterns
A pattern reference for GitHub Actions job dependencies (needs). Covers diamond-shaped fan-out, concurrency cancellation, fail-fast tradeoffs, matrix-plus-needs gotchas, and reusable workflows, with copy-paste YAML examples.
Use Case SQL JOIN Types: Complete Reference to INNER, LEFT, RIGHT & FULL
A reference for SQL JOIN types (INNER/LEFT/RIGHT/FULL/CROSS/SELF) with a cheat sheet and row-count walkthroughs. Covers why one-to-many joins duplicate rows, the WHERE-vs-ON NULL trap, and how to write multi-table joins.
Introduction Case Converter: camelCase, snake_case & kebab-case — 9 Styles at Once
Convert identifiers between camelCase, PascalCase, snake_case, CONSTANT_CASE, kebab-case and more — all nine styles side by side. Handles acronym runs like HTTPServer, digits, and bulk multi-line conversion.
Introduction LLM API Cost Calculator: Compare Claude, GPT & Gemini Pricing Side by Side
Paste a prompt, set the expected output tokens, and compare per-request API costs across Claude, GPT and Gemini models. Covers input/output pricing structure, auto-updated price tables, and estimate limits.
Use Case AGENTS.md, CLAUDE.md, Cursor Rules: One Source of Truth for AI Coding Agents
Every AI coding agent wants its own rules file. Compare AGENTS.md, CLAUDE.md, .cursor/rules, copilot-instructions.md and more — what to write, a copy-paste template, and how to stop them drifting apart.
Use Case Mermaid ER Diagram Syntax Reference: Relationship Symbols & Real Examples
Complete reference for Mermaid erDiagram syntax: crow's foot cardinality cheat sheet, one-to-many vs many-to-many, attributes with PK/FK, and a full e-commerce example.
Introduction AI Rules Generator: AGENTS.md, CLAUDE.md & Cursor Rules from One Form
Generate rules files for Claude Code, Cursor, GitHub Copilot, Windsurf and Gemini CLI in one shot. Covers the AGENTS.md standard, per-tool file formats, and why a single source of truth prevents rule drift.
Introduction LLM Token Counter: Check Claude, GPT & Gemini Token Counts in Your Browser
Paste text and compare token counts for Claude, GPT and Gemini side by side. Covers token basics, why tokenizers differ per model, why non-English text costs more tokens, and the limits of estimates.
Introduction IP/CIDR Subnet Calculator: Network, Broadcast & Mask at a Glance
How to calculate the network address, broadcast address, usable hosts, subnet mask and wildcard mask from CIDR notation like 192.168.1.10/24 — with a prefix-length cheat sheet.
Use Case Encoding vs Hashing vs Encryption: The Difference and When to Use Each
Base64 encoding, SHA-256 hashing and encryption are constantly confused, yet serve completely different purposes. A comparison table, concrete examples, and the right choice for each use case.
Introduction How to Convert HEX, RGB, and HSL Colors and Check Contrast
Convert CSS color formats, adjust colors with HSL, and check foreground/background contrast for readable UI design.