Someone recently asked me to add a feature that shows when a song was added to the music4dance catalog. It turns out this feature already exists, but the fact that this person didn’t realize it means it isn’t as obvious as it should be. This is especially true, given that the questioner demonstrated she was a fairly sophisticated user of the site through other questions and comments in the same thread.

I have some ideas for how to expose this functionality, but I’d like your feedback before I dive in. I’d also like to get a sense of how interested you are in this information and how you’d like to use it.

What I have:

I’ll start by mapping out what I’m keeping in the database. In my internal format, I keep a record of every time a song is changed, including who made the change and (of course) what the changes are. It is too expensive to index all this information, so it is available on the song’s detail page, but only a few things can be quickly looked up for filtering and sorting the song list. These are as follows:

1. The date that a song is originally added to the database
2. The most recent date on which the song was modified (including by the system)
3. The most recent date on which a song was edited by a user
4. The most recent date that someone took the time to enter a written comment on the song

What you can do with it:

The easiest way to use this information (other than looking at the change log on the song’s details page), is to go to the New Music page. This will let you see the most recent songs based on when they were added, changed, or commented on. I find this useful as a quick check to see whether people (and bots) are successfully adding and making changes to songs. If the things at the top of the changed list are more than about a day old, it’s a good indication that I broke something. I also think this is good for users who are looking for new music to see what’s up – but now that I’m looking at that page with fresh eyes, I feel like it could benefit from filtering by dance style, like the Holiday Music and other similar pages.

To go to the next level, you can open the Advanced Search page and search/filter a song list any way you like, including by dance style, and then sort it by “When Added”, “When Modified”, “When Edited”, or “Comments.” Modified and Edited are subtle variations on Changed, which I’m not going to dive into here, but feel free to play with those and let me know if you think I’m just adding complexity for no reason.

In general, the last column in the desktop version shows information about the date you’re sorting on. The only indication I’m giving on smaller screens is the order in which the list is presented.

Where to go from here:

Between the original question and writing this post, I have had a number of thoughts about what I would improve. But please pause for a moment before you read on, as I’d like your ideas unpolluted by my ramblings.

• Add some indication of the sort-ordered date on mobile.
• Make the information that is shown about songs in the search results list configurable – possibly separately for mobile and desktop (this one would be part of a larger project).
• Add dance filtering to the New Music page. And/Or add an “advanced search” button to those pages that pre-populates the advanced search form.
• Distinguish between Modified and Edited on the New Music page.
• Provide the option to view the full edit history on the song details page.
• Add the ability to filter between two dates for any of the indexed date types (e.g., I want to see all cha-chas that were added before 2015)

Publication date of a song:

When I first read the message that prompted this post, I thought I was being asked to show the date the song was published. That’s a question that I’ve been asked quite a bit, and the answer is that it’s harder than it seems. In general, people are asking for the date the song was first released as a single or on the first album it appeared on. But since the data I have access to is often a “Best Of” or “Ballroom Mix” album, and the date I can see is the album’s, not the song’s, I haven’t figured out a way to reliably get the information we want. This may be a matter of hooking up to another music database like MusicBrainz, but that’s a pretty big lift, so it’s not part of my immediate plans.

However, I have used various sources to tag songs with the decades they’re associated with; this is more of a fuzzy style idea than anything to do with the song’s release date, but that’s often what I want: 70’s Cha Cha or 50’s Slow Foxtrot.

---

As always, please let me know if you have any thoughts about the subject of this post or the site by commenting below or using other feedback mechanisms listed here. And if you enjoy the site or the blog (or both), please consider contributing in whatever way makes sense for you.