about summary refs log tree commit diff
path: root/tools/mpd-stats/internal/scrobbler/db.go (follow)
Commit message (Collapse)AuthorAgeFilesLines
* scrobbler: record how long a song was playedFranck Cuny2022-06-111-0/+1
| | | | | | | | Add a column `playtime` to the records table to keep track of how long a song was played. With this information, in the future, we will be able to sum up how long we listen to music, but also which songs were skipped.
* scrobbler: add interface to the sqlite3 databaseFranck Cuny2022-06-111-0/+54
We want to persist the records in a database, so we can extract statistics and an history. The module for the database is straightforward: it opens the database if it exists and return an handler to it. If the database does not exists, we create it and we create the only table we need (records).