Percona Live: Data Performance Conference 2016 Logo

April 18-21, 2016

Santa Clara, California

Technology comparison: MySQL vs SQLite on various devices

Technology comparison: MySQL vs SQLite on various devices

 19 April 3:50 PM - 04:40 PM @ Room 209
Experience level: 
Beginner
Duration: 
50 minutes conference
Tracks:
Architecture/Design
Topics:
MySQL
Other

Description

Do we always need a full blown database for your project? When would be better to use embedded database? Would it be easy to move from SQLite to MySQL later on? How could you compare performance between MySQL and SQLite? You will get a sense of these technologies in this talk. Both MySQL and SQLite are from relational database world but they are different in many ways. How to choose the right technology for your project? Session agenda: - Key differences between client-server and embedded databases - Running MySQL and SQLite on various devices - Installation and configuration stage - Connecting and querying - SQLite and MySQL performance - Most common SQLite applications - Migration from SQLite to MySQL and back - Technologies pros and cons

Speakers

Vladimir Fedorkov's picture

Vladimir Fedorkov

Performance consultant, Astellar

Biography:

Vladimir has been helping people to scale their LAMP applications for more than 10 years, with a focus on performance optimization and operations for MySQL and Sphinx based systems. In the past he was worked with high-performance systems as a developer and team leader. In his off-duty time he enjoys traveling, bicycling and photography. Twitter: https://twitter.com/vfedorkov Facebook: https://www.facebook.com/vfedorkov

Peter Farkas's picture

Peter Farkas

Co-Founder and CEO, Altinity

Biography:

Previously, Peter built up and led Percona's MySQL Support business for four years, which provided the best MySQL Support service in the industry. Currently, Peter is the CEO of Altinity, where he has partnered with recognized experts in the open source database industry. Altinity is determined to make vendors of embedded systems more successful with open source embedded database solutions. Peter lives in Budapest, Hungary. In his free time, he enjoys reading books, particularly Peter Drucker and Roald Dahl. He also likes to experiment with microcontrollers and electronics.

Share this talk


Slides