MySQL table prefix hell

Code extract

Every now and then, there comes a time when you want to try out something new. A little script that uses two db tables and does something really nifty, or perhaps try out Gallery to see if it fits your vacation photo sharing needs. Suppose you have all your web stuff at some cheap web hosting service, and they allow you one database only, what would you do? You add a prefix to the tables!

Who has got whom?

Output from the tuning script

Clouds make me happy. Having our web server in the cloud makes me even happier! Trying to migrate a website with dynamic content stored i mysql from Hardy to to Precise, however...

It started out in 2008, when we (Fria Tidningar) took our new Drupal based website live. We had installed it on the latest and greatest - Ubuntu 8.04 LTS (also known as Hardy Heron). The website held up rather well after some initial tuning of mysql.

The meaningfulness of Heavy Objects

A terribly heavy object

Once upon a time there was a humanoid species obsessed with relative status. The species occupied a far flung territory, and thus it was divided into communities. The communities distinguished themselves by the means they used to determine the relative status of their individual members. Some determined status by the collection of shiny objects, others by the degree of esthetically pleasing decoration of the nest. The community subject of this story used a much more rational determinant – strength.

The Orient Express

So, I got a new toy^H^H^Hphone the other day, and I started playing around with programming for it. The new one is an Android (Xperia X10 Mini), and I found plenty of resources for programming it.

So, yesterday I spent playing around with the direction sensors - and I came up with a simple gyro/compass. Since this could be a fun basis for a game that I would like to play, in case you write it, I thought I'd share. (And also, becase the implementations I found on the web were quite tied into other stuff.)

Summer vacation

Summer vacation

So, it's summer, I'm free, and I need to pass the time. Also, I want some variation. What if I read the comic book upside down?

What happens if I pull this string?

What happens if I pull this string?

S came up with a nefarious plan the other day...

Cowboy cousin

Cowboy cousin

Here's Sylvia's cousin Axel, only a couple of days older - and already staging a hold-up. How will this end?

The guy holding him would be Vidar...

Shock the monkey!

Shock the monkey!

Sylvia is showing a strong carnivorous tendency, or at least stuffyvorous...

Piis A'Krrrpet

Piis A'Krrrpet

There are some who would claim that my camel, Piis A'Krrrpet, is purely mythical. In answer to such sillyness I hereby present a photography portraying said camel.

Loooong nose

Loooong nose

This is Sylvia with a maple seed nose. It looks kinda distinguished, doesn't it?

There are more new pictures in the baby gallery.

Syndicate content