Databases

Everything I’ve written on Databases, newest first.

From the archive

Notes from my old blog on mohamedsharaf.net (2010–2018), rewritten and checked. Some are dated; the dates tell you how much.

1. Databases · 15 August 2018

   UUID_TO_BIN and BIN_TO_UUID for MySQL 5.6 and 5.7

   Store UUIDs in 16 bytes, time-ordered like MySQL 8, on older MySQL versions and Amazon RDS.

2. Databases · 8 November 2014

   Pivot rows into columns in MySQL, dynamically

   Turn key/value rows into one column per key when you don’t know the keys in advance.

3. Databases · 24 February 2013

   One big table or two identical ones?

   When two sets of data have the same structure, why one indexed table usually beats splitting them.

4. Databases · 5 December 2012

   How YouTube scaled MySQL in 2007

   Lessons from Paul Tuckfield’s keynote on keeping YouTube’s databases ahead of its growth.

5. Databases · 27 April 2012

   Create a view in MySQL

   Save a query under a name and use it like a table.