Elysiate blog
Practical guides for privacy-first developer tools, SEO and content operations, data and file workflows, cloud and API security, AI engineering, and sustainable freelance work. Everything here supports the same philosophy as our browser-based utilities: your data stays on your device until you choose otherwise.
For tabular data, the CSV tools hub covers validation and conversion in the browser, and the CSV topic index lists every CSV-tagged guide in one place.
Page 59 of 101
- OpenAPI examples: generating realistic CSV fixtures from schemas
Learn to generate realistic CSV fixtures from OpenAPI schemas with explicit flattening, example precedence, nullable handling, enums. With examples and tradeoffs.
- Open-source CSV libraries in JS: selection criteria
A practical guide to choosing a JavaScript CSV library without confusing browser-first parsing, Node streams, and lightweight in-memory helpers.
- Offline-first CSV utilities: UX patterns that reduce mistakes
Learn to design offline-first CSV utilities that reduce user mistakes, with local file handling, staged validation, CSP, logging boundaries, and browser storage choices.
- Number formatting in CSV: commas, decimals, and locale chaos
A practical guide to surviving number formatting in CSV when spreadsheets, loaders, and locales disagree about commas, decimals, and thousands separators.
- Null sentinels: empty string vs NULL vs N/A vs "-"
A practical guide to designing a null-sentinel contract for CSV files so empty string, NULL, N/A, and - do not silently change meaning between systems.
- NDJSON vs JSON array: streaming-friendly interchange
A practical guide to choosing between NDJSON and JSON arrays when you care about streaming, large payloads, and record-at-a-time processing.
- Naming conventions for nightly CSV drops
A practical guide to naming nightly CSV drops so file names, columns, and partition fields stay portable across storage systems and SQL engines.
- Multipart CSV uploads: validating chunks before merge
Learn how to validate multipart CSV uploads safely before merge, including checksums, reassembly order, row-boundary awareness, and resumable upload patterns.
- Multiline addresses in CSV: quoting patterns that survive
Learn how to keep multiline addresses intact in CSV using quoting patterns that survive RFC 4180 parsers, Python, PostgreSQL COPY, and BigQuery loaders.
- Mixed encodings in one file: detection heuristics
Learn how to detect mixed encodings inside one CSV or text file using BOM checks, invalid UTF-8 scans, chunk decoding, and line-level anomaly heuristics.