Tag See all →

#csv

2 stories

Banner: a CSV header row where the first column name hides an invisible byte order mark

Programming Languages Bug Report

CSV import fails on the first column: the UTF-8 BOM from Excel

Daniel Tran · Jun 19, 2025 · 9 min read

Customer CSV uploads failed with KeyError 'email' even though the header clearly said email. Excel had written a UTF-8 byte order mark, and other files arrived in Windows-1252. We now detect the encoding explicitly and normalise headers.

Banner: an API server memory gauge overflowing while exporting half a million database rows

Web Development Bug Report

CSV export endpoint ran out of memory at 500K rows: streaming it with lazyById

John Nguyen · Jun 6, 2025 · 9 min read

Our orders export worked for every customer until one crossed 500,000 rows and PHP died with Allowed memory size exhausted. The endpoint loaded everything with get(), then built the CSV in memory. Streaming keyset chunks straight to the response fixed it at a flat 40 MB.