A Performance Comparison of SQLite and Firebase Databases from A Practical Perspective

Android is currently the most used mobile operating system all over the world. The two database management systems that Android officially supports are SQLite and Firebase. Android SDK provides built-in packages to let developers implement applications which store its data on these databases. At this point, it is necessary to reveal the performance comparison of these databases. For this reason, an Android application that evaluates several experiments which cover the most used data operations on these databases is implemented within this study. The experimental result indicates that SQLite provides better performance compared to Firebase except deleting data. The performance differences between SQLite and Firebase vary through (1) the type of data operation, and (2) the size of data that is managed