Pop quiz. Look at the picture below. Quick: can you tell me to which year and month partition P001 refers?


I couldn't say it without asking the database itself to revert the output of to_days:

select from_days(723180);
+-------------------+
| from_days(723180) |
+-------------------+
| 1980-01-01        | 
+-------------------+

Just to make the pain more clear, you do something like this, clean and neat, and you think you have done a good job.

CREATE TABLE t1 ( d DATE ) 
PARTITION by range (to_days(d))
(
  partition p001 VALUES LESS THAN (to_days('2001-01-01')) 
, partition p002 VALUES LESS THAN (to_days('2001-02-01')) 
, partition p003 VALUES LESS THAN …

I don’t know about “me too” types of bug replies, but before everyone goes to the bug database and starts saying “me too”, “this affects me”, “please fix this ASAP”, “I won’t use MySQL 5.1 till this is fixed”, I wonder if this will cause more harm (i.e. more bug spam for the developer, and all those subscribed to it) than good.

It seems like the public Worklog interface gets this right - via voting. Having a count of those that have the same problems, even displayed via “stars”, is a much better interface, and shows urgency a lot better than “me too” posts.

Take one of my favourite worklogs - …

Who is the Dick on my site?
Dick Hardt

Most interesting keynote. About 1,000+ slides. Many slides per minute. Definitely a new way of presenting :)

• What is identity? What is Identity 2.0?
• Identity is a complicated topic, and you normally get the tip of the iceberg. Identity changes during your stages in life.
• Works at SXIP Identity.
• I wondered what the German’s thought about identity. Identat. “They’re German” <applause>
• Answers.com had the best answers for identity.
• There’s lots of different personas about a person. Women really are the masters of different personas (clothes, wife, mother, etc.). Reinventing oneself.
• Identity allows you to predict behaviour…
• When someone is in a “role” (fireman, etc.), you think you can predict behaviour. Is this identity? It’s who …

I am a conference junkie. I love attending them, organizing them, speaking at them, planning to attend them, seeing my friends at conferences, making friends with the nice (but often stressed) people who run conferences and so on. I even like eating the (often bad) food - kvetching about it builds a sense of camaraderie with the other participants.

Given how much time and money I spend on conferences already, it might be hard for you to be able to get more money directly out of me. However, here is one small tip on a way that you might be able to do this.

When you send me email about upcoming events, send me links to useful feed as well. Many of you are technologists who run technology conferences for other technologists. For Zarquon’s sake, use the common pieces of technology that many of us use.

What would such feeds look like? Well, to answer my own rhetorical question …
…