Open source alternative to Semrush and Ahrefs
TypeScript backlink-analysisgoogle-search-console-mcpkeyword-researchmcpseoseo-agentseo-auditseo-automationseo-skillsseo-toolssite-audit
/**
* Deterministic row ids for audit data.
*
* Crawl/lighthouse persistence happens inside Workflow steps, which retry on
* failure. Deriving ids from stable content (audit id + URL + ...) combined
* with `onConflictDoNothing` makes those writes idempotent across retries —
* a partially-written batch is simply completed on the next attempt instead
* of duplicated under fresh random ids.
*/
export async function sha256Hex(text: string): Promise<string> {
const digest = await crypto.subtle.digest(
"SHA-256",
new TextEncoder().encode(text),
);
return Array.from(new Uint8Array(digest))
.map((byte) => byte.toString(16).padStart(2, "0"))
.join("");
}
export async function deterministicAuditRowId(
...parts: string[]
): Promise<string> {
return (await sha256Hex(parts.join("|"))).slice(0, 36);
}