Safe For Seneca

I mentioned that I’ll talk about the software migration from the old littlesvr.ca hardware to the new machine. The neat thing is – I accomplished it in less than a minute of downtime while preserving all my data/metadata. Here’s the long story (shorter version at the bottom): First step was to install the OS on …

Continue reading Homebrewed live server migration

While analyzing the files I got from Debian I ran into a lot of language codes that weren’t in my database already. It was an interesting exercise, involving me learning about the existence of languages such as Javanese and countries that I already forgot about. The problem is that some of the language codes are …

Continue reading Language codes, part 1

For the longest time I’ve been using a tiny piece of hardware to run littlesvr. I loved it. Low power consumption, very unlikely to break due to a hardware failure, and fast enough for anything I wanted to do on it. But now I want to run MySQL and insert gigabytes worth of rows into …

Continue reading New littlesvr.ca

I’m generating a new certificate for myself, and I still remember the frustration I ran into a long time ago where the problem was my certificate expired needlessly and completely unexpectedly. So this time I figured what the hell, I’ll set it to expire in 100 years. I thought that was the end of it, …

Continue reading Year 2038 problem, in 2012

Christian Perrier from the debian-i18n list has done me a huge favour. He created a tarball with every translation in every language for every piece of software in Debian! You may imagine it’s huge as did I, but I was shocked at just how big it is. Almost 2 GB of gzip-compressed PO files from …

Continue reading Lots of translations

andrew@littlesvr:~$ uptime 13:26:34 up 1104 days, 10:14,  4 users,  load average: 0.61, 0.31, 0.21 I guess 1100 days doesn’t sound like a lot but 3 years does :) It’s still the same machine I mentioned a year ago. It’s been running and running and running, and not crashing! Theoretically 3 years is not a lot, …

Continue reading Beat my uptime: 3 years!

Here’s an OSTD feature I was really excited about and looking forward to implement: allow the user to put in some version control info for a project so that I can run a nightly cron job and pull any new translations that have been added to that project. Would have been a great feature, and …

Continue reading Oh, you Git!

I’ve started to run into serious performance issues with my SQL queries. I mentioned my concerns earlier, but now (still long before production time) I’m already experiencing clearly unacceptable performance. I’ve added a couple of thousand translated strings to the database, and uploaded another PO file for the record. That would run the following query …

Continue reading Good query bad query