Skip navigation

Tag Archives: lazy developers

Making Facebook Useful

I’m not a particularly big fan of Facebook, but I recognize its usefulness in some ways, so I have an account. My brother (and a bunch of other folks I know) seem to be pretty addicted to the site, for reasons unknown to me. Maybe that’s the same reason I find keeping a Twitter account useless (no, I don’t have one).

So imagine my surprise when I sign in today and discover that I can’t find friends of mine from a certain city I’m visiting soon. Searching for said city returns a bunch of people, events, web results and other things of no relevance. Apparently Facebook thinks people would rather find new “friends” than search the ones they have.

After searching Google for some sanity-checking, someone had this link to share, which apparently is exactly what I wanted in the first place. Attempts to find this page from the Facebook interface were met with frustration and failure, until about 10 minutes later I found it under “Edit Friends”. Edit Friends? What?

Maybe I’m overthinking it, but why is searching your friends list under “Edit” and actual searching doesn’t search your friends? Did the use-case focus group goof up?

Importing Amarok 1.4 statistics into Amarok 2.2

This assumes you use mysql/external:

  • Save your amarok <2.2 database:
mysqldump -uroot -p amarok > amarok.db #adjust for your system
  • Re-import it as database “amarok1″
  • Drop your original amarok database and let Amarok 2.2 otherwise re-create it.
  • Look at amarok.urls.rpath and amarok1.statistics.url to determine the prepending path difference

Execute the following queries:

UPDATE amarok1.statistics SET url=REPLACE(url,"./", "./mnt/hdd750/"); /* replace "./mnt/hdd750/" with the prepending difference you saw in the earlier step */
 
INSERT INTO amarok.statistics (url,createdate,accessdate,score,rating,playcount,deleted) SELECT id,createdate,accessdate,percentage,rating,playcounter,deleted FROM amarok1.statistics s1 INNER JOIN amarok.urls u2 ON(s1.url=u2.rpath);

Preseto, Amarok 2.2 now has your old statistics.