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.

Ready to get started?

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