I build production systems for AI automation, data pipelines, and analytics.
Backend architecture · LLM orchestration · Scalable data infrastructure.

1# normalize + stable hash (accounts for platform & angle)
2def normalize_content(content: str) -> str:
3    normalized = content.lower()
4    normalized = re.sub(r"\s+", " ", normalized)
5    normalized = re.sub(r"[^\w\s]", "", normalized)
6    return normalized.strip()
7
8
9def compute_content_hash(content: str, platform: str, angle: str) -> str:
10    normalized = normalize_content(content)
11    hash_input = f"{normalized}|{platform.lower()}|{angle.lower()}"
12    return hashlib.sha256(hash_input.encode("utf-8")).hexdigest()
13
14
15# orchestrator: exact-hash → trigram → fallback
16async def check_duplicate(session, campaign_id, content, platform, angle, threshold=0.7):
17    content_hash = compute_content_hash(content, platform, angle)
18
19    exact = await check_exact_duplicate(session, campaign_id, content_hash)
20    if exact:
21        return {"is_duplicate": True, "type": "exact", "existing_post_id": exact.id}
22
23    near = await check_near_duplicate_trgm(session, campaign_id, content, threshold)
24    if not near:
25        near = await check_near_duplicate_fallback(session, campaign_id, content, threshold)
26
27    return {"is_duplicate": bool(near), "type": "near" if near else None, "content_hash": content_hash}

1type JsonLdProps = {
2  data: Record<string, unknown> | Array<Record<string, unknown>>;
3};
4
5export function JsonLd({ data }: JsonLdProps) {
6  const payload = Array.isArray(data) ? data : [data];
7  const graphNodes = payload.map((node) => {
8    const { "@context": _ctx, ...rest } = node as Record<string, unknown>;
9    return rest;
10  });
11
12  const json =
13    graphNodes.length === 1
14      ? { "@context": "https://schema.org", ...graphNodes[0] }
15      : { "@context": "https://schema.org", "@graph": graphNodes };
16
17  return (
18    <script
19      type="application/ld+json"
20      dangerouslySetInnerHTML={{ __html: JSON.stringify(json) }}
21    />
22  );
23}