Skip to content
Articles

Developer Articles

Hands-on articles on developer tools, implementation notes, technical deep dives, and everyday debugging and data conversion workflows.

Thumbnail image for How to Draw an Architecture Diagram in Your Browser: Icons, Group Frames, PNG/SVG Export
Introduction

How to Draw an Architecture Diagram in Your Browser: Icons, Group Frames, PNG/SVG Export

Draw a system architecture diagram of users, edge, servers and external services with icons and group frames. Auto-routed right-angle lines, PNG/SVG export.

Thumbnail image for curl Options List: -X, -H, -d and Windows curl.exe
Use Case

curl Options List: -X, -H, -d and Windows curl.exe

curl options by purpose: -X, -H, -d, -F, -o, -L, -k, -w, timeouts and retries. How -d differs from --data-raw, the @ file prefix, and curl.exe quoting.

Thumbnail image for Converting Between JSON Schema and Zod: How required Maps to .optional()
Introduction

Converting Between JSON Schema and Zod: How required Maps to .optional()

A two-way JSON Schema and Zod converter: inverted defaults of required vs .optional(), the constraint mapping table, and parsing Zod without executing code.

Thumbnail image for SQL Clause Order Reference: Why WHERE Can't See Your SELECT Alias
Use Case

SQL Clause Order Reference: Why WHERE Can't See Your SELECT Alias

SQL is written in one order and run in another. The logical execution order (FROM to LIMIT), why aliases fail in WHERE, and WHERE vs HAVING.

Thumbnail image for Unified Diff Format Reference: Reading @@ Hunks in git diff Output
Use Case

Unified Diff Format Reference: Reading @@ Hunks in git diff Output

How to read git's unified diff: what @@ -12,7 +12,9 @@ means, why a one-character edit shows as a whole-line replacement, and whitespace and line-ending traps.

Thumbnail image for UTC to JST Reference: The 9-Hour Offset, Cheat Sheet & Timezone Pitfalls
Use Case

UTC to JST Reference: The 9-Hour Offset, Cheat Sheet & Timezone Pitfalls

Add 9 hours to UTC to get JST (UTC 00:00 = JST 09:00). A cheat sheet, what Z and +09:00 mean in ISO 8601, and why GitHub Actions cron always runs in UTC.

Thumbnail image for CREATE TABLE Reference: MySQL vs PostgreSQL vs SQLite Types & Constraints
Use Case

CREATE TABLE Reference: MySQL vs PostgreSQL vs SQLite Types & Constraints

Cross-database CREATE TABLE reference: data types, auto-increment (AUTO_INCREMENT / IDENTITY / rowid), ON DELETE, and the CHECK that MySQL silently ignores.

Thumbnail image for How CREATE TABLE Generation From a Visual Table Design Works | DDL Builder
Introduction

How CREATE TABLE Generation From a Visual Table Design Works | DDL Builder

How DDL Builder turns a visual table design into CREATE TABLE statements and an ER diagram: MySQL/PostgreSQL/SQLite type mapping and JSON column inference.

Thumbnail image for GitHub Actions needs Design Patterns: Speed Up CI, Avoid the Anti-Patterns
Use Case

GitHub Actions needs Design Patterns: Speed Up CI, Avoid the Anti-Patterns

GitHub Actions job dependency (needs) patterns: diamond fan-out, concurrency cancellation, fail-fast tradeoffs, matrix gotchas and reusable workflows.

Thumbnail image for SQL JOIN Types: Complete Reference to INNER, LEFT, RIGHT & FULL
Use Case

SQL JOIN Types: Complete Reference to INNER, LEFT, RIGHT & FULL

SQL JOIN types (INNER/LEFT/RIGHT/FULL/CROSS/SELF): syntax, a cheat sheet, why one-to-many joins duplicate rows, and the WHERE-vs-ON NULL trap.

Thumbnail image for Case Converter: camelCase, snake_case & kebab-case — 9 Styles at Once
Introduction

Case Converter: camelCase, snake_case & kebab-case — 9 Styles at Once

Convert identifiers between camelCase, PascalCase, snake_case, kebab-case and more, all nine styles at once. Handles acronyms like HTTPServer and bulk input.

Thumbnail image for LLM API Cost Calculator: Compare Claude, GPT & Gemini Pricing Side by Side
Introduction

LLM API Cost Calculator: Compare Claude, GPT & Gemini Pricing Side by Side

Paste a prompt, set expected output tokens and compare per-request API costs across Claude, GPT and Gemini. Covers pricing structure and estimate limits.

Thumbnail image for AGENTS.md, CLAUDE.md, Cursor Rules: One Source of Truth for AI Coding Agents
Use Case

AGENTS.md, CLAUDE.md, Cursor Rules: One Source of Truth for AI Coding Agents

Compare AGENTS.md, CLAUDE.md, .cursor/rules and copilot-instructions.md: what to write, a copy-paste template, and how to keep them from drifting apart.

Thumbnail image for Mermaid ER Diagram Syntax Reference: Relationship Symbols & Real Examples
Use Case

Mermaid ER Diagram Syntax Reference: Relationship Symbols & Real Examples

Reference for Mermaid erDiagram syntax: crow's foot cardinality cheat sheet, one-to-many vs many-to-many, PK/FK attributes, and a full e-commerce example.

Thumbnail image for AI Rules Generator: AGENTS.md, CLAUDE.md & Cursor Rules from One Form
Introduction

AI Rules Generator: AGENTS.md, CLAUDE.md & Cursor Rules from One Form

Generate rules files for Claude Code, Cursor, Copilot, Windsurf and Gemini CLI at once. Covers AGENTS.md, per-tool formats, and one source of truth.

Thumbnail image for LLM Token Counter: Check Claude, GPT & Gemini Token Counts in Your Browser
Introduction

LLM Token Counter: Check Claude, GPT & Gemini Token Counts in Your Browser

Paste text and compare token counts for Claude, GPT and Gemini. Covers token basics, why tokenizers differ per model, and the limits of estimates.

Thumbnail image for IP/CIDR Subnet Calculator: Network, Broadcast & Mask at a Glance
Introduction

IP/CIDR Subnet Calculator: Network, Broadcast & Mask at a Glance

Calculate the network address, broadcast address, usable hosts, subnet mask and wildcard mask from CIDR like 192.168.1.10/24, with a prefix cheat sheet.

Thumbnail image for Encoding vs Hashing vs Encryption: The Difference and When to Use Each
Use Case

Encoding vs Hashing vs Encryption: The Difference and When to Use Each

Base64 encoding, SHA-256 hashing and encryption are constantly confused but serve different purposes. A comparison table, examples, and when to use each.

Thumbnail image for How to Convert HEX, RGB, and HSL Colors and Check Contrast
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.

Thumbnail image for How to Read a QR Code from an Image and Check the URL Before Opening It
Introduction

How to Read a QR Code from an Image and Check the URL Before Opening It

Decode QR codes from images or screenshots, verify campaign links before printing, and inspect suspicious QR URLs safely.

Thumbnail image for How to Count Characters and Clean Text for Docs, Forms, and Code Snippets
Introduction

How to Count Characters and Clean Text for Docs, Forms, and Code Snippets

Use character counts, line counts, whitespace cleanup, and HTML escaping to prepare text for documentation, metadata, forms, and development workflows.

Thumbnail image for How to Convert Milliseconds, Seconds, Minutes, and Hours for Timeouts and TTLs
Introduction

How to Convert Milliseconds, Seconds, Minutes, and Hours for Timeouts and TTLs

Convert time units for API timeouts, cache TTLs, retry delays, polling intervals, and monitoring settings without mixing up milliseconds and seconds.

Thumbnail image for How to URL Encode and Decode Strings for APIs and Query Parameters
Introduction

How to URL Encode and Decode Strings for APIs and Query Parameters

Learn what percent encoding means, when to encode URLs, and how to inspect encoded query strings safely during API and tracking-link debugging.

Thumbnail image for How to Convert URL Parameters to JSON for UTM and API Debugging
Introduction

How to Convert URL Parameters to JSON for UTM and API Debugging

Turn long query strings into readable JSON so you can review UTM tags, API filters, duplicated keys, and encoded values more easily—with concrete examples.

Thumbnail image for How to Build SELECT and JOIN Queries Visually with a SQL Builder
Introduction

How to Build SELECT and JOIN Queries Visually with a SQL Builder

Assemble SELECT, WHERE and JOIN clauses in your browser with a visual SQL builder. Useful for learning SQL, extracting data, and drafting queries before review.

Thumbnail image for CSV and JSON Conversion: Choosing the Right Format for APIs and Data Migration
Introduction

CSV and JSON Conversion: Choosing the Right Format for APIs and Data Migration

Learn how to convert between CSV and JSON safely, including headers, delimiters, value types, nested data, and practical workflow tips.

Thumbnail image for JSON Formatting and Validation: How to Read API Responses Safely
Introduction

JSON Formatting and Validation: How to Read API Responses Safely

Learn how to format JSON, catch syntax errors, inspect value types, and turn API responses into types, schemas, or documentation.

Thumbnail image for Create Infrastructure Diagrams in Your Browser: Auto-Generate Diagrams from Code
Introduction

Create Infrastructure Diagrams in Your Browser: Auto-Generate Diagrams from Code

Use our Mermaid.js-based infrastructure diagram builder to visualize cloud and network configurations just by defining nodes and connections.

Thumbnail image for Generate ER Diagrams from SQL DDL: How CREATE TABLE Parsing Works
Introduction

Generate ER Diagrams from SQL DDL: How CREATE TABLE Parsing Works

How the SQL to ER diagram tool parses CREATE TABLE DDL into a Mermaid ER diagram: PRIMARY KEY/FOREIGN KEY extraction, column types, and unsupported patterns.

Thumbnail image for The JSON Ecosystem: Connecting Formatting, Types, Validation, and API Specs
Introduction

The JSON Ecosystem: Connecting Formatting, Types, Validation, and API Specs

Follow one API response through formatting, TypeScript types, Zod runtime validation and OpenAPI definitions, with real code at every step.