trac mysql schema optimization

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!

DreamZZT 3.1.500

A new build of DreamZZT is now available:

DreamZZT 3.1.500

New Features

  • DreamZZT Online support for Nintendo DS
  • Support for saving SuperZZT games
  • Directory listing in NDS file browser (contributed by ndsdev -at – thedopefish.com)
  • Lua interpreter for Nintendo DS builds
  • Reduced memory usage so larger games can fit in Nintendo DS RAM
  • Multi-line text entry widget for bug reports
  • ZZT-OOP script editor
  • Meter display for SuperZZT health
  • Support SuperZZT “hint” key
  • Hold-to-scroll in text windows

Bug fixes

  • Player can no longer travel between boards if there is an obstacle on the other side
  • Stop music playback when ending a game and changing boards
  • Fix dark grey RGB value in NDS palette
  • Display the pattern tiles in the editor
  • Fix board corruption issue when using a teleporter
  • Set color during #change and assign torches a default yellow color

Downloads

Switching teams

So I finally took the plunge and replaced my Slackware Linux server with Ubuntu Linux. Everything seems to be up and running again now, we’ll see how it goes!

On your marks! Get set! Render!

I had the day off work today, so having nothing better to do, I decided to race raz0r (PowerBook G4 1.33Ghz, OS X 10.4.1) and media (Pentium III 933mhz, Ubuntu linux (Hoary)) in rendering with Blender.

raz0r, rendering frame #15 from Magnets: The Movie, required 313MB RAM, and took 2:30 mins to render the frame at 400×300.

media required 380MB RAM, and took 3:40 mins to render the same frame at the same size.

In the words of Stormy Waters, “Smoked that bitch!”. I was expecting the outcome to be along those lines, but I’m not sure why linux requires almost 70MB more RAM to render the same frame.

The output pictures from both were identical, obviously.

Updated!

I updated my stepmania box to include 2 missing DDR mixes: DDR Extreme (arcade) and DDR 4th Mix Plus. Also got some sweet new themes for it.

I’m also considering picking up another Ignition pad, so those of you that like DDR have no excuse for not playing anymore 😛

Daisy.. daisy…

root@sigbox:~# uptime
12:23:26 up 152 days, 20:45, 1 user, load average: 0.00, 0.04, 0.06

I have to shut sigbox down today for an upgrade 🙁 152 days, 20 hours, and 45 minutes without being powered down or restarted. But when it comes back up, it will be running a fresh install of Slackware Linux 10.0 and have a much larger storage capacity.

DCSquares News

I’ve spent the day adding a buddy list feature to the DCSquares site:

Now you can see how your friends are doing! Also, DCSquares 1.4 Beta is now available for the Mac. 1.4 final should be released in a week or so!

Screenshots

Got Dropline GNOME 2.6.0-test1 installed! Lots of nice little improvements in GNOME 2.6.0 over the GNOME 2.5.92 I was running earlier, plus all the Dropline polish!

Untitled

Well, I’m finally almost happy with my desktop.

I curved the top corners of my menu panel, and added a 3 pixel drop shadow to the bottom to add more contrast between the wallpaper and the panel. Here’s a zoomed in version, for those of you without magnifying glasses:

I also made my own icon for the gnome-bluetooth bluetooth:// URI:

I’m still looking for something to replace the home icon, the one from the Snow-Apple icon theme looks kinda silly.

Finally, I got a nice blue GTK+ theme that isn’t so much of an aqua-clone that you wanna puke called Glossy P from art.gnome.org. Maybe I’ll make an orange version of it for Jay, but I kinda like the blue, so I’ll keep it for now. Lastly, my window border theme is a modified version of my most favorite theme ever: Crux. Someone finally updated it so it shows the application’s icon in the title bar instead of an empty box!

Here’s a screenshot of the whole thing together (click to enlarge):

Kinda like OSX, but without that stupid dock, and I get to keep the window list at the top, and a taskbar at the bottom 🙂