Archive for December, 2009
Friday, December 11th, 2009
I bought a MacBook Air in June this year, refurbished. I didn't really use it a lot for day to day work, and when I didn't use it I was charging it. It was very convenient - it weighs practically nothing and has almost no impact on me ...
Posted in apple, tips | No Comments »
Thursday, December 10th, 2009
Looking for instances particular column in a large schema can be a pain. Fortunately the information schema makes this pretty easy, if your columns have a consistent naming convention.
SELECT table_schema, table_name, column_name
FROM information_schema.columns
WHERE column_name LIKE '%some_name%';
Now, if we want to wrap this up into an ...
Posted in mysql, stored procedure | 3 Comments »
Tuesday, December 1st, 2009
I'm sick of looking through chat logs to find an IP geo lookup database.
Now it's here, possibly forever, or until I stop paying for hosting.
Posted in Uncategorized | 2 Comments »