Data & Database Workflows (page 4 of 40)
PostgreSQL, SQL, CSV, JSON, Excel, PDF, and conversion pipelines — practical workflows for working with structured data safely.
- Redshift COPY: delimiter surprises and compression
A practical guide to Redshift COPY for delimited and compressed files, focused on the exact surprises that break CSV loads in production.
- Regex validation for CSV columns: performance and pitfalls
A practical guide to regex validation for CSV columns, focused on performance, ReDoS risk, engine differences, anchors, Unicode behavior, and safer validation patterns.
- Row checker: diagnosing ragged rows after spreadsheet edits
A practical guide to diagnosing ragged CSV rows after spreadsheet edits, with row-count checks, delimiter debugging, quote handling, spreadsheet-specific failure modes, and safer repair workflows.
- Row-level checksums for CSV batches: a lightweight pattern
A practical guide to row-level checksums for CSV batches, focused on row fingerprints, auditability, dedupe, change detection, canonicalization, and real-world pitfalls.
- Salesforce Data Loader CSV requirements checklist
A practical guide to Salesforce Data Loader CSV requirements, built around the import failures teams actually hit in production.
- Schema-on-read vs schema-on-write for CSV ingestion
A practical guide to schema-on-read vs schema-on-write for CSV ingestion, focused on real pipeline tradeoffs, not abstract buzzwords.
- Scientific notation surprises in numeric-looking text columns
A practical guide to scientific notation problems in text-like identifier columns, with fixes for imports, spreadsheets, CSV round-trips, and text-first workflows.
- Shopify CSV "Image Src" rows that break on quotes
A practical guide to Shopify product CSV Image Src rows, focused on quote handling, repeated image rows, spreadsheet damage, and safer repair workflows.
- Shopify product CSV: validation patterns for bulk edits
A practical guide to validating Shopify product CSV files before bulk edits and imports, built around the failure modes merchants actually hit.
- SLAs for vendor CSV files: what to specify beyond "valid CSV"
A practical guide to vendor CSV SLAs that moves beyond vague 'valid CSV' language into measurable delivery, quality, schema, and support commitments.