Engineering notes
What we built
All
How we build
Use Case | How an Edtech Platform replaced manual fraud review with a daily risk-scoring system
How Stackdrop built a risk-scoring system that replaced manual fraud review for an Edtech platform.
How we build
How to run full-text search across multiple columns in PostgreSQL
Use PostgreSQL's tsvector to search across multiple columns and joined tables, replacing broken client-side pagination with fast, indexed full-text search.
How we build
Retool HTML Component Events: Why All Handlers Fire at Once
Why Retool fires all HTML component event handlers at once and the undocumented attribute that fixes it
How we build
PostgreSQL INT4RANGE: Enforce non-overlapping zones in SQL
How to assign postal code zones to agents without overlap, using PostgreSQL's native range type and GIST constraint.
How we build
Why Signed S3 URLs Fail in Retool's PDF Component
Retool's PDF component uses fetch() to load files. If your S3 bucket isn't configured for CORS, it fails quietly