Skip to content

Instantly share code, notes, and snippets.

Discover gists

@jdnova0802
jdnova0802 / velaru_tcb_commit.json
Created August 17, 2026 14:21
Velaru TCB commit anchor POLLOCK-1 — 30f0947f9b9c63c0…
{
"velaru_tcb_commit_anchor": true,
"pollock_rail": "POLLOCK-1",
"protocol": "tcb-commit-reveal-v1",
"receipt_hash": "30f0947f9b9c63c0898f380c1049ca579016bc34980e2d5ce0c8f8e184e392df",
"action_not_taken": "invoke",
"decision_reason_hash": "9a5c36a75c0794184fd3267408ba82c8a23eb1539973f6e8ff9755ad3b45ee42",
"handler_receipt_id": null,
"domain": "insurance",
"committed_at": "2026-08-17T14:21:28.524097Z",
@jdnova0802
jdnova0802 / velaru_tcb_commit.json
Created August 17, 2026 14:21
Velaru TCB commit anchor POLLOCK-1 — 7e125bf60af54437…
{
"velaru_tcb_commit_anchor": true,
"pollock_rail": "POLLOCK-1",
"protocol": "tcb-commit-reveal-v1",
"receipt_hash": "7e125bf60af54437e75e0f60f9a3dcfba6fc8b1ef2c863a602e7f6dd48ff3161",
"action_not_taken": "invoke",
"decision_reason_hash": "9a5c36a75c0794184fd3267408ba82c8a23eb1539973f6e8ff9755ad3b45ee42",
"handler_receipt_id": null,
"domain": "insurance",
"committed_at": "2026-08-17T14:21:26.659975Z",
@jdnova0802
jdnova0802 / velaru_tcb_commit.json
Created August 17, 2026 14:21
Velaru TCB commit anchor POLLOCK-1 — a085605701963bf2…
{
"velaru_tcb_commit_anchor": true,
"pollock_rail": "POLLOCK-1",
"protocol": "tcb-commit-reveal-v1",
"receipt_hash": "a085605701963bf26dd4e53000d300b7aa2234019d73a3732f90e2b0edec6087",
"action_not_taken": "policy_bind",
"decision_reason_hash": "dccb9b1a25673dea54cf98191bb052007da5d26c907269f1bf6dfa1ba8ec0f7a",
"handler_receipt_id": null,
"domain": "insurance",
"committed_at": "2026-08-17T14:21:24.522395Z",
@jdnova0802
jdnova0802 / velaru_tcb_commit.json
Created August 17, 2026 14:21
Velaru TCB commit anchor POLLOCK-1 — 164c36b66888de0f…
{
"velaru_tcb_commit_anchor": true,
"pollock_rail": "POLLOCK-1",
"protocol": "tcb-commit-reveal-v1",
"receipt_hash": "164c36b66888de0f8530df12670b96a51f512d71a78d6731bf24b81fe0a11dc1",
"action_not_taken": "policy_bind",
"decision_reason_hash": "dccb9b1a25673dea54cf98191bb052007da5d26c907269f1bf6dfa1ba8ec0f7a",
"handler_receipt_id": null,
"domain": "insurance",
"committed_at": "2026-08-17T14:21:22.478616Z",
@aminamee
aminamee / gist:00ef118d832b7dd1af45b34f18b07bf4
Last active August 17, 2026 14:21
balitmore_postings_ai_skills.sql
WITH cleaned AS (
SELECT
title,
city,
state_code,
occupation_group,
company_id,
created,
REGEXP_REPLACE(
REGEXP_REPLACE(
@forkyau
forkyau / hourly_rainfall_data-2026-08-17|22-00.csv
Created August 17, 2026 14:21
GIST created by python code
id station stationid value unit obstime date
0 流浮山 RF001 0 mm 2026-08-17T22:00:00+08:00 2026-08-17
1 湿地公园 RF002 0 mm 2026-08-17T22:00:00+08:00 2026-08-17
2 水边围 N12 0 mm 2026-08-17T22:00:00+08:00 2026-08-17
3 石岗 RF003 0 mm 2026-08-17T22:00:00+08:00 2026-08-17
4 大美督 RF004 0 mm 2026-08-17T22:00:00+08:00 2026-08-17
5 大埔墟 RF005 0 mm 2026-08-17T22:00:00+08:00 2026-08-17
6 北潭涌 RF006 0 mm 2026-08-17T22:00:00+08:00 2026-08-17
7 滘西洲 RF007 0 mm 2026-08-17T22:00:00+08:00 2026-08-17
8 西贡 N15 0 mm 2026-08-17T22:00:00+08:00 2026-08-17
@marc12345-ctr
marc12345-ctr / dart_optional_parameter.dart
Created August 17, 2026 14:20
void main() {
// Student Information
String studentName = "Ana";
double preliminary = 85;
double midterm = 88;
double finalGrade = 90;
// Compute the average
double average = (preliminary + midterm + finalGrade) / 3;
@jdnova0802
jdnova0802 / velaru_tcb_commit.json
Created August 17, 2026 14:20
Velaru TCB commit anchor POLLOCK-1 — 8372b61f47594c0d…
{
"velaru_tcb_commit_anchor": true,
"pollock_rail": "POLLOCK-1",
"protocol": "tcb-commit-reveal-v1",
"receipt_hash": "8372b61f47594c0d62258195b9f9ebe61c94c5a29a56f8c4c88ae0cf3d3b73d9",
"action_not_taken": "policy_bind",
"decision_reason_hash": "dccb9b1a25673dea54cf98191bb052007da5d26c907269f1bf6dfa1ba8ec0f7a",
"handler_receipt_id": null,
"domain": "insurance",
"committed_at": "2026-08-17T14:20:28.561932Z",
@LukeRolos7
LukeRolos7 / registro-diario-ed14.txt
Created August 17, 2026 14:20
Ybera Club — registro público de sorteio (commit–reveal) · Diário nº 14 · 2026-08-15
YBERA CLUB — CORRIDA DE PRÊMIOS (Agosto/2026)
REGISTRO PÚBLICO DE SORTEIO — publicado ANTES do sorteio (commit–reveal)
Edição: Diário nº 14 · sorteio em 2026-08-15 às 12h
Hash SHA-256 da base congelada: 72a98f31c97e8f4ccd7267508c4ce7b91d29272c2f12c0a9ad4007fe4ab595ef
Seed público: YB-DIA14-72A98F31
Categorias: R$ 500 (558 elegíveis) · Bicicleta (292 elegíveis)
Método: embaralhamento Fisher–Yates + PRNG mulberry32 (seed derivado de SHA-256(hash+seed)).
Qualquer auditor pode reexecutar o sorteio com a base e o seed acima e conferir a sequência.
@FariyaR
FariyaR / shiphero-pagination-rca.md
Created August 17, 2026 14:19
Root cause analysis: silent order loss from positional cursor pagination over a mutating sort key

Context: production ETL pipeline syncing ShipHero warehouse data (orders, shipments, line items) into SQL Server for an e-commerce client's analytics and QC reporting.

Symptom

QC reporting flagged orders that existed in ShipHero's dashboard but were absent from our warehouse tables. There was no error in the pipeline logs. Runs completed successfully, row counts looked plausible, and the gaps only surfaced when an analyst cross-checked specific order numbers. The worst kind of data bug: silent, intermittent, and invisible to the pipeline's own health checks.

Investigation

First hypotheses were the usual suspects: API rate limiting dropping pages, timezone boundary conditions on the incremental window, or dedup logic incorrectly discarding rows. All three were ruled out by replaying historical windows: the missing orders were never present in any response payload. The API simply never returned them to us.