Blog
Why SQL_MODE is important? Part I
MySQL pre version 5.0 was very lax in it’s management of valid data. It was easy for data integrity to be abused if you knew how. The most common examples were truncations and silent conversions that if not understood could provide a serious data integrity issue.
Read moreSun Stock Prices
Sun Microsystem’s (NASDAQ:JAVA ) hit a low this week of $8.71. There was a stronger rally and a close at $9.16 today. The financial times reports Sun Micro chief sees rays of hope , and Bloomberg Sun Rises After Fourth-Quarter Profit Tops Estimates .
Read moreA Bill Gates bio
In the recent Wired magazine (yes, the paper one), there was an interesting time line of Bill Gates. It was rather an odd format, but I found the two page spread an enjoyable read.
Read moreAuditing your MySQL Data – Part 2
Continuing from my earlier post Auditing your MySQL Data , Roland has accurately highlighted that my initial post leaves out some important information for auditing. As the original charter was only to keep a history, for the purpose of comparing certain columns, a history was all that was needed.
Read moreAuditing your MySQL Data
I was asked recently by a client to help with providing a history of data in certain tables. Like most problems, there is no one single solution, and in this case there are several possible solutions.
Read moreFocus on what you do best
When you have a great idea for a web application, it can be hard to consider with all the moving parts to focus just on what’s your uniqueness or differentiator from everybody else.
Read moreGetting Started with Simple DB
With my continued investigation of evaluating alternative data management with cloud computing options, I’m now evaluating Amazon Simple DB . Still in restricted beta, it helps to have a friend on the inside.
Read moreDo you store credit cards in your MySQL Database?
The Payment Card Industry Data Security Standard (PCI DSS) has been developed to help organizations that process card payments to prevent credit card fraud, cracking and various other security vulnerabilities and threats.
Read moreFacebook performance woes today
It seems that of late a number of successful community web sites have been experiencing problems in scalability and performance. Today it’s Facebook. Initially I got a “Problem loading page” browser message.
Read moreDeleting from ARCHIVE tables
I can’t say I’ve used the ARCHIVE storage engine before, but at the NY MySQL Meetup last night there was discussion of the improvements to ARCHIVE in 5.1 and the fact that you could not DELETE from archive.
Read moreCheck your spelling
I’ve been Plurking more lately rather then Twittering . I’d like to offer to help out at Twitter if I could find the right person to talk to. I’m no English major, but I do like to ensure my spelling is correct (at least for the bulk of the audience).
Read moreTime Warner Cable Speed
I had my Time Warner cable installed yesterday, a rather painless process. Reported as having Internet speeds of 10MB down and 1/2 MB up, these were confirmed with speedtest.net Installation – July 5
Read moreToday’s wicked cool site – ping.fm
I posted on my Plurk I wished for an easier way to update my status on social sites such as Facebook , Twitter and Plurk . The answer I got was Ping.
Read moreGenerating Word Clouds
I came across a wicked cool tool at wondle.net . I wanted to create a word cloud for the back of a business card, now I know how. <img src=“http://wordle.net/thumb/wrdl/05557/Ronald_Bradford_About_2"style=“padding:4px;border:1px solid #ddd” />
Read more