Using the ENUM data type to increase performance
While going through the DATA TYPES section of the Certification Study Guide, I was refreshed of the ENUM datatype, which I rarely use.
I usually create individual tables for enumerations, so that new values can be added with just an insert, or deprecated values can be marked as such.
However, today I got to think about the performance issues involved in all that joining, and how could an ENUM column improve a select.
MySQL Certification self study
I’m taking the MySQL Certification exams soon, and while I’d love to take advantage of official training, the closest classes near me will be in Buenos Aires (just a few hundred kilometers and an estuary away) in over a month, and I hope to be done with the Developer exams by then.
So I’ll be documenting, [...]
Coding Buddies
Coding Horror always has insightfull articles, and this one on code peer reviews is no exception.
Why is it that writers, musicians and, well, any respected and professional artist or scientist gets his/her work reviewed before it’s published, but the same isn’t true in IT?
My guess? Most programmers aren’t neither artists, nor scientists. They’re an anonymous [...]
highbase beta-0.9.4
Heavy testing, headphones with no music, lots of Sanchez Gran Reserva, headphones with Miles Davis, more testing, an updated Installation Guide, Charles Mingus & Eric Dolphy, and I still couldn’t get a Release Candidate out.
Well, such is the life of the multi purpose hacker. Other people are always finding out new purposes for you, which [...]
Generating random salts from bash
From the ‘just because it can be done’ column, here comes a handy shell script to generate random salts.
So, without further ado, here it goes:
#!/bin/bash
[ $# -eq 0 ] && {
echo “usage: salt <length>”>&2
exit
}
strings </dev/urandom | while read [...]
I love playing Monopoly
This is the latest speed test I run against Santiago de Chile, where a lonely database server is waiting for my queries. Well, it’s got a lot of waiting to do.
This results are from a 2048 down /256 up Kb/s connection for which I pay U$S 52/monthly.
Yeah, I feel your envy already.
The Administración Nacional de [...]
Erlybird 0.17.0 released
Yep, I’m really late for this.
However, I didn’t want to let it pass. I checked up on erlybird a couple of times before, but it was only available as a source project, and you needed a particular netbeans version in order to build the module.
I’m as geek as it gets, but I’m also 30, married, [...]
Rewriting Highbase in Erlang
Why?
Highbase is currently comprised of several shell scripts and some C code. It’s actually a good project (talk about self promotion) that hasn’t reached a stable release yet just because
It hasn’t been tested enough in production environments
I’ve been amazingly busy during the last years. Lots of work, and lots of parenting in the last two [...]
Intrusion detection at the application level, for PHP
Here’s phpids, an Intrusion Detection System for PHP.
According to the site, it aims to counter XSS, SQL Injection, header injection, directory traversal, RFE/LFI, DoS and LDAP attacks, and unknown attack patterns, through it’s Centrifuge component.
Installation is simple. Just download it, copy the lib directory to a directory in your project structure, or add it to [...]
Symbolics Lisp Machine
Wanna have your own Symbolics Lisp Machine?
Here’s the info.
I have enough room, I just live a few thousand miles too far, and have to deal with very picky Customs officials.
