#sqlite

2 posts tagged #sqlite.

Empty chair in a hall with an ID card on the seat, lit between blurred chairs in the dark.

Lessons

The wrong key

We matched each sale to its row in the sheet instead of the camera sold, so duplicates slipped through

We matched sales by their row in the spreadsheet instead of the camera sold, so every re-pasted block came in as a new sale.

#data-quality#deduplication#reconciliation#sqlite

Nicolás Biondi· 4 min readRead the post

A small table bending under a huge cracked box, next to a small tidy cube of cyan light.

Infrastructure

Every click crashed it

We moved a 130 MB file to a real database, and each click dropped from 5 seconds to 0.6 ms

Nicolás Biondi· 4 minRead the post