Monthly Archives: March 2009

Running MySQL queries in Python

Posted on March 20, 2009 by Samuel Huckins

Being able to access MySQL databases in Python opens up quite a wide range of possibilities. It’s essential for a number of tasks such as connecting disparate datasources, performing maintenance, running regular updates, and more. While there are a number … Continue reading →

Posted in MySQL, Programming | Tagged , , , , | 5 Comments

Finding the smallest or largest value across multiple columns in MySQL

Posted on March 20, 2009 by Samuel Huckins

A long title for a simple problem: You have a table containing several columns of, say, dates. You want to find out the first or last date among the values of these columns per row. Not too bad. But, you … Continue reading →

Posted in MySQL | Tagged , , , | 2 Comments

Creating better MySQL indexes: The basics

Posted on March 20, 2009 by Samuel Huckins

The well-developed MySQL platform allows anyone to play with a full-featured database just by following a few links and clicking through an install wizard. You can download it at home for free, and have access to the same high end … Continue reading →

Posted in MySQL | Tagged , , , | Leave a comment

Exploring the power of the mysql client

Posted on March 15, 2009 by Samuel Huckins

One of the things that surprised me at the MySQL Bootcamp was the focus on using the mysql CLI client. I used to only use this, since the GUI-based Query Browser was rather unstable on Linux. I just got tired … Continue reading →

Posted in CLI, MySQL | Tagged , , , , | 2 Comments

Simple and effective Python logging

Posted on March 15, 2009 by Samuel Huckins

I have been using the quite capable logging module for all of my logging in Python programs for some time. After trying a number of different options and formats, I have stabilized my setup into what I will describe below. … Continue reading →

Posted in Programming | Tagged , , , | 4 Comments