I am curious to know, if firebase uses SQLite under the hood to save its data for offline use or it creates a file saving the data or anything else?
On Android the Firebase Database client uses a SQLite database for its disk based persistence. There is no documentation on this however, as it's seen as an implementation detail that you should not rely on.