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, MariaDB
Biography: 
Colin Charles works on MariaDB at SkySQL. He has been the Chief Evangelist for MariaDB since 2009, work ranging from speaking engagements to consultancy and engineering works around MariaDB. He lives in Kuala Lumpur, Malaysia 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 on the conference track having spoken at many of them over the course of his career.