A complete guide to audio and video formats. Learn the difference between containers (MP4, MKV, MOV, AVI, WebM, FLV) and codecs (MP3, AAC, OGG, Opus, FLAC, WAV, H.264, H.265, VP9, AV1), their browser support, and which format to use for music, podcasts, streaming, and editing.
Learn how to convert JSON to CSV using an online JSON to CSV converter, Excel/Google Sheets, and code examples. Covers converting JSON files to CSV, JSON Lines (NDJSON), and handling nested JSON structures.
Parquet is a binary columnar format with compression, encoding, row groups/pages, and rich metadata. This article explains why opening it in Notepad/VS Code looks like “garbage”, and the right ways to inspect and debug it (schema, preview, SQL).