#sql
5 discoveries · Hand-picked discoveries from the open web, newest first.
-
Ещё 6 SQL‑тренажёров для самостоятельной практики. Что посоветовали на Хабре
Что добавить в тестовую базу, чтобы увидеть ошибку в SQL-запросе? В шести тренажёрах из комментариев к прошлой подборке разбираю граничную цену, пустой офис, пассажиров с одинаковым числом перелётов и двух водителей по имени Саша. Разобрать шесть задач
Habr · RU
-
Postgres not using your index? It's counting pages, not rows
You get a Seq Scan even with an index because the planner prices a query in pages, and a small table is cheaper to read whole.
Hacker Noon · EN
-
Cloudflare Makes Basin Serverless Analytics Generally Available
Cloudflare has announced the general availability of Basin, a serverless analytics platform built on Apache Iceberg and R2 Object Storage. The managed service supports open data formats and integrates with tools such as DuckDB, Snowflake, and Apache Spark, with no data egress fees. By Renato Losio
InfoQ · EN
-
NOT IN vs LEFT ANTI JOIN: A Performance Comparison
When filtering data based on exclusion criteria, the choice between NOT IN and LEFT ANTI JOIN can significantly impact query performance. This post demonstrates why LEFT ANTI JOIN is typically the better choice.
桑弧蓬矢射四方 · EN
-
Beyond synthetic testing: Capturing and replaying real database workloads at Airbnb
How we capture real production database traffic at Airbnb and replay it offline to load-test, plan capacity, and de-risk upgrades. By: Zuofei Wang , Erluo Li Introduction At Airbnb, MySQL-compatible databases are a critical backbone of our online database infrastructure: a fleet of hundreds of clusters supporting thousands of use cases at millions of queries per second (QPS). Operating databases at scale brings hard problems, including sizing clusters for future growth, keeping behavior consistent across version upgrades and migrations, and reproducing production incidents well enough to debug
The Airbnb Tech Blog - Medium · EN