You know ThinkGeek. Cool (geeky) stuff, and I know they're very nice people too.
Right now they're also in need of a senior programmer... strong Linux, SQL, Perl and web skills. You have to be willing to move to Fairfax, Virginia. For more details, see http://www.thinkgeek.com/jobs

The above URL also has a link for applying - if I know you and you would like a personal intro to the folks at ThinkGeek, toss me an email!

Expect the unexpected! There is a hilarious video on YouTube, called

Do babies dream of being database engineers?

http://www.youtube.com/watch?v=FJvamAW_nSE

Back in the day, we worked on developing a specialty application that was basically a lead generation system with a database that stored over 200,000 records, with a potential for a lot more. The web application displayed numerous reports that calculated totals from disparate sources. We discovered that once our client began adding all their data that those reports were running slower and slower and slower. The problem was that we had one primary query to pull the records out, then, as the code looped through each record, several other queries were needed to calculate the disparate totals. That resulted in numerous database calls that slowed the entire web application. That's when Mike discovered MySQL Wizardry, that used the SUM(IF()) and the GROUP BY clause, problem solved. ...

It was my pleasure to work with Mårten Mickos, CEO of MySQL for about a year during 2005 and 2006. I was astounded by how involved he is with the employees and how well he keeps abreast of the goings-on in the company. He seems to be of the rare set who are not only strong supporters and evangelizers of the company and software, but are also technically familiar with it. With great folks like Mårten, Brian, Arjen, Zack and Ulf, MySQL AB has been and continues to be one of the most important Open Source companies that exists.

Go read the slashdot article here:
…

Not sure how many CEOs get coverage on Slashdot, but a few days ago, Marten Mickos did an online interview there.  Sometimes online discussions degenerate into a technological pissing match (such as the venerable "vi vs. emacs" arguments) and I'm glad this one didn't.  Marten talks about issues around software quality, building a business, walking the line between enterprise and community needs and other interesting topics.

• Slashdot: MySQL CEO Marten Mickos Answers Your Questions

Following up on what Stewart and Colin reported: this definitely is the first time PBXT has been mentioned on SlashDot: MySQL CEO Mårten Mickos Answers Your Questions.

Mårten, speaking of the the innovative power of MySQL AB, says: "But more massive is the innovation that happens in the MySQL ecosystem", and lists PBXT amongst a lot of other great work.

So I am very proud that PBXT was mentioned in this context!

I found a bug on the view implementation.

According to the manual some view is updatable if the view satisfies the "one-to-one relationship" between the rows in the view definition and the rows in the underlying tables. To be more specific a view is not updatable if it contains any of the following:

• 
  
• aggregate functions (AVG(), SUM(), MIN(), ...)
  
• DISTINCT
  
• GROUP BY
  
• HAVING
  
• UNION (ALL)
  
• subquery in select list
  
• JOIN (with some exception)
  
• non-updatable view in the FROM clause
  
• algorithm=temptable
  
• refers only to literal values
  

So, let's try this simple example:


mysql> create table t1 (a int);
Query OK, 0 rows affected (0.21 sec)



mysql> create …

I found a bug on the view implementation.

According to the manual some view is updatable if the view satisfies the “one-to-one relationship” between the rows in the view definition and the rows in the underlying tables. To be more specific a view is not updatable if it contains any of the following:

• aggregate functions (AVG(), SUM(), MIN(), …)
• DISTINCT
• GROUP BY
• HAVING
• UNION (ALL)
• subquery in select list
• JOIN (with some exception)
• non-updatable view in the FROM clause
• algorithm=temptable
• refers only to literal values

So, let’s try this simple example:


mysql> create table t1 (a int);
Query OK, 0 rows affected (0.21 sec)



mysql> create view v1 as select a from t1;
Query OK, 0 rows affected (0.00 sec) …

Last week while visiting Lars I had a moment of embarrassment. While going over my system of "Getting Things Done" with Lars, I revealed that my inboxes were huge.

On the flight back home I took what was once thousands of pieces of email divided into two email account (one my MySQL account, and the other Tangent) and got my inboxes down to under 150 total. I did this through a combination of "delete this entire mailing list" and "read it all".

So how did I have such a large email inbox? A few things I noticed while deleting the email:

1) There were emails in my inbox I should have replied too. Most email I can answer in minutes, anything else gets deleted and added to my to-do list. It looks like I will occasionally make an assumption of "this will take just a couple of minutes" get interrupted by a phone call, and never return to it. Not answering or deleting just two pieces of email a day, will leave …

A common problem MySQL users have with Crystal Reports 9 is the inability to browse tables and fields. While you can define a MySQL DSN, when you open it in Crystal Reports 9 you have no tables or fields in the field browser. This of course makes it very difficult to create a report.

Up until recently, the only two workarounds have been to either create the report in an older version of Crystal Reports and then open it in Crystal Reports 9, or use custom commands to return field data. Neither of these are particularly effective for creating reports.

This has been a known issue with Crystal Decisions and has now been solved. The full article is available in a knowledgebase article located at http://support.crystaldecisions.com/library/kbase/new_articles/c2013269.asp”

The short version is that you need to download …