Episode 175 is up at bit.ly/oursql175
- We delve further into the CONNECT storage engine - remote tables is only a small part of what it can do. Now you can have easy pivot tables (and un-pivot too!), multi-threaded wrapper tables (think MERGE storage engine but more fully featured), easily parse comma-separated lists, get file info into a table, and more!
MariaDB needs to tout the CONNECT engine more, because it does SO much more than merely connect to remote storage engines (although it does that too!).