/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

 orib.dev
gefs
| | benjamincongdon.me
B-Trees: More Than I Thought I'd Want to Know | Ben Congdon
3.3 parsecs away

Travel
| | B-Trees are not boring, after all
| | rcoh.me
Postgres Indexes Under the Hood
3.6 parsecs away

Travel
| | Many software engineers use database indexes every day, but few of us really understand how they work. In this post I'll explain: How indexing works in Postgres using B-Trees What B-Trees are Why they are a good fit for this problem Indexes in Postgres Postgres actually offers 4 different kinds of indexes for different use cases. In this post I'll be focusing on the "normal" index, the kind you get by default when you run create index.
| | ordep.dev
What you should know about database storage and retrieval.
4.0 parsecs away

Travel
| | [AI summary] A transcript of a talk comparing log-structured storage engines like LSM-Trees with traditional B-Trees, discussing their architectures, performance trade-offs, and underlying data structures.
| | modern-sql.com
SQL LISTAGG concatenates values of multiple rows into an delimited string such as CSV.
23.2 parsecs away

Travel
| LISTAGG is the new SQL standard version of GROUP_CONCAT or STRING_AGG. LISTAGG supports DISTINCT and provides an ON OVERFLOW clause to control the behavior when exceeding the maximum string length.