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

Meet MariaDB 10.2/10.3 by Ian Gilfillan

Sponsored · Your Podcast. Everywhere. Effortlessly. Share. Educate. Inspire. Entertain. You do you. We'll handle the rest. →
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.

Pycon ZA

October 05, 2017

Transcript

17 slides

More Decks by Pycon ZA

Other Decks in Programming