sql

Unlocking Faster Insights with Experimenter-Defined Segmentations

Published 2025-10-09 experimenters segmentation segmentations

Imagine you have a fabulous idea to drive more sales on Etsy by giving out free ice cream with every purchase. How would you know if it will actually work? One …

Testing SQL for BigQuery

Published 2020-10-16 bigquery queries spark

“To me, legacy code is simply code without tests.” — Michael Feathers If untested code is legacy code, why aren’t we testing data pipelines or ETLs (extract, tr…

How to write high-performance SQL for your Postgres database

Published 2023-09-29 citus lukas postgres

pgnanalyze helps users deliver consistent PostgreSQL performance and availability at any scale. Get started with a free trial or explore their docs . You can al…

凌晨时分，几十万亿资产开始对账：某国有大行为什么把托管核心换成 TiDB

Published 2026-11-11 sql oracle tidb

一套运行十余年的 Oracle 核心系统，管理着几十万亿规模的托管资产。它不能停、不能错，也不能因为数据越积越多而变慢。某国有大行用了三年多时间，将这套系统迁移到平凯数据库（ TiDB企业版）。项目的看点并非换上了一个国产品牌，而是银行在不中断关键业务的前提下，完成了一次底层架构换代。凌晨时分，大多数人还在睡觉，某国…

SQL with Jim Melton

Published 2009-06-05 arno melton concepts

In this episode, Arno talks to Jim Melton about the SQL programming language. In addition to covering the concepts and ideas behind SQL, Jim shares stories and …