Skip to content
Programming

Database Optimizers Still Struggle With Join-Aware Materialized View Rewrites

tldr / data 20h ago 5

Query rewrite engines can dramatically speed up databases by routing queries to precomputed materialized views, yet many optimizers hit a blind spot when joins are involved. This article examines the join-aware rewrite gap and why current systems struggle to substitute joined tables with applicable views. Closing this blind spot could deliver faster analytical queries without requiring developers to change their SQL.

Read full article →

More Programming

OpenAI Ships Million-Line Product Written Entirely by Codex Agents

hackernews / top 1d ago 9

OpenAI details building and shipping a full product with zero manually-written code using Codex agents, achieving roughly 10x speed and redefining engineering as steering rather than coding.

Study Reveals Code Review Devours 60% of Tokens in AI-Driven Software Development

hackernews / top 1d ago 8

Study finds AI agent code review consumes 59% of tokens in software engineering workflows, revealing hidden costs lie in refinement rather than generation.

The $1,000 Secret Behind Your $100 AI Coding Subscription

tldr / ai 20h ago 8

An in-depth experiment with Claude Code reveals that heavy AI-assisted programming consumes tokens worth over $1,000 monthly at API rates, suggesting current consumer AI subscriptions are heavily subsidized and economically unsustainable for serious use.