In FireBase Data stored/processed in a cloud. MySQL is a relational database management system (RDBMS). SQLite is local database on Android device (data stored/processed on a device) with SQL interface. FireBase is suitable for real time applications.
Read moreIs Firebase relational or NoSQL?
Architecture: Firebase is a NoSQL database that stores and syncs data in real-time (a real-time document store); MySQL is an open-source relational database management system based on the domain-specific language SQL.1 Ara 2020
Read moreDoes Firebase have a SQL database?
Firebase is a real-time object store. It is not a SQL database and is not intended to be a replacement for one. It completely lacks mechanisms such as JOINs, WHERE query filters, foreign keys, and other tools relational databases all provide. … But any attempt to treat it “like” a SQL replacement is going to fail.
Read more