SQLite - What are .acd, .ard and related file types?
The -wal and -shm files are used to store data when the DB is in WAL mode.

SQLite does not require any specific file name or extension. These file names are chosen by the program that created the database.