/ domm

I hack Perl for fun and
profit.

Follow me on twitter!
Atom Icom ... on Atom!
<<<<<<<<<<
26.01.2006: CPANTS news
09.01.2006: Secret messages in YAPC::Europe city names
07.01.2006: Shut down the Internet
04.01.2006: laser in my nose
16.12.2005: Perl interface to Philips GoGear mp3 player

Two days ago I bought a Philips GoGear mp3 player. It's coming with 526MB flash which can be extended by a gig if you insert the right memory card. It has line-in with direct encoding and is using regular batteries (as opposed to built in custom ones, which all harddisk based player seem to use)

(side note: I ditched my old Sony MiniDisc recored in favour of mp3 because it's read/write head broke one week after the warranty ended and Sony wanted 89 euros for a repair. Suckers. (side side note: so my next notebook isn't going to be a Sony Vaio Subnotebook))

Anyway, this GoGear thing is quite decent, but it has one major drawback (as most players seem to have). It needs special software to load mp3s onto it. In this case, Windows Media Player. Yuck!

But some googling revelead that the player uses an SQLite DB to store metadata, and that one can fill this DB with other tools than WMP. Yay!

So after some looking at horrendous DB schemas like "CREATE TABLE artistTable (iArtistId INTEGER PRIMARY KEY,cArtistName VARCHAR(100))" I managed (instead of working in CPANTS) to hack together a small script that generates a nice and working database. Here it is!

It's lacking docs and tests, but is quite understandable, I hope. BTW, there's a python 'script' here that does the same (and a bit more, namely playlist handling) in 459 lines (instead of my 54 lines).

I might turn this into a Catalyst/DBIc::Class-based app to manage my soon-to-be-existing collection of mp3s (to bad that there isn't a ripper for vinyl...). In my copious free time. Haha..

Original: http://use.perl.org/~domm/journal/28031

Legacy comments

LiveTao: GoGear (orignal post)

I just got the GoGear for christmas. It's a neat little player but I too would like to avoid wmp10



These are my observations in attempting to circumvent this. Mind you, I am no programmer. I'm assuming you've messed with this yourself, but I thought I might have something helpful for you, so here it is.



You can manually open up this device from my computer. With the music I've just made folders and dropped them in the music directory. I tried to simulate what it seemed the player was doing. I made a fol

Comments (via disqus)

16.12.2005: "fun" job
01.12.2005: Hoover Voodoo
28.11.2005: Changes
14.11.2005: We moved!
24.09.2005: More jobs than time
>>>>>>>>>>