MariaDB for Developers

Developing Applications
4 April 3:00PM - 3:50PM @ Ballroom C

Experience level: 
50 minutes conference
MariaDB includes a lot of new features that developers can take advantage of. In this practical overview (this is not a hands on session - demos performed by the presenter), the attendee as a developer will learn to take advantage of the new MariaDB features over what is currently available in MySQL. Some highlights include: * Using microsecond precision & type, plus compatibility with MySQL's implementation * Using subqueries, and making use of the different optimizer * Using GIS, spatial types and getting your mapping needs * Using regular expressions with PCRE extensions * Using DELETE ... RETURNING * When do you use virtual columns? * How do you utilize dynamic columns, which are like blobs with handler functions? * Using various storage engines in your queries: SphinxSE for full-text search, connecting to a Cassandra cluster, making use of ODBC data sources via CONNECT, and automatic sharding in the database via SPIDER. If you are a MySQL expert, you will learn what differences MariaDB offers and how you can make use of these options in your deployment.


Chief Evangelist, MariaDB
Colin Charles works on MariaDB Server at MariaDB Corporation. He has been the Chief Evangelist for MariaDB since 2009, work ranging from speaking engagements to consultancy and engineering works around MariaDB. He lives to call Kuala Lumpur, Malaysia home (but has a travel schedule that says otherwise). He has worked on MySQL & its variants for over a decade. Before MySQL AB, he worked actively on the Fedora and projects. He's well known on the conference track having spoken at many of them over the course of his career.