Anselm Lingnau

The database now has the current version of MiniCribs. There were some minor problems with the update process that needed to be sorted out, most of which had to do with the Django 1.7 update, and that resulted in a fairly long delay. But I hope that future updates will proceed a lot faster!

The automated import process manages to connect approximately 97% of the 4500+ cribs to the corresponding dances in the database. The vast majority of the remaining cribs belongs to dances that we don't yet have in the database; we're working on getting these added, and at that point they will hopefully also be imported correctly.

database

· · Posted by Anselm Lingnau · 13 February 2015 14:37 (last edited on 13 February 2015 14:38)

Anselm Lingnau

Videos for dance lists are back! In the Strathspey SCD Database, You can now select the “Videos” tab on a dance list detail page and see videos for all the dances that have them.

Generally, the video shown for a dance is the one with the highest quality level. If there are several videos at the highest quality level for that dance (e.g., several “Good” ones when no “Demonstration quality” video exists) then one of those is chosen at random.

Eventually we want to introduce an “Editor's Pick” badge where we explicitly designate one of the available videos as the preferred one to be used in contexts like the dance list “Videos” tab.

database

· · Posted by Anselm Lingnau · 1 February 2015 15:50

Anselm Lingnau

Dance lists in the database now are no longer automatically made “active” when they are edited. Instead there is a “Make List Active” button near the “Edit List” button on a list's detail page which you can use to make a list active.

The “active” list is the one that gets dances added to it via the “Add to List” button on a dance's detail page. If you create a new list that list is still implicitly made active; the only change is that editing a list doesn't make that list active.

The reason for the change is that I'm looking through previous class logs to find dances for our upcoming ball – which if the ball list is active is easy because you can click on a dance and from its detail page add it to that list. However, if for any reason you edit a previous class log (e.g., to make it public) then that list used to become active, so you had to go back to the ball list to make that active again, etc., which was annoying.

Note that you can edit a list whether or not it is active, so you don't need to make it active just to edit it. Also note that you don't need to explicitly make list A inactive before making list B active.

database

· · Posted by Anselm Lingnau · 24 November 2014 14:39

Anselm Lingnau

In the database, complex search operations for dances or recordings will now try to handle articles automagically. This means that if you're searching for something like “The Reel of” this used to return nothing because the database stores articles at the end of the title, as in “Reel of the 51st Division, The”. This change means that if a name query starts with an article, the database now also searches for titles with the article at the end (in effect, for a search for “The Reel of”, the database will also return titles matching the regular expression “^Reel of.*, The$”). I hope that this will lead to more predictable results.

In many cases it may be more advisable to simply leave the article off. This is because if you're searching for recordings for “A Trip to Bavaria” you will be missing a few recordings that are titled simply “Trip to Bavaria”.

database

· · Posted by Anselm Lingnau · 12 November 2014 18:26

Anselm Lingnau

Here's another innovation for you: Dance lists may now have dates! With hindsight this is something that I should have added ages ago (but didn't because, reasons). What this gives you in the short term is the capability of specifying the date that a dance list applies to (e.g., the date the class took place, or the date the function is going to be at). The date of a list is displayed on its details page as well as on list overview pages, and list overview pages allow you to restrict the lists shown to a specific (possibly open-ended) date range.

This should make it more convenient to find dance lists for specific functions. There are a few other neat and useful ideas that we could use the dance lists for, so stay tuned.

I have added dates to most of the dance lists that had something resembling a date in their names. You may want to check whether these are correct for all your lists; the process was a little quick and dirty and I may have missed some corner cases.

database

· · Posted by Anselm Lingnau · 5 November 2014 18:48 (last edited on 5 November 2014 18:50)

Anselm Lingnau

I just deployed the long-awaited (or long-feared?) extreme makeover of the SCD database user interface. This should now be more in line with best web design practices for the year CE 2014, and work better not just on PCs, but also on devices with small screens (mobiles).

There are a few small glitches to sort out (mostly to do with videos) and I'll take care of those ASAP – I wanted to get the bulk of the update out in preparation for my talk at the RSCDS Teachers' Conference on Friday.

The changes confine themselves mostly to the appearance of the site; there has been only one significant change to its underlying workings, and that concerns dance lists. Formerly, users would have an implicit dance list (called “WORK”, with asterisks around it, if it showed up anywhere) which would receive dances through “drag and drop”, and could then later be edited and saved as a “named” dance list. The drag-and-drop interface looked neat at first but proved to be problematic in various respects, and has therefore been removed. Right now there are only “named” dance lists, and therefore to start a new dance list you need to create an empty one from the dance list overview or “My Dance Lists”. The most recently created or edited dance list is considered “active”, and if you click on the “Add to List” button on a dance's page then that dance will be added to the “active” list. I hope this avoids problems like the one where if you had the “WORK” list open for editing in one tab and then dragged a dance on it in another tab that didn't show the very latest version of the list as per the editing screen, your edited version would be obliterated :^( (If you edit your active list in one tab and then add a dance to it in another, you still need to re-load the list in the “editing” tab, but you won't lose any dances anymore.)

Do let me know if you notice any problems, or have suggestions for further improvement!

database

· · Posted by Anselm Lingnau · 4 November 2014 12:26 (last edited on 4 November 2014 12:27)

Anselm Lingnau

I just fixed a bug in the database that in some cases – mostly solo artists and newly-added bands – prevented albums and recordings from being credited to the respective artists on their »Person« pages. Thanks to Heiko Schmidt and Eric Ferguson for bringing it to my attention (with some persistence).

database

· · Posted by Anselm Lingnau · 22 May 2014 14:19

Anselm Lingnau

Eric's cribs are now imported correctly (some were missed because of a change in the source data format, instead being made part of the preceding crib). On top of that we now distinguish between »checked by Eric himself« and »checked by somebody else too«.

This is in the aftermath of the dance-intensity debate as per this thread on the Strathspey list, which introduced »per-turn« dance intensity in addition to Eric's »per-dance« dance intensity.

database

· · Posted by Anselm Lingnau · 1 May 2014 1:28

Anselm Lingnau

Version Q of Eric's SCD Cribs has now been imported into the database (thanks Eric!). I'll see what I can do about the EPUB and Kindle e-book versions but don't hold your breath.

database

· · Posted by Anselm Lingnau · 24 April 2014 14:17

Anselm Lingnau

I just posted a rough to-do list for the database. As the list itself says, there are no guarantees that any of the items of the list will actually ever be tackled, nor should the position of items within the list be construed as any kind of priority ordering.

database

· · Posted by Anselm Lingnau · 24 April 2014 14:15 (last edited on 24 April 2014 14:18)

See more stuff