Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Meet MariaDB 10.2/10.3 by Ian Gilfillan

7b0645f018c0bddc8ce3900ccc3ba70c?s=47 Pycon ZA
October 05, 2017

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.

7b0645f018c0bddc8ce3900ccc3ba70c?s=128

Pycon ZA

October 05, 2017
Tweet

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?