melfneerg.com
- 'cos life is like that
[Blog]
[Pictures]
[Links]
[About]
About the Author
Tudor Davies
Tudor is a techie turned manager who fights like mad to keep his tech skills honed and relevant. Everything from web hosting, networking, *nix and the like. Constantly developing and co-ordinating with others to make the web a better (and easier to use) place.
Wednesday, 22nd Aug 2012
Posted @ 09:30
I now have a case for my Raspberry Pi - its one that mounts it onto a VESA plate for attaching to the back of my TV.
Once a stable release of Xbian or Raspbmc is released, I will update to it and mount it on the bedroom TV - this means we will be able to watch HD content in the bedroom at long last!
My 2 WR703Ns are up and running - one as my own "FreeFile" project (much like PirateBox) and the other is currently running PirateBox. Although this is due to be changed to run as an access-point so I can have Wifi for my iPhone and Android tablet wherever I can find an ethernet connection :)
Oh yeah - Android Tablet. I took my beloved HP Touchpad running WebOS 3.0.5 and installed CynogenMod 9 - Android ICS 4.0.4
Crikey its slick! The microphone and the camera do not work but when they do - I will likely wipe all my data off the WebOS partition and move to using Android exclusively. Mind you, being able to swap over on a reboot is pretty nice.
mySQL indexes - on this here blog I was getting reports from the SQL server of a slow query. The query was
SELECT COUNT(*) AS total FROM comments WHERE article = "xxx"
and this was being reported as taking over a second! The reason - no index. They was a primary key but no index. A quick drop into the command line and a
CREATE INDEX id_comment ON comment(id,article)
sorted it out. Watch your indices people :)
[ no comments : Add ]
layout and initial css based on the
Qtractor page