Data & Database Workflows (page 11 of 40)
PostgreSQL, SQL, CSV, JSON, Excel, PDF, and conversion pipelines — practical workflows for working with structured data safely.
- gzip CSV: Streaming Reads and Validation Caveats
A practical guide to handling gzip CSV files safely when streaming, validating, and loading large tabular batches.
- Handling Late-Arriving CSV Columns in Incremental Pipelines
A practical guide to surviving new CSV columns in incremental pipelines without breaking scheduled loads, losing data, or forcing full refreshes unnecessarily.
- COPY vs Streaming Inserts: Choosing a CSV Load Strategy
A practical guide to choosing between COPY-style bulk loading and streaming inserts for CSV data, with safer patterns for production pipelines.
- CRM Duplicate Detection CSV: Matching Keys That Fail Silently
A practical guide to the matching keys that quietly break CRM duplicate detection during CSV imports, updates, and merges.
- CSV Charts: Common Mistakes in Category vs Time Series
A practical guide to the charting mistakes that happen when CSV data is plotted with the wrong assumptions about categories, dates, and time.
- CSV Embedded Inside ZIP Exports: Validation Order of Operations
A practical guide to validating ZIP exports that contain CSV files, in the right order, before they break your pipeline or your security model.
- CSV for Accounting Exports: Separators, Negatives, and Parentheses
A practical guide to handling accounting-style CSV exports without losing numeric meaning to locale settings, separators, or negative-number formatting.
- CSV in Regulated Industries: Audit Trails and Lineage Basics
A practical guide to making CSV workflows more defensible in regulated environments through audit trails, lineage, and better evidence around every file handoff.
- CSV RFC 4180 vs Real-World Exports: Where Parsers Disagree
A practical guide to why valid-looking CSV files break across tools, and where standards-based parsing diverges from real-world exports.
- "CSV" That Is Actually Semicolon-Separated European Excel
A practical guide to handling semicolon-separated Excel exports that are called CSV, without breaking parsers, decimal values, or downstream imports.