SShortSingh.
Back to feed

Postgres Creator: LLMs Achieve 0% Accuracy on Real Enterprise Database Queries

0
·4 views

Turing Award winner and Postgres creator Mike Stonebraker has claimed that large language models score 0% accuracy when tested on real-world production data warehouse queries, far below the 80–85% figures reported on popular benchmarks like Spider and Bird. Speaking on the Data Renegades podcast, Stonebraker explained that standard benchmarks use clean, simple datasets that bear little resemblance to the complex, idiosyncratic schemas found in actual enterprise systems. He identified four core reasons for the gap: enterprise data is absent from LLM training sets, real queries are far more complex, production schemas are messy and inconsistently named, and companies use domain-specific terminology that models have never encountered. To support his findings, Stonebraker released BEAVER, an anonymized benchmark based on four real data warehouses, urging AI researchers to test their models against realistic data. He drew a parallel to past tech hype cycles, warning that AI vendors may be shipping demos of capabilities that do not yet function reliably in production environments.

Read the full story at DEV Community

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

Log in to join the discussion and vote.

Log in

Related stories

0
ProgrammingDEV Community ·

Solo Developer Bootstraps Three Live Data Platforms With No VC Funding

Developer Heshan has independently built and launched three production data platforms over two years without venture capital or a team. The platforms include Social Intel, a social data enrichment tool using a deterministic pipeline; Pulse Aggregator, a news aggregation service with a four-tier fallback system maintaining 99.9% uptime; and GoodQuote Scraper, a structured Goodreads data tool. A fourth platform, FinPull, targeting traders and financial analysts, is currently under development. The projects rely on a self-assembled tech stack including FastAPI, PostgreSQL, Playwright, and Next.js, deployed on Vultr and Vercel. Heshan credits iterative, failure-driven learning and resilient system design as the core lessons behind each product.

0
ProgrammingDEV Community ·

Developer proposes compile-time Go dependency injection tool with Fx-style API

A developer has released an experimental dependency injection framework for Go called 'dig', hosted on GitHub. The tool aims to combine the ergonomic API style of Fx with the code-generation approach of Wire, resolving dependency graphs at compile time via 'go generate'. Unlike runtime DI frameworks that use reflection and catch errors only at startup, this approach eliminates the need for a DI runtime in the final application. The project is designed to explore what a more idiomatic Go dependency injection workflow could look like. The developer has invited community feedback on whether compile-time or runtime DI is preferred for large-scale Go projects.

0
ProgrammingDEV Community ·

EE Student Launches Blog Series to Simplify Digital Logic Design Basics

An electrical engineering student has started a blog series aimed at filling the gap in beginner-friendly resources on Digital Logic Design (DLD). After spending months searching for accessible blogs and repositories on the subject, the student decided to create the content themselves. The series will cover several concepts daily, drawing from two textbooks: Digital Design and Computer Architecture (RISC-V Edition) by David Harris, and Digital Logic and Computer Design by M. Morris Mano. The first planned topic is number base conversions, considered a foundational concept before diving into DLD. The initiative is self-driven and targets beginners who struggle to find approachable learning material on the subject.

0
ProgrammingDEV Community ·

Fixzi.ai Launches All-in-One JSON Toolkit to Streamline Developer Workflows

Fixzi.ai has released a suite of JSON utilities aimed at reducing the need for developers to juggle multiple single-purpose tools. The toolkit includes a JSON Validator, JSON Diff tool, Schema Generator, Schema Validator, and converters for both TypeScript and XML. Each tool targets a common pain point in API development, from catching syntax errors to maintaining API contracts in production. The platform's goal is to consolidate everyday JSON tasks into a single, ad-free workspace. The team says it plans to continue expanding the toolkit and is soliciting feedback from developers on which utilities to build next.