Not a problem, but how to query play count

[r0bis]

It would be great to know which songs are played more often. Is there a field in the database that reflects play count? If not, maybe I could think how to implement it. Where is the sqlite database kept? Thanks

[237dmitry]

You can use sqlite3 to read the play_count values ​​for tracks. But I'm not sure if they are accurate.

$ pushd ./.config/musikcube/1/
$ sqlite3 ./musik.db
SQLite version 3.49.1 2025-02-18 13:38:58
Enter ".help" for usage hints.
sqlite> .table
albums                   meta_values              track_genres
artists                  paths                    track_meta
directories              playlist_tracks          tracks
extended_metadata        playlists                tracks_view
genres                   replay_gain              version
last_session_play_queue  thumbnails
meta_keys                track_artists
sqlite> select play_count from tracks_view where filename='/data/Music/Accept/1983. Balls To The Wall/01 - Balls To The Wall.flac';
0
sqlite>

Out of 6000 tracks in the music library, only 20-30 have a play_count not equal to 0
But it could be because I changed the root directory of the music library and the old data was simply rewritten.

Try to export data to file to read it (from bash):

$ echo "select play_count, rating, filename from tracks_view" | sqlite3 musik.db > ~/Desktop/report.txt

[dmt-hub]

Would be nice if there was an option to show the play count in a column (like star rating) - which could be turned on or off in the settings file.