last played column

[naught101]

Could we have a "last played" column in the library? Just with the date and time of last play.

[Daniel Schürmann (daschuer)]

https://github.com/mixxxdj/mixxx/pull/974

[RJ Skerry-Ryan (rryan)]

Due to lack of progress, marking Triaged and clearing assignee. Feel free to revert if it is in fact still in progress :).

[Owen Williams (ywwg)]

I might resurrect this (for 2.4), it would be super useful to sort a crate by "last time played"

[Owen Williams (ywwg)]

so after reading the discussion on the pull request, it sounds like:

* on startup, we blast through the history playlists and build a temporary table of track id and last played time
* when building the basetrackcache (?), we get last played times from that table and pair it with the rest of the data for the track so that I can have a TrackPointer->getLastPlayedTime call
* when a history playlist is updated, we update the temporary table and base track cache

creating the last played table is quick and easy:

SELECT
  track_id,
  MAX(pl_datetime_added)
FROM
  PlaylistTracks
WHERE pl_datetime_added != ""
GROUP BY
  track_id
;

Regenerating values for updated trackids is similarly super fast, so we don't need to have any complex logic -- the db does all the work.

I'm not sure how to join the temporary last-played table with the base track cache though. It looks like the last played time should be in track.h somewhere? Or do I have to do a custom in-memory table for the whole library and every crate? I forget how data is set up so it populates the views.

[Owen Williams (ywwg)]

Should it be part of the library_cache_view created in mixxxlibraryfeature.cpp?

[Be (be.ing)]

Launchpad isn't a great medium for in depth discussion. Do you want to start a Zulip topic on this?

I'm wondering if it might be a good idea to explicitly track each timestamp a track is played in the database.

[Owen Williams (ywwg)]

huh, somehow it works automatically! good enough I guess.

[Owen Williams (ywwg)]

One thing I don't like about Zulip is that discussions and decisions disappear in the noise, whereas bugs and PRs are more easily referenced, bookmarked, and tracked.

We already record each timestamp in the history playlists so that information already exists. I'm not sure how that affects this specific feature request.

[Owen Williams (ywwg)]

https://github.com/mixxxdj/mixxx/pull/2670

[Be (be.ing)]

https://github.com/mixxxdj/mixxx/pull/3140
https://github.com/mixxxdj/mixxx/pull/3457

[Swiftb0y (swiftb0y)]

Mixxx now uses GitHub for bug tracking. This bug has been migrated to:
https://github.com/mixxxdj/mixxx/issues/8211