query
34 stories and discussions about query, aggregated from every source we track.
The reason for and design of Krabby's query system.
After a user signaled a performance issue in a Matrix client, we have added new tracing timers in the Matrix Rust SDK to spot the problem. Once found, we have fixed an SQL query improving the throughput from 19k to…
Implementing an LSP from our query-based compiler passes
High-performance, AI-safe self-service analytics — a governed semantic layer fused with beautiful-by-default dashboards, for humans and agents.
Most of the time, you’ll hear advice that you should select as few columns as possible so that SQL Server can do less work. However, one of my clients hit a neat edge case scenario where SELECT * queries actually…
Write SQL. Keep TypeScript. Skip the query-builder translation layer. - Clickin/SQLBraid
Contribute to chrishayuk/larql development by creating an account on GitHub.
One lens I've found satisfying for "what is a query planner" is that it's a tool for "approximating domain knowledge." By that I mean, someone who knows...
Maximizing perf on AI-SQL queries with the KV-optimal left-deep join
OpenStreetMap data extracted into thematic layers and converted to cloud-native file formats that are easy to use with software from DuckDB to QGIS.
Kibana/ES CLI for logs. Contribute to hyzyla/kibana-agent development by creating an account on GitHub.
At Community.com, we had a problem where a bunch of workers needed to pick up and process a large amount of data fr…
How do Postgres providers handle a query that exhausts memory? A recursive query benchmark compares query failures and cluster survival across ClickHouse Managed Postgres, Cloud SQL, PlanetScale, and Amazon RDS.
Maximizing perf on AI-SQL queries with the KV-optimal left-deep join
How do Postgres providers handle a query that exhausts memory? A recursive query benchmark compares query failures and cluster survival across ClickHouse Managed Postgres, Cloud SQL, PlanetScale, and Amazon RDS.
Across 244 query shapes on identical servers, Oliver was 3.06 times faster than ClickHouse at the median, and it ran all of them in less time than ClickHouse took to load the data.
Master ClickHouse query optimization through architectural understanding. Learn why ORDER BY design can improve performance 100×, plus proven techniques for trillion-row millisecond queries.
How do Postgres providers handle a query that exhausts memory? A recursive query benchmark compares query failures and cluster survival across ClickHouse Managed Postgres, Cloud SQL, PlanetScale, and Amazon RDS.
When agentic sessions run to a million tokens with many sessions resident at once, the KV cache and the index that ranks it live in host memory, and the scan that ranks all n keys for a top-k step becomes the traffic…
Follow a SQL query through the router, across four Postgres shards, and back.
Your CI database picks different plans than production because its statistics differ. Inject production stats with PostgreSQL 18, or generate rows that carry the distribution. Here is how to tell which one you need.
Maximizing perf on AI-SQL queries with the KV-optimal left-deep join
Kicking the tires of jev for a very basic query understanding task