Hmmmm, I’m having a problem when I try to follow your recommendation, I get this strange behaviour:
# ls -las /opt/var/mt-daapd
4 drwxr-xr-x 2 guest root 4096 Jan 27 23:11 .
4 drwxr-xr-x 3 root root 4096 Jan 18 07:15 ..
34220 -rw-r--r-- 1 guest everyone 34999296 Jan 27 23:11 songs.db
20 -rwxr-xr-x 1 guest root 18139 Jan 21 11:33 songs.gdb
# sqlite /opt/var/mt-daapd/songs.db
sqlite: No such file or directory
I also installed midnight commander, but I cannot run it, I get the same thing.
# mc
mc: No such file or directoryEDIT:
Found the problem, I think /opt/bin is not in my path, doing
# /opt/bin/sqlite /opt/var/mt-daapd/songs.db
SQLite version 2.8.16
Enter ".help" for instructions
sqlite> create index idx_artist on songs(artist)
...>
so I guess it is creating the index now