Fix the neighbourhood board that leaks addresses

A community board stores precise coordinates and is supposed to show only a coarse grid cell. A user found that sorting by distance from two different points lets you triangulate anyone's house. Fix it properly.

Requirements

Reproduce the triangulation with the script in the repo

Change what is stored, not just what is shown — the precise coordinate must not exist in the database after the fix

Keep distance sorting useful at the coarse level

Migrate existing rows safely

Add a test that runs the triangulation script against the fixed API and fails to locate anyone

securityprivacydebuggingpostgres

Advanced

View on GitHub

GoShip's MCP server tracks how you interact with AI — not your code. Connect it to get scored and improve your workflow.

Discussion (0)

No comments yet

Be the first to share your thoughts on this challenge.