Actually, what I really wanted to blog about before getting carried away with irony yesterday was an old idea on how to force my developers to use placeholders exclusively for SQL queries in applications. As should be apparent from yesterdays blog entry, I am strongly in favour of using placeholders for interpolating values into SQL… Continue reading Placeholders and SQL injection, part 2
Placeholders and SQL injection
It is sad to see how 9X% (or should that be 99.X%?) of SQL applications are riddled with SQL injection bugs. There really is no excuse for this. Nobody writes code like this: sub stupid_sum { my ($list) = @_; my $string = shift @$list; for (@$list) { $string .= ” + ” . $_;… Continue reading Placeholders and SQL injection
Skal EU tvinge Windows brugere til Firefox?
Der er gang i diskussionen vedrørende EU’s mulige krav til at lade folk vælge browser når de køber Windows. Har Microsoft misbrugt sit monopol, er det en god ide at EU blander sig, er det for megen indblanding, osv. Når man installerer en Linux-distribution skal man typisk ikke vælge browser… men man har jo også… Continue reading Skal EU tvinge Windows brugere til Firefox?
Selecting rows holding group-wise maximum of a field, part two
Selecting rows holding group-wise maximum is a favorite problem of mine, but one which only rarely pops up. But for some reason, after my last blog post on the subject, it seems to be mentioned almost daily around here. Something that I forgot to mention in the previous post is that most of the examples… Continue reading Selecting rows holding group-wise maximum of a field, part two
Det skal for øvrigt være med kælder!
En entreprenør får bestilling på et hus. Arkitekttegningerne kommer på plads, byggeriet går igang, der er rejsegilde, og man bliver klar til aflevering. Bygherren får nøglerne og flytter straks ind, flyttebilen er der allerede. Og da flyttelæsset er på plads, kommer det fra bygherren: “Hov forresten, jeg kommer i tanke om noget: Kan I ikke… Continue reading Det skal for øvrigt være med kælder!
Selecting rows holding group-wise maximum of a field
Today there was a question on the Freenode MySQL channel about a classical problem: Rows holding group-wise maximum of a column. This is a problem that I keep encountering every so often, so I thought I would write up something about it. A good example of the problem is a table like the following holding… Continue reading Selecting rows holding group-wise maximum of a field
Slides for my lightning talks at Open Source Days 2008
In case anyone is interested in a copy of my slides for the two lightning talks I gave at the Open Source Days 2008 conference, I have made them available here: “Optimizing Large Databases Using InnoDB Clustered Indexes:” HTML and PDF. “Profiling with OProfile and Intel Core 2 performance counters:” HTML and PDF. I waqs… Continue reading Slides for my lightning talks at Open Source Days 2008
Free SSL certificates, part 2
Previously I noticed that StartSSL is offering free SSL certificates, ie. proper certificates with a CA chain that is accepted by browsers. Now while setting up my own web-server I had the opportunity to try it out. It seems to work well. The certificate seems to work, Firefox 3 does not spit out any errors… Continue reading Free SSL certificates, part 2
Hobbit monitoring
After setting up Hobbit monitoring on my home network, I discovered a curious issue with the Zyxel P-2602HW router that Fullrate delivers with their ADSL products: The Telnet administration port occasionally times-out connection attemps: I really like the Hobbit monitoring tool, I have used it ever since I heard about it when I met the… Continue reading Hobbit monitoring
Træ-algoritmer
Så er træerne plantet! Algoritmen til venstre er et espalier af palmette-typen. Det lille et-årsæbletræ (Rød Aroma, der står et Elstar ved siden af) er klippet af 10 cm oversnoren for at frembringe nye skud til foråret som skal bindes vandret ud tilhver side. Næste år klippes der over en ny snor en etager over,… Continue reading Træ-algoritmer