Posts on Sqlite.

Sender reputation first: why the Inbox Hub has no messages table

Building an inbox triage surface meant deciding what goes in the primary lookup table. The answer wasn't messages — it was senders. Five SQLite tables, a partial index on pending unknowns, and a 60-second badge later, the schema design is the product.