Technology comparison: MySQL vs SQLite on various devices
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
Performance consultant, Astellar
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
Co-Founder and CEO, Altinity
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.