trac mysql schema optimization

  • Post category:Linux

For anyone using Trac with the MySQL database backend, check out this ticket: http://trac.edgewall.org/ticket/6986

I applied the database schema changes on the MobileScrobbler trac site, and it’s reduced the time it takes to modify or create a ticket from several seconds down to less than a second. Finally, no more error 500 pages when an operation takes too long to complete!

I win!

  • Post category:Life

Yay! I beat adventure mode in Peggle! Final score: 15,659,720!

MobileScrobbler 1.4.3

  • Post category:iPhone

New Features

  • New radio player HUD contributed by Smooquai
  • New radio icons contributed by CompC
  • Add an option to queue tracks while device is asleep
  • Updated French, German, Italian, Norwegian, and Russian translations

Bug Fixes

  • Fix a crash that can occur when playing a non-existant playlist
  • Fix a crash that can occur when the last.fm server is unreachable
  • Stop caching playlists
  • Improved detection of duplicate scrobbles

Head on over to the MobileScrobbler website for installation instructions, screenshots, and more!

Fail Whale

  • Post category:Life

General Tso’s Shrimp = AMAZING

West

  • Post category:Life

I will be spending the week down in Key West with Jay! If you need to reach me, I’ll still be checking my email occasionally. See you all in a week!

MobileScrobbler 1.4.0

  • Post category:iPhone

New Features

  • Redesigned layout
  • Redesigned Now Playing screens by Jan Garcia
  • Browse your friends and listen to their radio stations
  • Keeps a list of your recent radio stations so you can easily restart them
  • Configure MobileScrobbler settings through Preferences.app
  • Multitouch gestures to ban, love, and skip tracks
  • View your top artists, top tracks, and top albums
  • Ban and love tracks from the Recent Tracks list
  • Remove ban and love from the Recently Banned and Recently Loved lists
  • Browse a top listener’s profile by tapping their username
  • Display arbitrary track metadata by passing command line arguments -track, -artist, and -album
  • Empty the metadata and image caches with the tap of a button
  • Compatible with firmware 1.1.3

Bug Fixes

  • Increase scrobbler daemon startup delay
  • Continue updating the progress scrubber while scrolling
  • Hide the ‘Now Playing’ button if nothing is playing
  • Don’t scrobble podcasts and audio books
  • Require confirmation for loving / banning tracks
  • Plug a few memory leaks
  • Faster loading of track and user data

MobileScrobbler 1.4.0 should be available in Commuity Sources in a few days. Until then, it is available from my beta repository at http://dev.c99.org/iphone-beta/

Upcoming server downtime

  • Post category:Life

DreamHost will be moving the server that hosts most of my sites on February 8th, and they’ll be unreachable during that time. This also affects those of you with sites on my hosting plan.

Due to continued space and power constraints in our primary data center, we will be moving the “randy” cluster to one of our newer data centers. This move will begin Friday, February 8, at 10PM PST, and is expected to last up to 8 hours, until Saturday, February 9, 6AM PST. All web servers, mail servers, file servers, and MySQL servers in the randy cluster will be unreachable during this time.

The following web servers will be off line during this move:

alexander arkanoid attila baht bam bob bomberman breakout caesar centipede contra cornelius cortes crack cruisin cssmania deblume defender digdug dinar dinero dollar donkeykong ellipsis euro fidget forint franc gage galaga gap go grant guilder happy herod ikari ike io ivan jezebel joust karnov katamari khan klax korben kroner lamlam leeloo lei limbo-randy limbo-randy2 limbo-randy3 lira lucky mark marvin morgan napoleon nexus nimitz orbital pacman paperboy patton peso pizarro pound qbert quid rhod ruble rupee rygar scagnetti schilling scipio shekel slaughter slimy tetris ugh ultima venice vex vito wasabi yen yoda zorg

If your site is on any of these servers this status post applies to you. Also, if you check the “Account Status” button on the upper right hand of the webpanel ( https://panel.dreamhost.com ) you should see your cluster under the section “Your Email Server:”. We are also sending out an email announcement about this downtime window to affected customers.

We do apologize for this inconvenience. Rest assured we will do everything possible to keep downtime to a minimum.

If you have any questions regarding the server move, please contact our support team.

MobileScrobbler on firmware 1.1.3

  • Post category:iPhone

MobileScrobbler 1.4 will be compatible with firmware 1.1.3 using Nate True’s soft update jailbreak.

Starting with MobileScrobbler 1.4 beta 2 which should be out tomorrow, there will be two separate packages, one for firmware 1.1.1/1.1.2 and one for firmware 1.1.3, due to slight differences in the new firmware that are not compatible with previous versions.

Update: MobileScrobbler 1.4 beta 2 is now available in my beta repository for both firmware 1.1.1/1.1.2 and the new firmware 1.1.3. You can grab it by adding the following repository and installing the MobileScrobbler package:

http://dev.c99.org/iphone-beta/

Update #2: I’ve removed 1.4b2 for firmware 1.1.1/1.1.2 as it appears to be crashing. I’ll downgrade my iPhone tonight and get that resolved. The package for firmware 1.1.3 is still working fine.

Update #3: MobileScrobbler 1.4b2-3 should resolve the “Database too busy” and “Scrobbler is working offline” issues. Please refresh your sources in Installer.app and install this update.

Update #4: MobileScrobbler 1.4b3 is now available. This release is compatible with the dev team’s official 1.1.3 jailbreak. Also, a separate package is no longer required for the 1.1.3 version. Please remove the “MobileScrobbler (1.1.3)” package and use the standard MobileScrobbler package instead. NOTE: If you use the dev team’s official 1.1.3 jailbreak, the preferences application will not be able to start / stop the scrobbler when you press the toggle button. You must reboot your device for the change to take affect.

MobileScrobbler 1.4 beta 1

  • Post category:iPhone

The first public beta of MobileScrobbler 1.4 is ready for testing! Add the following repository to Installer.app to upgrade to 1.4b1:

http://dev.c99.org/iphone-beta/

Please report any issues into the bug tracker, and if you want to revert back to 1.2.6 you can safely downgrade using the Community Sources package.