Everyone and their mother are throwing out their predictions for 2009 nowadays, itâ€s a new fad. Itâ€s like youâ€re not cool anymore if you donâ€t have twitter, a Mac, and a set of random predictions for the next 12 joyous months.

So I decided to throw in a few ideas of my own to be part of the cool crowd again (how much cooler can I be already, you might think, and I wouldnâ€t blame you).

Disclaimer (read it, tough guy)

What this post is:

• about the future of technology and the Internet, 2009 and beyond.
• my ideas on what is going to happen or should happen. If they happen to match someone elseâ€s ideas – it doesnâ€t mean I ripped them off, it just means we share the same opinions and theyâ€re more likely to come true.
• awesome.

What this post is not:

…

Earlier today, MySQL 5.1 was downloaded for the millionth time.  Pretty cool!  I wonder if we can find out who the lucky downloader is who got the millionth copy.  Maybe we could embarass them with a MySQL logo prize or something at the MySQL Conference April 20-23 in Santa Clara.

Congrats to all those who created MySQL 5.1, to all our users, to the many who found, fixed or otherwise helped us chase down bugs.  Thank you for making this a great release!  

• MySQL: MySQL 5.1 Download, …

TIMESTAMP is interesting in that it can give you an easy way of keeping track of when was the last time a row was modified, with a few caveats, listed below. The tests were run on 5.1.30-community MySQL Community Server (GPL).

• By default, TIMESTAMP is NOT NULL. Inserting a NULL value causes it to store the current DATETIME;

  mysql> CREATE TABLE t1 (c1 TIMESTAMP);
  Query OK, 0 rows affected (0.11 sec)
  
  mysql> INSERT INTO t1 VALUES (NULL);
  Query OK, 1 row affected (0.03 sec)
  
  mysql> SELECT * FROM t1;
  +---------------------+
  | c1                  |
  +---------------------+
  | 2008-12-30 20:42:25 |
  +---------------------+
  1 row in set (0.00 sec)
  
  mysql> CREATE TABLE t2 (c1 TIMESTAMP, c2 TIMESTAMP);
  Query OK, 0 rows affected (0.06 sec)
  
  mysql> INSERT INTO t2 VALUES (NULL, NULL);
  Query OK, 1 row affected (0.02 sec)
  
  mysql> SELECT * FROM t2;
  +---------------------+---------------------+
  | c1                  | c2                  | …

Lots of blogs list a bunch of stuff that happened in the year just past, and I have done a year-in-review post before, but in looking back at posts on this blog and elsewhere, what strikes me most is not the big achievements that took place in technology in 2008, but rather the questions that remain unanswered. So much got started in 2008 — I’m really excited to see what happens with it all in 2009!

Cloud Computing

Technically, the various utility or ‘cloud’ computing initiatives started prior to 2008, but in my observation, they gained more traction in 2008 than at any other time. At the beginning of 2008, I was using Amazon’s S3, and testing to expand into more wide use of EC2 during my time as Technology Director for AddThis.com (pre-buyout). I was also investigating tons of other technologies that take different approaches to the higher-level problem these things all try to solve: owning, and housing (and …

You can read my conversation with Lenz Grimmer or look at other interviews conducted by the MySQL community team. 

You can read my conversation with Lenz Grimmer or look at other interviews conducted by the MySQL community team. 

You can read my conversation with Lenz Grimmer or look at other interviews conducted by the MySQL community team. 

One of the best ways to keep up with your field and network at the same time is to attend conferences. It’s one of the things I look forward to every year. After learning that O’Reilly has decided to commit blasphemy and *not* hold OSCON in Portland, Oregon the same week as the Oregon Brewers Festival, I was inspired to look around at what other conferences I might attend in 2009. Turns out, this is a huge pain in the ass, because I can’t find a single, central place that lists all of the conferences I’m likely to be interested in.

So… I created a public Google Calendar. It’s called “US Technical Conferences”. It needs more conferences, but I’ve listed the interesting ones I found. In order to keep the calendar from getting overwhelmingly crowded, I’ve decided that conferences on the list should:

• Deal with open source technology in some way. This is purposely broad.
• Be at least 3 days in …

I have, in the past, worked for startups of varying forms. I worked for a spinoff that ultimately failed but had the most awesome product I’ve ever seen (neural networks were involved, need I say more?), I helped a buddy very early on with his startup, which did great until angel investors crept in, destroyed his vision, and failed completely to understand the Long Tail vision my buddy was trying to achieve, and I worked for a web 2.0 startup which was pretty successful, and was subsequently purchased… by another startup!

Working in academia for 6 years also exposed me to people who are firing up businesses, or projects that accidentally become businesses, and some of those go nowhere, while others seem to be on the verge of NYSE listing now, while a year ago they were housed in the smallest office I’ve ever seen, using lawn furniture for their workstations.

Of course, I’ve also consulted for, and been interviewed by, a …

Often times, production data needs to be moved to different environments for testing/developing purposes. However, some of that data can be people’s name, birthday, address, account number, etc., that we don’t want testers and/or developers to see, due to privacy and regulatory concerns. Hence the need to mask those data. I can certainly see this needs grow over time for all database platforms. There are software out there that does this sort of task, or similar tasks, such as data generation tool. Oracle actually has a Data Masking Pack since 10g for this purpose. Here are some of my thoughts on this topic.

One method of masking data is through reshuffling, which shuffles the value in target column(s) that you want to protect randomly across different rows.

Another way of doing it is through data generation. For instance, for target column(s), we just replace its value with something else.

For reshuffling, obviously …