Technology
plotto the office lottery pool iphone app
Update: 2011-08-27 – Price change to $.95! yes, just Ninety-Five cents! Rock out America! – Version 1.1 coming soon! – Also, there’s been some curiosity about data persistence in the app, so let me clear this up. All app data is stored on the phone using a SQLite database. No data is stored remotely and […]
My favority BASH one-liners
Let me preface this post by saying, these are hacks. Neither the best or the only ways to achieve the desired results. But hey, if they work for me, they may work for you. Enjoy! ping -i 10 4.2.2.2 Send a ping request to an IP address once every 10 seconds. Why would I do […]
Use BASH to extract MySQL ACL list
Need to quickly extract all the GRANT info for your database users? Here’s a one-liner: for i in $( mysql -u readuser -pReadPassword -h your.host -e “SELECT CONCAT(user,’@\”,host,’\”) AS ACL FROM mysql.user ORDER BY user” -s ); do mysql -u readuser -pReadPassword -h your.host -e “SHOW GRANTS FOR $i” -s ; done ; Here’s a […]
Group Lunch iPhone App
UPDATE! What’s New in Version 1.2 – Bug fix: Removed iAd support because it was crashing older phones. – Also recompiled build for ios 4.0 device compatibility. What’s New in Version 1.1 – Changed behavior so when the user begins edting a text field, it clears. – Added spin logo to about page. – Fixed […]
Creating a Date Dimension Stored Procedure
Our data warehouse was getting pretty big. In fact, it was it was getting into the hundreds of gigabytes of fact data. We started looking for ways to save hard drive space. It became apparent that storing redundant varchars, datetimes, enums and other large column types was unnecessary and causing the scale constraints. Part of […]
Sysbench for MySQL Burn-In Testing
The reason for my last post about getting Sysbench installed on OS X, was that I had a chore to burn-in four MySQL hosts. They are currently replicating which is normal behavior for this group. I wanted to add some stress testing. Here is the script I created for his purpose. You can modify the […]
