Android Room database created 3 files including -shm and -wal files

Viewed 837

I have created a database using Room database library with name ImageDatabase, when I opened my Device File explorer in Android studio inside the database folder there were three files with names ImageDatabase, ImageDatabase-shm and ImageDatabase-wal. I wanted to know what are these files meant for? Any help would be great Thanx All

2 Answers

The data in your database is contained in all three. The one with no extension is the main database. The others are the Write Ahead Log file (-wal) and the Shared Memory file (-shm). They are used by the underlying SQLite system to improve performance, and contain the latest changes to the main database until a checkpoint is done. You can find more information in the SQLite docs.

Your original database is ImageDatabase i.e name of database you give at the time of creation. you can copy database and check the contain from here upload your database in above link and you can verify it.

Related