MySQL
BIGINT v INT. Is there a big deal?
The answer is yes. In this face off we have two numeric MySQL data types, both Integer. In fact MySQL has 9 different numeric data types for integer, fixed precision and floating point numbers, however we are just going to focus on two, BIGINT and INT.
Read moreOff to OSCON
I will be heading to my first OSCON next week where I will be presenting MySQL Proxy: from Architecture to Implementation in conjunction with Giuseppe Maxia . As was written by Colin Charles Our booth is yours… Sun at OSCON , Sun/MySQL would appear to also have a reasonable turnout.
Read moreWhy 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 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 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 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 moreGiving control of your data to the cloud
I’ve been doing some research and evaluation of more cloud computing. Specifically my focus has been on data store, and considering how to augment an existing operation using a popular database such as MySQL .
Read moreHandling Disaster 101
I’ve had to accept the “practice what you preach” pill recently due to a disaster at my hosting provider. See Learning from a Disaster . While it was my own personal site on a dedicated server in question and not a business generating review I found that my MySQL Backup Strategy was incomplete ( It is also based on code 4 years old).
Read moreWorking with Google App Engine
Yesterday I took a more serious look at Google App Engine , I got a developer account some weeks ago. After going though the getting started demo some time ago, I chose an idea for a FaceBook Application and started in true eXtreme Programming (XP) style (i.
Read moreCorruption using MySQL AES_[EN|DE]NCRYPT functions
I was contacted this week by a previous client regarding a failure of processing data. This was a Contact, Financial and Media Management system I developed for a non-for-profit organization a LAMJ stack, and I’ve had to do nothing since deployment in the past 3 years, no bug fixes, no feature enhancements.
Read moreUpdated Website and Professional Blog
For those that have my existing blog bookmarked, or use any RSS/Atom feeds please update your information now. My new blog can be found at http://ronaldbradford.com/blog/ RSS 2 is http://ronaldbradford.com/blog/feed/rss2 , Atom is http://ronaldbradford.
Read more