http://www.bbc.co.uk/blogs/radiolabs/2008/09/taking_the_proms_to_the_semant.shtml en-gb 30 Wed 30 Dec 2009 14:33:05 GMT+1 A feed of user comments from the page found at http://www.bbc.co.uk/blogs/radiolabs/2008/09/taking_the_proms_to_the_semant.shtml http://www.bbc.co.uk/blogs/radiolabs/2008/09/taking_the_proms_to_the_semant.shtml?page=16#comment5 Hi KarlI intend to make the rails code available for download from the site. However, I'm not the world's greatest coder so I'm not sure it will contribute much to the world.On the associations question I tend not to use either HABTM or HMT. I've found that adding these associations tends to make me lazy in views and I end up with pages using 100 queries when one will do. I try to write a maximum of two queries a page: one to get the thing, one to get the things under the thing. Although I have broke this on work listing pages (http://bbc-hackday.dyndns.org:2840/works/a-z/a) where there's a separate query for each work to get the composer(s). Since a work can have many composers and each composer has many fields that make up their display name, I haven't been clever enough to work out a better query. It does make these pages very slow!Anyway, in general I like to be able to see my sql and find associations hide it and make me laz(y|ier).Hope this helps. Code will follow when the application has some semblance of shape.Michael Sat 27 Sep 2008 08:24:55 GMT+1 http://www.bbc.co.uk/blogs/radiolabs/2008/09/taking_the_proms_to_the_semant.shtml?page=13#comment4 hi michael,by incident I also work in radio systems engineering (for orf.at, national public radio in Austria), and also program in rails around some database acces (radio drama, in my case). any chance that not only the concert data, but also your ruby code could be available in the public domain? btw, I really like incremental progress update, just like I program in rails (one table a time, adding associations).another question: from the table naming (plurals, alphabetically) I assume you use "HABTM" in contrast to "has many :trough" for the relationships, any reason to do this (as it seems has_many :through has no disadvantages but could offer the chance for extension fields to the relationships)?thank you so much for sharing publicly,karl. Thu 11 Sep 2008 19:02:12 GMT+1 http://www.bbc.co.uk/blogs/radiolabs/2008/09/taking_the_proms_to_the_semant.shtml?page=10#comment3 @trampus - thanks for spotting. is fixed now. must learn to type one day ;-) Sun 07 Sep 2008 12:56:43 GMT+1 http://www.bbc.co.uk/blogs/radiolabs/2008/09/taking_the_proms_to_the_semant.shtml?page=6#comment2 Michael,Congrats. It's an excellent achievement.But... you do yourself short with a typo on the homepage:"1985" should read 1895 surely?best,Trampus Sun 07 Sep 2008 09:32:12 GMT+1 http://www.bbc.co.uk/blogs/radiolabs/2008/09/taking_the_proms_to_the_semant.shtml?page=3#comment1 Hi metanoize*none* of the links would have worked between 8pm and 9pm because I was redeploying the application. Apologies. Is back now.If you want to know when the app is down and when new features are added please follow @historicalproms on twitter:https://twitter.com/historicalproms/ Sat 06 Sep 2008 20:15:25 GMT+1 http://www.bbc.co.uk/blogs/radiolabs/2008/09/taking_the_proms_to_the_semant.shtml?page=0#comment0 Some links don't workhttp://www.bbc.co.uk/go/blogs/radiolabs/2008/09/taking_the_proms_to_the_semant.shtml/ext/_auto/-/http://bbc-hackday.dyndns.org:2840/images/domain_model.png Sat 06 Sep 2008 19:36:21 GMT+1