Tacnode™
Resources

Videos

Short explainers and product demos.

Explainers

Short, concept-first walkthroughs of how things work in SQL.

Card Fraud: Six Purchases Approved on an Account Already on Hold
4 min

Card Fraud: Six Purchases Approved on an Account Already on Hold

A 4-minute walkthrough of a fraud hold placed in time that reaches card authorization eight seconds late, and the same hold with current context.

Past-Posting in Live Betting: Why Sportsbooks Keep Taking Bets After a Goal
4 min

Past-Posting in Live Betting: Why Sportsbooks Keep Taking Bets After a Goal

A 4-minute walkthrough of a sportsbook that keeps taking bets for seven seconds after a goal, and the same goal with current context.

Do You Actually Need a Separate Vector Database?
3 min

Do You Actually Need a Separate Vector Database?

A 3-minute explainer on when a separate vector database earns its place, and what changes when similarity search has to agree with live filters and state.

Why ClickHouse JOINs Are Slow (and Why Denormalizing Isn't the Fix)
4 min

Why ClickHouse JOINs Are Slow (and Why Denormalizing Isn't the Fix)

A 4-minute explainer on why ClickHouse JOINs are slow, what denormalizing costs, and what it looks like when joins stay first-class.

ACID for AI Agents: Why Agent Data Breaks at Decision Time
3 min

ACID for AI Agents: Why Agent Data Breaks at Decision Time

A 3-minute explainer on why agent decisions go wrong when the derived state they read comes from three systems at three different moments.

Medallion Architecture Explained: Bronze, Silver, Gold, and Pipeline Delay
3 min

Medallion Architecture Explained: Bronze, Silver, Gold, and Pipeline Delay

A 3-minute explainer on bronze, silver and gold layers, and why gold is only as fresh as the slowest hop above it.

False Declines on New Cards: When Fraud Checks Read Stale Data
2 min

False Declines on New Cards: When Fraud Checks Read Stale Data

A 2-minute walkthrough of a good customer's new card getting declined at checkout, and the same moment with current context.

AI Agent Memory Explained: Types, Stores, and Stale State
3 min

AI Agent Memory Explained: Types, Stores, and Stale State

A 3-minute explainer on the kinds of agent memory, why three stores drift apart, and what it takes to give the next step memory it can trust.

What Is a Context Lake? The Data Layer Behind Real-Time AI Decisions
3 min

What Is a Context Lake? The Data Layer Behind Real-Time AI Decisions

A 3-minute explainer that builds the context lake as one diagram — where the data comes from, what it serves, and why the usual middle leaves decisions acting on a reality that has already moved.

pgvector Tutorial: Vector Search in Postgres from Scratch
3 min

pgvector Tutorial: Vector Search in Postgres from Scratch

A 3-minute pgvector walkthrough — enable the extension, store embeddings, query nearest neighbors, and index with HNSW or IVFFlat, all in the Postgres you already run.

Hybrid Search in SQL, Explained
3 min

Hybrid Search in SQL, Explained

A 3-minute walkthrough of hybrid search — why keyword, vector, and filters each fail alone, and how to combine all three in one SQL query with reciprocal rank fusion.

Postgres Full-Text Search, Explained
3 min

Postgres Full-Text Search, Explained

A 3-minute walkthrough of full-text search in PostgreSQL — why LIKE falls apart, how Postgres builds an inverted index, and what Tacnode adds (native BM25 ranking, no Elasticsearch).

Incremental Materialized Views in Postgres, Explained
3 min

Incremental Materialized Views in Postgres, Explained

A 3-minute explainer on incremental materialized views — how they work, why standard Postgres REFRESH breaks at scale, and what Tacnode adds.

Time Travel Queries in SQL, Explained
3 min

Time Travel Queries in SQL, Explained

A 3-minute explainer on time travel queries in SQL — why backups, audit logs, and change-tracking columns fall short, and how one FOR SYSTEM_TIME AS OF clause replaces them.

Pipelies

Fourteen short walkthroughs, one for each lie a data pipeline tells.

The Frozen Score: Account Takeover Approved on a Ten-Hour-Old Risk Score
2 min

The Frozen Score: Account Takeover Approved on a Ten-Hour-Old Risk Score

A short walkthrough of a transfer check that reads a risk score computed at 2 a.m., ten hours before someone else took over the account.

The Peak-Hour Lag: A Velocity Check Counts 3 Card Attempts Out of 9
2 min

The Peak-Hour Lag: A Velocity Check Counts 3 Card Attempts Out of 9

A short walkthrough of a velocity check that reads a replica at the lunch peak and counts three card attempts when there were nine.

The Agent's Alibi: Two AI Agents Overspend One $5,000 Budget
2 min

The Agent's Alibi: Two AI Agents Overspend One $5,000 Budget

A short walkthrough of two agents that each read a $5,000 budget and between them commit $7,500.

The Stale Segment: A Welcome Offer for a Customer with Six Orders Today
2 min

The Stale Segment: A Welcome Offer for a Customer with Six Orders Today

A short walkthrough of a campaign engine that reads last night's segment and sends a 20% welcome offer to a customer with six orders today.

The Vanishing Order: "Order Not Found," So the Customer Pays Twice
2 min

The Vanishing Order: "Order Not Found," So the Customer Pays Twice

A short walkthrough of a confirmation page that reads a lagging replica, says "Order not found" and gets the customer to pay twice.

The Scattered Balance: A $4,000 Order Accepted on $2,000 of Buying Power
2 min

The Scattered Balance: A $4,000 Order Accepted on $2,000 of Buying Power

A short walkthrough of an order check that reads $5,000 of buying power two seconds after a $3,000 order on another product.

The Crowded Total: A $10K Bet Accepted with $4K of Room Under the Cap
2 min

The Crowded Total: A $10K Bet Accepted with $4K of Room Under the Cap

A short walkthrough of a bet check that reads a $186,000 liability total while the real figure is $246,000 against a $250,000 cap.

The Linked Accounts: Four Accounts Get Past a Per-Person Position Limit
2 min

The Linked Accounts: Four Accounts Get Past a Per-Person Position Limit

A short walkthrough of an order check that sees one account under the position limit while four linked accounts hold 24,000 of 25,000.

The Overnight Truth: Refunds Tripled and the Dashboard Still Says 1.2%
2 min

The Overnight Truth: Refunds Tripled and the Dashboard Still Says 1.2%

A short walkthrough of an afternoon fraud threshold set from a dashboard that last loaded at 6 a.m., while refunds more than tripled.

The Averaged Lie: A Stale Average Sets the Order Cap Too Low
2 min

The Averaged Lie: A Stale Average Sets the Order Cap Too Low

A short walkthrough of a limit engine that sizes its per-order cap from an hour-old average and starts declining the new buyers' orders.

The Next-Day Alert: $1,600 Staked and the Safer-Gambling Check Reads Zero
2 min

The Next-Day Alert: $1,600 Staked and the Safer-Gambling Check Reads Zero

A short walkthrough of a safer-gambling check that reads zero all day while a customer stakes $1,600 against a usual $200.

The Silent Skip: The Job Succeeded and 412 Rows Went Missing
2 min

The Silent Skip: The Job Succeeded and 412 Rows Went Missing

A short walkthrough of a nightly load that drops 412 rows, reports success, and leaves an underwriting rule reading an incomplete account history.

The Late Arrival: Settlement Released Short After a Source Landed Late
2 min

The Late Arrival: Settlement Released Short After a Source Landed Late

A short walkthrough of a nightly join that runs before its second source lands, and a settlement released short on the total.

The Two Truths: Finance Says $10.3M, Ops Says $9.7M
2 min

The Two Truths: Finance Says $10.3M, Ops Says $9.7M

A short walkthrough of two dashboards that report $10.3 million and $9.7 million for the same revenue, and the meeting that follows.

Ready to get started?

Book a demo to see how Tacnode can power your real-time data infrastructure.