LectureRechercheRadarCadre d'investissement
Connexion / Inscription
← Retour à la lecture
ActualitésSujet · Hamlet市政数据AIMatériel3 min de lectureRédaction DisconfirmAI

AI Civic Data Company Hamlet: Production Data Branching Lets Coding Agents Independently Verify Each PR

Hamlet Lead Developer Erich Douglass and Senior AI Engineer Jeff Hui describe a concrete change: after giving each pull request its own branch of production data, AI coding agents can run data pipelines to completion and check their own results, while a human still approves the merge. Previously, preparing test data consumed several hours per engineer each week.

2026-10-20 22:45 GMT+8

Hamlet is an AI-powered civic data platform that indexes and transcribes city council, planning commission, and zoning board meetings across the United States, allowing real estate developers, journalists, researchers, and citizens to search meeting content and track local policy developments. CEO Sunil Rajaraman says customers want to know whether a council member will approve their housing project, why or why not, and what history the city has that might make it hesitate. This business requires processing extremely messy data from more than 7,200 governing bodies, and the engineering team is small—velocity matters more than almost anything.

Lead Developer Erich Douglass recalled the previous state: they ran one production instance and one staging instance on AWS RDS, with much of their work involving tuning data pipelines against very specific data. Every pull request required 15 to 30 minutes to get staging into the right state before they could run validations. Senior AI Engineer Jeff Hui added that 15 to 30 minutes was the best case—when you happened to copy exactly the right data. Each engineer could spend several hours a week keeping test data current, including cloning pieces of production locally to chase down issues.

After switching to Databricks Lakebase Postgres, every pull request automatically gets its own branch of production data, connected to its preview environment. Douglass says when the preview deploys, the data is ready—they can test against production data and even write to it without touching production. Hui says now when they hit a bug, they have the exact data that caused it, and they can check the fix against that same data.

Connexion / Inscription
LectureRechercheRadarCadre d'investissement

But what truly changed the workflow was not the saved minutes. Hui says branching makes their workflow a much better fit for AI coding agents. Each pull request is isolated from production; they give an agent like Claude or Codex access to its branch and let it run its own checks. The agent runs the data pipelines to completion and looks at whether the change does what it should. Every pull request gets that first pass from an agent. By the time a person looks at it, they are already fairly confident it works. A human still approves the merge, but more and more of the rest is automated.

The prerequisites of this workflow deserve attention: the agent needs an isolated, complete environment containing real data to run end-to-end pipelines and judge results on its own. If the data is synthetic or stale, the agent's verification does not equal verification against real scenarios. Hui stated a similar principle when discussing video speaker identification—

You can't hand a model a video and hope for the best. You have to collect everything around it that helps it make the right call.

For coding agents, the surrounding information is that real data.

It should be noted that this is a customer interview published on the official Databricks blog. Douglass and Hui describe their own team's actual practices; the time savings are self-reported figures without a stated measurement method. Hamlet is a small team, and whether their workflow applies to larger teams or different technology stacks is not discussed in the original.

Sources

  • databricks.com↗
Sujet

Hamlet市政数据AI

【背景】美国地方政府数据长期处于碎片化状态,19,000个城市政府网站互不兼容,导致公众和开发者难以获取有效的决策依据。Hamlet是一家总部位于旧金山湾区的AI驱动平台,旨在通过索引全美7,200多个立法机构的会议记录,将非结构化的视频和…

5 étapes1 piècesMis à jour 2026-10-21 14:53

Comment on en est arrivé là

  1. 2022-01-01Sunil Rajaraman创立Hamlet,起因于竞选Orinda市议会时遭遇的地方数据获取困难。glennelson.org ↗
  2. 2025-06-11Databricks发布Lakebase,Hamlet随后采用其Postgres分支功能优化AI代理开发流程。databricks.com ↗
  3. 2026-10-03Glen Nelson Center通过Horizon Fund对Hamlet进行早期投资,支持其作为新闻基础设施的发展。glennelson.org ↗

Ce qui reste non résolu

  • Hamlet在从B2B转向B2C免费服务后,其商业模式的可持续性如何平衡?
  • AI说话人分离技术在处理口音重、音质差的基层会议录音时,错误率是否会影响法律或政策引用的准确性?
  • 随着覆盖范围扩大,Hamlet如何应对不同州对公共数据隐私和版权的法律差异?
Lire le sujet complet →
Continuer la recherche →