#Query

A useful pattern for LLM classification at scale is to let it hallucinate plausible, fake entities. Then resolve to real ones.

Discover what's new in pg_clickhouse v0.10.0: 16 of 22 TPC-H queries now push down in full, plus a rebuilt C driver and broader aggregate support.

Last week we released version 0.2 of pgrust. This release was all about performance. It’s 10x faster than the previous version of pgrust. On OLTP benchmarks, pgrust is 30% faster than Postgres, and on Clickbench, Clickhouse’s benchmark for analytical…

AI helping pharmaceutical researchers query decades of information buried in PDF reports

Walk through DuckDB's internals: how it skips serialization overhead, parses and optimizes SQL, and stores data in columnar row groups with zone maps.

This specification defines the QUERY method for HTTP. A QUERY requests that the request target process the enclosed content in a safe and idempotent manner and then respond with the result of that processing.…

Postgres 19 brings plan advice: the query hints the Postgres community held off on for 15 years. Shaun Thomas covers the 15-year debate, pg_plan_advice, pg_stash_advice, and how to use them.

I helped redesign a large BigQuery-based enterprise data warehouse and cut spend by 57%. The biggest...

Reading the screenshots, diagrams and tables in technical documentation for LLMs

Stream Postgres to Apache Iceberg on S3 via logical replication, queryable over the Postgres wire protocol. - viggy28/streambed

How to manage state in modern frontend applications: a practical guide Frontend state...

I spent two weeks optimizing my database queries. The app got slower. Not marginally slower....

Every backend developer has done this at some point. A request fails. Something is not inserting...

Part of the "SQL: Zero to Ninja" series, written for junior web developers. Your boss asks: "Show me...

Six Eloquent query patterns that silently bypass MySQL indexes on large tables, with EXPLAIN output, the exact SQL each one generates, and the fix for each.

This post is part of the SQL: Zero to Ninja series. You built a login form. A user types their...

GraphQL vs REST: Choosing the Right API Style Picture this: you're building a mobile app...