Guides · page 4 of 14
Browsing 320 guides, newest first.
SQL GROUP BY and HAVING: Aggregate Data with Filters
GROUP BY groups rows into summary rows; HAVING filters the groups. Learn how to use GROUP BY with COUNT, SUM, AVG, MIN, MAX, when to use HAVING vs WHERE, and common pitfalls.
SQL Indexes Guide: B-Tree, Partial, Composite, and When Not to Index
Database indexes speed up queries but slow down writes. Learn how B-tree indexes work, when to add composite and partial indexes, how to identify missing indexes with EXPLAIN,...
SQL Transactions and ACID: Atomicity, Consistency, Isolation, Durability
Database transactions ensure that multiple SQL operations either all succeed or all fail. Learn ACID properties, isolation levels (READ COMMITTED, SERIALIZABLE), common...
Tailwind CSS Font Sizes and REM: How Tailwind Handles Typography Units
Tailwind CSS uses rem for all font sizes with a 16px base. Learn Tailwind's text-* classes, how to customize the type scale, use arbitrary rem values, and configure a custom...
Timezone Conversion in JavaScript: Intl API, date-fns-tz, and Luxon
Convert dates between timezones in JavaScript using the Intl.DateTimeFormat API, date-fns-tz, and Luxon. Covers UTC offset vs named timezone, DST handling, user timezone...
TSV Format Guide: Tab-Separated Values vs CSV
TSV (Tab-Separated Values) avoids the quoting complexity of CSV because tab characters rarely appear in data. Learn the TSV format, when to prefer TSV over CSV, and how to...
Unix Timestamps in Python: datetime, time, and Arrow
Work with Unix timestamps in Python using the datetime module, time.time(), and the arrow library. Covers converting timestamps to datetime objects, timezone-aware timestamps,...
URL Canonicalization: Normalize URLs for APIs, Caching, and SEO
URL canonicalization normalizes URLs to a consistent form, removing redundant parameters, encoding differences, and trailing slash inconsistencies. Learn how to canonicalize...
URL Encoding in curl: --data-urlencode, -G, and Query String Tips
curl handles URL encoding in multiple ways depending on the request type. Learn how to use --data-urlencode for POST forms, -G for GET query parameters, encode URLs in shell...
UUID Versions Explained: v1, v3, v4, v5, and v7
UUID has multiple versions with different generation strategies. Learn when to use UUID v4 (random), v5 (name-based SHA-1), v7 (time-ordered), and why v1 and v3 are largely...
Vigenère Cipher: How It Works, Breaking It, and Python Implementation
The Vigenère cipher uses a keyword to apply multiple Caesar shifts, making it resistant to simple frequency analysis. Learn how it works, the Kasiski and Index of Coincidence...
XOR Cipher Explained: One-Time Pads, Weak Encryption, and Bitwise XOR
XOR cipher is the basis of stream ciphers and one-time pads. Learn how XOR encryption works, why it's insecure without a truly random key, the Vigenère cipher relationship, and...
XSD Schema Validation: Validate XML Against a Schema in JavaScript and Python
XSD (XML Schema Definition) defines the structure, data types, and constraints for XML documents. Learn how to write XSD schemas, validate XML in Node.js and Python, and...
Apple Touch Icon: Add an iOS Home Screen Icon to Your Website
The apple-touch-icon is the image iOS uses when someone adds your site to their home screen. Here's the correct size, HTML code, and how to create an icon that looks great on...
CSS aspect-ratio Property: Maintain Proportions Without Padding Hacks
The CSS aspect-ratio property sets a preferred aspect ratio for elements. No more padding-top percentage hacks for 16:9 videos and responsive images. Here's how aspect-ratio...
Aspect Ratio Guide: Common Ratios for Video, Images, and UI Design
Aspect ratio is the proportional relationship between width and height. Here's a complete reference for common aspect ratios used in video, photography, web design, and...
Aspect Ratio in Photography and Video: 4:3, 16:9, 1:1, 2.39:1
Common aspect ratios in photography and video: 4:3 for traditional cameras, 16:9 for widescreen, 1:1 for Instagram, 2.39:1 for cinema. Learn what each ratio means and how to...
Video Aspect Ratios: 16:9, 4:3, 21:9, and Embed Best Practices
Video aspect ratios determine how video appears on different screens. Learn 16:9 for standard video, 21:9 for cinematic, 9:16 for vertical, embedding responsive YouTube/Vimeo,...
Base64 Encoding on the Command Line: Linux, macOS, and Windows
Encode and decode Base64 on the command line using base64, openssl, and PowerShell. Includes piping files, multiline input, URL-safe Base64, and common use cases like encoding...
Base64 Data URLs: Embed Images, Fonts, and Files in HTML and CSS
Base64 data URLs encode binary files as text strings for embedding directly in HTML, CSS, or JSON. Here's how data URLs work, the correct format, and when to use them vs...
Base64 Image Encoding: Embed Images in HTML, CSS, and JSON
Base64 image encoding converts image files to text strings for embedding in HTML data URLs, CSS, and JSON APIs. Here's when to use it, how to encode images, and the performance...
Base64 in Node.js: Buffer, btoa, and Streaming Large Files
Node.js provides Buffer for Base64 encoding/decoding and native btoa/atob since v16. Learn how to encode strings, binary files, streams, and JSON payloads, handle URL-safe...
Binary to Decimal: Convert Binary Numbers the Right Way
Binary to decimal conversion is foundational to understanding how computers store numbers. Here's the math, the algorithm, and how to convert in your head for small values.
How Binary Represents Text: Bits, Bytes, ASCII and UTF-8
Turning 0s and 1s into letters isn't magic, it's a lookup table. ASCII, Unicode, UTF-8, and how computers turn 0s and 1s into the characters you read every day.