Today I got my speakers (AX510) for my Dell 24″ screen. They are attached to the bottom of the display and are powered directly through the screens power supply. But since I attached LEDs at the back of my monitor two years ago, I had to take the bottom LEDs down. And that went quite well, I was a bit afraid they wouldn’t come off anymore, but the Tesa PowerStrips did well. Attaching the speakers was done in no time and I hooked them up to my server/second workstation, where I hadn’t had any sound yet. They sound quite nice for small integrated speakers, even though they cannot compare to a real 5.1 speaker system. And now I attached the LEDs again and everything works great. 🙂
Today I re-tagged some of my posts again, because thats the only information the s9y to wordpress script didn’t got. While doing that, I relived some of my pain with the purchase of my vdr. But now I’m home and started chalooby, my vdr in the living room, to see an episode of Sons of Anarchy and realized: My vdr runs pretty damn good. It may not be as flashy and nice as some of the modern HTPC systems, but the feature list (old german post) is still impressive, especially the fact that I can use the tv signal over the network on my second vdr and any other computer in the network. (Working on TV on my android phone though ;-)) And in addition to that, I really hated the company that sold me the hard (and at the time software) for the vdr. But even though they made some pretty bad decisions, the hardware is quite good supported after all. Today and yesterday I worked on a vdr I set up with my colleague for him and we had soo many problems with it over the last two years. First the output to the TV (we tried through the graphic card, a dxr3 and it finally worked after buying a technotrend card), then the display, the remotes and the biggest problem was the automatic power on with an external self made device. He had some problems lately with the vdr and we upgraded the system yesterday. After I got the remote running again, now the automatic power on doesn’t work.
I just decided that my Serendipity, as much as I liked it in the past, got a bit dusty. That was my fault I guess, but since I write in other blogs with wordpress too, I decided to switch. It was quite easy actually. You don’t really have to mention the installation and the import of the old articles was quite easy too, thanks to this import tool.
Articles before today may look a bit weird, but the important stuff should be accessible. Too bad I’ll lose my google entries, but well, its not as if I would try to make money here. 🙂 I’ll have to find some theme though and setup plugins. But not now, I’ll see in a couple of days.
My blog is quite dead ATM, I somehow can not or don’t want to find time to blog. But I twitter from time to time, thats much faster than a whole blog entry. 🙂 But I tried this year to have a small Halloween party and gave some Halloween recipes a try:
At first I carved my first pumpkin and used the pumpkin for a Chili con Kürbis (Chili con pumpkin).
After I carved them, they looked like this. 🙂
I also tried around with some jello, but somehow the Haribo worms melted, so I had to took the rest out.
After that I served some pus hands with blood:
And as a drink I had bug eyes punch:
Forget what I said here, it’s really inefficient… I just stumbled upon (or actually really searched for) a article, which describes an easy way to cache the rating and make searches as performant as it was before we put the rating into an extra table.
Only thing I had to add was a method to regenerate the cache for all the old quotes, which don’t have the cached rating yet. So, check out the howto and add the following method to your rated model:
self.find(:all).each do |quote|
quote.update_attribute :rating_cache, quote.rating
And then I wanted to combine those two. I couldn’t find any nice ways of doing this, but until someone tells me a better way, the following is working out for me and helps perhaps someone else out there. Even if it could be a bit nicer. 🙂
@quotes = Quote.paginate_by_sql "SELECT quotes.*, avg(ratings.rating) AS rating, count(ratings.rating) AS votes FROM `quotes` LEFT JOIN ratings ON quotes.id = ratings.rateable_id WHERE (ratings.rateable_type = 'Quote' OR ratings.rateable_type IS NULL) GROUP BY ratings.rateable_id ORDER BY rating DESC, votes DESC", :page => params[:page]
Edit: I fixed it, it returns now quotes without a rating too.