Speaker Notes

Data engineering

Databases, pipelines and data platforms.

4talks
46answers
2mainly about it
4new
DecJanFebMarAprMayJunJulAugSepOctNov

What your library answers 46

How did you approach building the backend message threading for Gmail?

Peter and the team utilized B-trees and inverted search indices to handle message threading and unread counts right from the start. This architecture supported fast lookups despite the constraints of early distributed systems.

Thumbnail: Distributed databases with Peter Mattis ▶ 12:18 Distributed databases with Peter Mattis

How do I ingest data without using a message bus like Kafka?

You can use Zerobus, which is an API that handles high-rate, bursty, or tiny-row data ingestion directly into your open lake without requiring a traditional message bus or buffering. Additionally, Spark Real-time Mode enables low-latency streaming operations down to tens of milliseconds.

Thumbnail: Data + AI Summit Keynote 2026 | Day 1 ▶ 17:21 Data + AI Summit Keynote 2026 | Day 1

How do you adapt a database platform for AI coding agents?

Superbase transitioned from dashboard and API models to a code-first approach emphasizing CLI tools and infrastructure as code. This ensures that features available in dashboards also work natively in sandboxes where agents operate.

Thumbnail: What Happens When Everyone Can Build Software ▶ 3:00 What Happens When Everyone Can Build Software

Why did Colossus transition from traditional replication to Reed-Solomon erasure coding?

Traditional replication required storing three identical copies of data, which consumed excessive storage space. Reed-Solomon erasure coding allowed the system to store data much more efficiently while still allowing data reconstruction if multiple chunks were lost.

Thumbnail: Distributed databases with Peter Mattis ▶ 19:24 Distributed databases with Peter Mattis

How does Apache Iceberg v3 solve data format fragmentation?

Apache Iceberg v3 support allows managed Iceberg tables to share data files with Delta tables without requiring any file rewrites. This establishes a unified data layer where data laid out on disk looks identical regardless of the format.

Thumbnail: Data + AI Summit Keynote 2026 | Day 1 ▶ 20:56 Data + AI Summit Keynote 2026 | Day 1

Why are open-source databases preferred by AI coding agents?

Open-source stacks allow agents to inspect source code directly when encountering errors, avoiding frustrating brick walls. This transparency also appeals to enterprises that need to audit security before adopting a vendor.

Thumbnail: What Happens When Everyone Can Build Software ▶ 3:56 What Happens When Everyone Can Build Software

Why are B-trees often preferred over binary trees for memory performance?

Standard balanced binary trees cause frequent cache misses because every node traversal jumps to a different cache line. B-trees improve spatial locality and reduce pointer overhead by packing multiple sorted items into a single node. This structure allows more compact storage and faster linear scans or binary searches over items.

Thumbnail: Distributed databases with Peter Mattis ▶ 31:08 Distributed databases with Peter Mattis

How does Lakebase Postgres support agent experimentation with databases?

Lakebase Postgres allows you to instantly branch petabyte-scale databases in less than a second using a copy-on-write mechanism on lake storage. This allows AI agents to safely experiment, test, and roll back changes without duplicating underlying storage.

Thumbnail: Data + AI Summit Keynote 2026 | Day 1 ▶ 26:00 Data + AI Summit Keynote 2026 | Day 1

How are non-engineers and domain experts building applications now?

Domain experts and non-technical builders leverage AI models to create bespoke personal software and niche solutions without needing software engineers. This surge in builder activity has accelerated signups and database creation rates significantly.

Thumbnail: What Happens When Everyone Can Build Software ▶ 2:26 What Happens When Everyone Can Build Software

How do distributed databases differ fundamentally from distributed storage systems?

Distributed storage systems like Colossus target large, immutable, append-only files such as 64-megabyte or gigabyte chunks. In contrast, distributed databases like Spanner manage relational tables with billions of typed rows and columns requiring frequent updates. Databases are typically built on top of distributed storage systems, using immutable files and log-structured merge trees to handle updates.

Thumbnail: Distributed databases with Peter Mattis ▶ 44:53 Distributed databases with Peter Mattis

What capabilities does the Unity AI Gateway provide for enterprise AI management?

The Unity AI Gateway serves as a single pane of glass to manage all AI spend, models, and MCP tools across an organization. It provides granular observability dashboards, budget limits and rate-limiting down to the individual level, and enforces security and compliance guardrails.

Thumbnail: Data + AI Summit Keynote 2026 | Day 1 ▶ 34:09 Data + AI Summit Keynote 2026 | Day 1

How do I adapt database infrastructure for AI agents?

Supabase shifted to a code-first and Git-native architecture so that database capabilities match infrastructure as code. This allows AI agents to interact with the database entirely through sandboxes rather than relying on traditional dashboards.

Thumbnail: What Happens When Everyone Can Build Software ▶ 21:37 What Happens When Everyone Can Build Software

How does contiguous key range sharding differ from basic hash-based sharding?

Basic hash-based sharding maps keys to a fixed number of shards using a hash function, which makes resharding and growing the table an onerous process. In contrast, systems like Cockroach DB use contiguous key spans across a single big key space, partitioning them with a B-tree-like index structure. This avoids full table remappings when adding nodes and places the sharding burden on the database rather than the developer.

Thumbnail: Distributed databases with Peter Mattis ▶ 52:40 Distributed databases with Peter Mattis

Why do live agent retrieval loops struggle with accuracy and performance?

Live retrieval loops force agents to perform random walks through massive enterprise data corpora, leading to high token costs and runtimes of 10 to 15 minutes. Furthermore, this ad-hoc search often results in poor accuracy because the agent lacks proper upfront context.

Thumbnail: Data + AI Summit Keynote 2026 | Day 1 ▶ 37:52 Data + AI Summit Keynote 2026 | Day 1

How should I design error messages for AI coding agents?

You should re-engineer error messages to include explicit instructions or documentation links on how to fix the error. This enables coding agents to autonomously remedy issues and complete self-healing loops without human intervention.

Thumbnail: What Happens When Everyone Can Build Software ▶ 30:22 What Happens When Everyone Can Build Software

Why does Raft consensus require at least three replicas to work?

Consensus protocols like Raft cannot function with only two replicas because a crash leaves it impossible to determine if a write successfully occurred on the other node without data loss or rollback ambiguities. Having at least three replicas allows the system to perform consensus checks during recovery by reading from a quorum. Normal reads can still hit a single replica, while writes go to all three to ensure durability.

Thumbnail: Distributed databases with Peter Mattis ▶ 1:00:44 Distributed databases with Peter Mattis

How does Genie Ontology construct enterprise knowledge graphs?

Genie Ontology automatically connects to structured and unstructured sources like the lakehouse, Google Drive, and SharePoint in the background to build a comprehensive knowledge graph. It uses an algorithm called OntoRank, inspired by PageRank, to index snippets and incorporate human-curated semantics.

Thumbnail: Data + AI Summit Keynote 2026 | Day 1 ▶ 39:10 Data + AI Summit Keynote 2026 | Day 1

When do I need vector databases and graph structures for AI agents?

As agents accumulate massive working context, such as tens of gigabytes of markdown files, standard context windows fall short. Using tools like PG vector and Postgres allows agents to perform efficient vector searches and traverse graph data structures to pull relevant context.

Thumbnail: What Happens When Everyone Can Build Software ▶ 34:08 What Happens When Everyone Can Build Software

How do I manage multiple agent sessions effectively when coding with AI?

Managing multiple agent sessions involves handling a cognitive overhead of about five to ten concurrent sessions. Depending on the complexity of the task, these sessions can orchestrate anywhere from three to over a hundred sub-agents running in parallel to perform research or implementation. This allows developers to act more like hands-on architects scaling their throughput.

Thumbnail: Distributed databases with Peter Mattis ▶ 1:20:42 Distributed databases with Peter Mattis

How does Genie 1 compare to leading AI coding and assistant agents?

Genie 1 connects to multiple enterprise data sources, including email, calendar, Salesforce, and Databricks, to deliver comprehensive customer profiles. In benchmarks on novel enterprise questions, coding agents only succeeded half the time and hit time limits, whereas Genie 1 provided grounded and accurate results.

Thumbnail: Data + AI Summit Keynote 2026 | Day 1 ▶ 1:02:45 Data + AI Summit Keynote 2026 | Day 1

How do I ensure my tooling actually works well for AI agents?

The most effective approach is rigorous dogfooding where you use coding tools and AI loops directly on your own products. Encountering your own friction and gaps provides the best feedback for improving agent workflows.

Thumbnail: What Happens When Everyone Can Build Software ▶ 47:34 What Happens When Everyone Can Build Software

How do I prevent quality and security regressions when AI generates large amounts of code?

To prevent regressions, developers must provide firm guidance and enforce rigorous testing techniques like property-based testing and deterministic simulation testing. Agents can sometimes be lazy with tests, so humans need to instill discipline and use multiple agents for adversarial security reviews on every commit. This ensures that the high volume of generated code still meets production standards.

Thumbnail: Distributed databases with Peter Mattis ▶ 1:25:00 Distributed databases with Peter Mattis

How does Genie Ontology improve agent accuracy over generic coding agents?

Genie Ontology extracts expressions, relationships, and expertise from underlying data assets, running them through an onto-rank algorithm to inject authoritative context. This approach yields a consistent 30 percentage point improvement in accuracy while cutting runtime in half compared to leading agents.

Thumbnail: Data + AI Summit Keynote 2026 | Day 1 ▶ 1:07:58 Data + AI Summit Keynote 2026 | Day 1