NRNylah Reynardinhumanpen.hashnode.dev·3d ago · 6 min readAI Humanizer Limits Need a Schema, Not a RankingA comparison that puts 8,000 words, 10,000 characters, 125 words, and unlimited in one Limit column has a type problem. Those values do not describe the same boundary. One may belong to a paid plan, a10
SNSpecial Needs Care Networkinspcn.hashnode.dev·Aug 13 · 4 min readModelling a Provider Taxonomy When One Provider Belongs to Several CategoriesMost directory schemas begin the same way: a providers table with a provider_type column, an enum with two or three values, and a hub page per value. It is the right first move. It stops being right t00
SNSpecial Needs Care Networkinspcn.hashnode.dev·Aug 11 · 3 min readBuilding a City-First Event Directory: Location and Category as First-Class DataAn event directory looks simple from the outside: search for a venue, open a profile, and ask for a quote. The underlying product problem is more specific. An event search is usually constrained by se00
SNSpecial Needs Care Networkinspcn.hashnode.dev·Aug 11 · 3 min readA Query Contract for Local Provider SearchLocal provider search is often treated as a text-ranking problem. A user types a city and a service, the system returns a list of pages, and the product team tunes the copy. That model is incomplete. 00
ABAniruddha Banerjeeinaniruddhawrites.hashnode.dev·Aug 6 · 23 min readThe DISTKEY That Was Right, and Still WrongAuthor's Note This account is inspired by recurring patterns observed in enterprise Amazon Redshift environments. Table names, business context, and specific figures have been generalized to protect c00
AAihh浩inaicompanionnotes9899.hashnode.dev·Jul 30 · 7 min readPin, Correct, Expire, Forget: A User-Controlled Memory Model for AI CompanionsDisclosure: I work with the LumiChat team. This article describes a vendor-neutral memory architecture we use when thinking about long-running character conversations. It is not an independent product00
ABAniruddha Banerjeeinaniruddhawrites.hashnode.dev·Jul 17 · 11 min readThe Post-Acquisition Assumption GapThe Post-Acquisition Assumption Gap Two years after we closed an acquisition, we found out our own pipeline still thought the company hadn't happened. Editor’s Introduction Enterprise data failures r00
CPChandrika Pathakamuriinwhat-is-microsoft-fabric.hashnode.dev·Jul 14 · 6 min readWhy Analytics Engineers Are Becoming Essential: The Missing Layer in Modern Data TeamsOrganizations have never had more data. Yet many still struggle to trust it. The rise of Analytics Engineering isn’t about another job title — it’s about solving one of the biggest challenges in moder00
SSapotaCorpinsapotacorpvn.hashnode.dev·Jul 12 · 10 min readWhat is a Contact Key in Salesforce Marketing CloudA new SFMC project lands on the team's plate. The first task before any Data Extension gets created is the Contact Key decision. Most teams treat this as an afterthought. The teams that lose 3 months 00
SSapotaCorpinsapotacorpvn.hashnode.dev·Jul 12 · 10 min readSCD Type 4 in a Lakehouse: History and Field Audit from Iceberg SnapshotsOn a recent build for a regulated credit bureau, we had a hard requirement that pulled in two directions at once. The reporting layer needed dimension tables that stayed small and fast for Power BI, b00
