MariaDB for Developers

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

Experience level: 
Intermediate
Duration: 
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.


Speakers

Chief Evangelist, Percona
Biography: 
Colin Charles is the Chief Evangelist at Percona. He was previously on the founding team of MariaDB Server in 2009, and had worked at MySQL since 2005, and been a MySQL user since 2000. Before joining MySQL, he worked actively on the Fedora and OpenOffice.org projects. He's well known within open source communities in APAC, and has spoken at many conferences.