NEW (MariaDB) SQL - Practical Examples of Modern SQL to solve harder problems - Daniel Black
Channel: FOSSASIA
Date: 2021-05-02

Slides: https://eventyay.com/e/fa96ae2c/session/6776

For those who have being SELECT and INSERTs for years, may not know that new SQL and server features have been added that make some problems ridiculously easy. This talk coves solutions for:

How to I probe SQL like its a graph?
How to generate a bus route, without going in loops
CTEs
Recursive CTEs
Recursive CTEs CYCLES RESTRICT
Bulk insert with and retreive auto generated columns
INSERT RETURNING
How to create a table will an included full version history of a table
System Versioned Tables - time
System Versioned Tables - transaction
System Versioned Tables - partitioning
How to store IP (internet protocol) data
IPv6 - INET6 Datatype
How to create a time reservation schema without double booking
Application Time Periods
Application Time Periods - without Overlaps