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 [...]
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 [...]
New release of MySQL Proxy GPL
MySQL Proxy has a new release, just three days ago, and if that wasn’t good enough, it’s now hosted on Launchpad, so it’s repository is on bazaar, which is great, and is what I’ve been using for my new projects. MySQL Proxy sits between clients and servers and offers many possibilities, load balancing being the [...]