Use the radioSHARK 2 under Linux (shark2.c)

radioshark2-small.jpegHisaaki Shibata took Michael Rolig’s shark.c -which I use to control my radioSHARK from Linux- made it work with the new radioSHARK 2 and released the new shark2.c (local mirror).
With this development owners of the new radioSHARK 2 can control their shiny new device under Linux to change stations and change its lighting besides other neat tricks like live Internet streaming with icecast2 and darkice as I’ve written before.
I haven’t been able to lay my hands on a radioSHARK 2 but I might do it soon. I hope that griffin has finally managed to solve the annoying bugs in the software that made the original radioSHARK completely unusable under Windows, but keep in mind that Michael and Hisaaki’s work has made the enclosed software completely irrelevant to Linux users, opening a new market for a fine hardware product.
[tags]linux,radioshark,radioshark2[/tags]

Hello, Planeta Linux!

planetalinux-small.pngAnd now for something completely different: This site is now syndicated in Planeta Linux Mexico.
If you haven’t heard about Planets, they are sites that publish aggregated news feeds around certaint themes in the now all-too-familiar reverse chronologic order. Planets are a great way to feel the pulse and hear the buzz of a community without having to maintain individual subscriptions manually. Throught the years I’ve become reliant in several Planet feeds, most notably Planet Perl, Planet Python and Planet Debian.
A few weeks ago Beco introduced me to Planeta Linux -now I’m an avid reader- and kindly offered to talk to Damog and get this blog’s RSS feed into the site.
If you are one of my three regular readers, go visit Planeta Linux, I’m sure you’ll find it as enjoyable as I do. And if you are a Planeta Linux reader, well… Hello!
[tags]Planet,PlanetaLinux,RSS,syndication[/tags]

Moving from MyISAM to InnoDB: bulk table conversion

A couple of years ago Ludovico Magnocavallo tackled the issue of bulk conversion of MySQL tables from MyISAM to InnoDB with an elegant bash snippet.

for t in $(mysql --batch --column-names=false -e "show tables" mydbname); do
  mysql -e "alter table $t type=InnoDB" mydbname;
done

The original post also suggests using grep to limit the scope of the conversion to just a few tables.
(It seems that now Google *does* yield practical answers to this question ;-)
[tags]bash,mysql,innodb[/tags]