last played column

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

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

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

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.

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

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.

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

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.

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

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

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