Meet MariaDB 10.2/10.3 by Ian Gilfillan

MariaDB 10.2 is the current stable release, and MariaDB 10.3 the current development release. This talk introduces some of the new features that may be of interest to Python developers, in particular Window Functions and Common Table Expressions (CTEs). Window functions are similar to aggregate functions in that they perform calculations across a set of rows. Recursive CTEs are excellent for navigating a tree structure, or a route map, which regular SQL is poor at.

By making use of these features. more work can be passed on to the database layer, simplifying the code and improving performance.

Transcript

1. Meet MariaDB 10.2/10.3 Ian Gilfillan MariaDB Foundation
2. MariaDB is a fork of MySQL
3. MariaDB Foundation MariaDB Corporation
4. MariaDB 10.1 • First stable Oct 2015 • Galera • Encryption • Page compression • Roles • GIS improvements • Debian 9 Stretch
5. MariaDB 10.2 • First stable May 2017 • MyRocks • Flashback • Window functions • Common Table Expressions • GeoJSON / JSON • XtraDB → InnoDB
6. Window Functions (Also aggregate) • • COUNT • SUM • AVG • BIT_OR • BIT_AND • BIT_XOR
7. Regular Aggregate Function
8. Aggregate Function as Window Function
9. Window Functions (New) • ROW_NUMBER • RANK • DENSE_RANK • PERCENT_RANK • CUME_DIST • NTILE
10. Window Functions Example
11. Common Table Expressions
12. Recursive Common Table Expressions Example
13. Recursive Common Table Expression – Paths
14. MariaDB 10.3 • First alpha released in April • Oracle compatibility • Sequences • INTERSECT and EXCEPT • Idle transaction control
15. UNION, EXCEPT and INTERSECT
16. Sequences
17. Learn more • Foundation website: mariadb.org • Code: github.com/mariadb/server • Documentation: mariadb.com/kb • Bugs: jira.mariadb.org • IRC: #maria on Freenode • Mailing list: maria-discuss@lists.launchpad.net Questions?