LZLION ZHANLinplaybasketballbros-engineering.hashnode.dev·5d ago · 2 min readPinpoint #838: Model Compound-Phrase Direction with PostgreSQL ConstraintsThe answer to LinkedIn Pinpoint #838 for August 16, 2026 is words that come before “frame.” Freeze, time, bed, door, and picture each form a familiar compound phrase when “frame” follows. Treat the di00
LZLION ZHANLinplaybasketballbros-engineering.hashnode.dev·5d ago · 8 min readPinpoint #837: Model Delivery Evidence in PostgreSQL Without a Boolean TrapPinpoint #837 is about things that are delivered. For a database designer, the five clues are a warning against reducing a domain event to a single delivered boolean. The puzzle for Saturday, August 100
LZLION ZHANLinplaybasketballbros-engineering.hashnode.dev·Aug 14 · 4 min readModel Pinpoint #836 as a Prefix Trie in TypeScriptThe answer to Pinpoint #836 for August 14, 2026 is “terms that come after Super Mario in video game titles.” Odyssey, Galaxy, Kart, 64, and Bros. 3 are five suffixes that all accept the same prefix. T00
LZLION ZHANLinplaybasketballbros-engineering.hashnode.dev·Aug 13 · 4 min readBuild a Polymorphic Clue Card from Pinpoint #835’s Spotted PatternThe pinpoint answer for Thursday, August 13, 2026 is “Things that have spots.” The five clues are The Sun, Dominoes, Leopards, Dalmations, and Ladybirds (ladybugs). This is also a compact frontend-des00
LZLION ZHANLinplaybasketballbros-engineering.hashnode.dev·Aug 12 · 4 min readWhat 98 Repeated Puzzle Clues Taught Me About Text NormalizationThe difficult part of counting repeated puzzle clues was not the string processing. It was deciding what a repeated string actually meant. I recently analyzed 1,500 clues from 300 archived LinkedIn Pi00
