⚡ Query Optimization - ghosh.debasish · Scour

Query Optimization and Evaluation via Information Theory: A Tutorial 📦Succinct Data Structures

arxiv.org·3d

Build SQL Queries Without Writing SQL 🛢️Database Internals

dbcode.io·2d·DEV

Why Search Breaks in Production 🛢️Database Internals

searchplex.net·13h·DEV

PostgreSQL REST API from SQL Scripts 🛢️Database Internals

npgsqlrest.github.io·2h·Hacker News, r/PostgreSQL

Pre-Compiled Filter Sets and Query-Time Specialization in Temporal Databases 🎲Probabilistic Data Structures

blog.minns.ai·2d·r/rust

The acyclic e-graph: Cranelift's mid-end optimizer 🖥️Systems Programming

cfallin.org·9h·Lobsters, Hacker News, r/rust

Optimize full-text search in Amazon RDS for MySQL and Amazon Aurora MySQL 🛢️Database Internals

aws.amazon.com·3d

SQLite 3.53 Fixes WAL Corruption Bug, Adds New SQL Features 🛢️Database Internals

linuxiac.com·17h

Introducing Metrics SQL: A SQL-based semantic layer for humans and agents 🛢️Database Internals

rilldata.com·1d·Hacker News

The Index: Issue #177 ∑Math

piccalil.li·1h

Many-objective optimization of fuel cell flow channel with triangular baffles based on many-population many-objective gray wolf optimizer 🌊Streaming Algorithms

sciencedirect.com·22h

STARBURST ENTERPRISE PERFORMANCE TUNING 🛢️Database Internals

tshasankda.substack.com·1d·r/programming

BigQuery Scheduled Queries for GA4 Automated Reporting 🛢️Database Internals

paolobietolini.com·4d

chessstetson/rechunk: interactive rechunking for augmented indexing 🗄️Vector Databases

github.com·21h·Hacker News

Ken: An Execution Engine for Unstructured Database Systems 🛢️Database Internals

vldb.org·1d

I built a benchmark for MCP tool use and the most important fix wasn't the math. It was the error messages. 🖥️Systems Programming

euclidtools.com·11h·r/mcp

Semantic Layer vs. Text-to-SQL: 2026 Benchmark Update (11 minute read) 🛢️Database Internals

docs.getdbt.com·3d

Article: Building Hierarchical Agentic RAG Systems: Multi-Modal Reasoning with Autonomous Error Recovery 📚RAG

infoq.com·1d

Using R to Teach R: Lessons for Software Development 🧪Property-based Testing

r-bloggers.com·13h

Building a Text-to-SQL Agent with DuckDB, MotherDuck and LangChain 🛢️Database Internals

motherduck.com·1d·r/Python

Loading more...