thewayne: (Default)
[ETA: probably applies if you use Windows also, I just don't know how iTunes and iPhone/iPad apps update on that platform]


Well, you can if you want, but you need to be aware of what it means.

The update is is intended for iOS 11, which is due later this month when the new iPhones release, so you don't need it right now, and it REALLY changes one thing that's really important to me: app updates. In the brave new world, you will now have to open the App Store app on your device, click on Updates, then update individually or click on Update All. Personally I think this will greatly reduce the rate at which people update their apps.

Myself, I don't like this. I use iTunes every morning to refresh podcasts and update apps, then I resync my phone. All done. Now I still have to go through the iTunes process, but now I have to go through an additional process on my phone and iPad? And where is the phone/iPad backup stored in case I need to restore it from scratch, admittedly a rare procedure. I DO NOT want to store an iPhone backup in the cloud as that is something that could be made available to government, I want that backup on my personal computer.

I hope there's enough caterwauling that Apple backs off on this and re-integrates app updates in to iTunes. Maybe they will, maybe they won't. I'm definitely not happy with their decision.

Just be aware that the App page is no longer present in the new version of iTunes. Now I have to decide if I want to do a backup reversion on my laptop to get the old version of iTunes back.
thewayne: (Cyranose)
Even though I've been doing database for three decades, I've never really learned XML. I understand the basics of it, but I've never used it professionally. I knew iTunes kept its library in an XML database, and I understand its format, but I was never able to load it in to a database that I could manipulate.

Until this week.

I finally found some web pages that had code that would load a copy of your iTunes library in to SQL Server. Now the cool thing is that you can get a free copy of SQL Server from Microsoft, not that it's an easy thing to fool with.

Anyway, here's what I learned. This is my top played artists, clearly showing my musical roots to be firmly set in the '70s and '80s, drifting back and forth a bit. I do have newer groups, they just aren't played as much.

Unfortunately I can't get LJ to give me a monospaced font, so the play count is mashed to the left. *sigh*
Pink Floyd 855
The Beatles 813
Queen 764
Talking Heads 616
Paul Simon 569
Monty Python 523
Alan Parsons Project 474
Dire Straits 465
Weird Al Yankovic 463
Devo 424
Led Zeppelin 412
The Who 391
Supertramp 387
Fleetwood Mac 376
Electric Light Orchestra 344
Peter Gabriel 342
Antonio Vivaldi 329
Steeleye Span 310
David Bowie 307
Elton John 298
The Fabulous Forties Compilation 298
Thomas Dolby 288
Mark Knopfler 287
Johann Sebastian Bach 274
The Moody Blues 263

No surprise to me that Pink Floyd is #1, closely followed by The Beatles and Queen. In a permanent place on my iPhone is a few Floyd albums, specifically their latest and final album, Endless River, along with Animals, Dark Side of the Moon, and Wish You Were Here. These are my 'chill and code' things to play: very melodic and few words. I don't listen to the Beatles nearly as much as I used to, but I still dig them out occasionally. I expect Queen to overtake them at some point in the future.

This is my top-played tracks:
Name Artist PC
------------------------------ ---------------------------------------- -----------
Solsbury Hill (Peter Gabriel) 43
Afternoons & Coffeespoons (Cra (Eddie Bauer Collection) 42
Concerto No. 6 in C RV 180 (I (Antonio Vivaldi) 42
For A Rocker (Jackson Browne) 39
Uncle John's Band (The Grateful Dead) 39
Bad Moon Rising (Creedence Clearwater Revival) 36
Me and Julio Down By the Schoo (Paul Simon) 36
The Barry Williams Show (Peter Gabriel) 36
Concerto in G major alla rust (Antonio Vivaldi) 35
I Wish They'd Do It Now (John Roberts and Tony Barrand) 33
Loves Me Like a Rock (Paul Simon) 33
Dead Man's Party (Oingo Boingo) 32
Handel: Sonata G 2 violins & (Johann Pachelbel) 32
Ramble On (Led Zeppelin) 32
Stuck In The Middle With You (Eddie Bauer Collection) 32

The interesting thing is the way the count works. Afternoons & Coffeespoons by the Crash Test Dummies is technically the top played song, but Solsbury Hill tops it when you take in to account that it appears on two albums. I'm quite surprised at the Vivaldi and Handel: they don't appear in the iTunes list but crunching the numbers in SQL Server shows they belong. Knowing what I know about database as it is my profession, I'll accept the SQL Server numbers as more accurate.

If you're interested in the script and in crunching your own data, I can dig up the URL. I thought I had it with me but apparently I don't.

I listen to music pretty much all day long, I should repeat this in a year or so and see what changes have happened.
thewayne: (Default)
Basically when iTunes launched in Windows, (prior to the 10.5.1 update) it would send an unencrypted HTTP request. If you controlled someone's network upstream of their computer, you could intercept this request and proffer an "update" that was malware that could give the government all sorts of information that you might rather they didn't get, including the ability to listen to Skype conversations before they are encrypted.

Just the thing if you're living in an Arab Spring country.

The sad thing is that Apple was informed of this flaw in 2008. They fixed it last week.

It only affected Windows users of iTunes (and probably, by extension, Safari) as the Mac OS-X updater is a more secure subsystem.

http://www.h-online.com/security/news/item/iTunes-security-vulnerability-had-been-present-for-over-three-years-1384718.html

http://apple.slashdot.org/story/11/11/25/1343201/itunes-flaw-allowed-spying-on-dissidents
thewayne: (Default)
I've been downloading programming classes from Stanford for free off of iTunes, and came across this link of 30 tunes that you can download for the same price. I haven't listened to them all yet, but what I have listened to are a mixed bag: some good, some I'll be deleting.

Anyway, maybe you'll find some that you like.

http://itunes.stanford.edu/summermusicmix/
thewayne: (Default)
I occasionally do somewhat strange things in iTunes. I made a playlist of songs containing the word Love or Heart, I made one for our new Champions characters that was pretty cool, and now I have a new one: Dead.

It contains only musicians or bands that are dead or a member of said band has died.

At the moment it contains: B-52's, Beatles, Blues Brothers, The Cars, The Doors, Elvis, Grateful Dead, John Lennon, Ladysmith Black Mambazo, Led Zeppelin, Ofra Haza, Paul & Linda McCartney, Pink Floyd, Queen, Roy Orbison, Stan Rogers, Styx, Traveling Wilburys, and The Who.

Interestingly, it would appear that no member of Electric Light Orchestra has died.

And no, I don't own any Elvis records, but I do have a set of his songs covered by some rock greats, such as Robert Plant, The Pogues, Paul McCartney, Jesus & Mary Chain, and Bruce Springsteen.

I'm looking forward to hearing how this list works out, though I need to whittle it down: it's at 661 songs, 1.7 days of music, and 3.3 gig: it won't fit on my iPod as-is, gotta do some whacking.

June 2025

S M T W T F S
123456 7
891011121314
15161718192021
22232425262728
2930     

Syndicate

RSS Atom

Most Popular Tags

Style Credit

Expand Cut Tags

No cut tags
Page generated Jun. 10th, 2025 09:06 am
Powered by Dreamwidth Studios