A lot is happening in the world of MySQL lately. If you’re in Asia, SkySQL has been organising roadshows. On May 18, there was a captive audience in Singapore, listening to David Axmark (advisor to SkySQL, co-founder of MySQL Ab), Daniel Saito (SkySQL), and Colin Charles (Monty Program). On May 20, there was a huge audience in Manila, and I was totally bummed to have missed out on it.

I’m told there’s going to be an awesome audience tomorrow, May 27, in Seoul, South Korea. Lotte Hotel will be abuzz with all things SkySQL, Monty Program, and MariaDB, and it will feature Kaj Arno and Daniel Saito from SkySQL, and Colin Charles from Monty Program.

May 30 brings upon the SkySQL Roadshow in Tokyo, hosted at the Yurakucho International Forum.

If you plan to attend any of these events (Daniel tells me they’re also reaching capacity) and are in the area, don’t hesitate to drop daniel[at]skysql[dot]com an email and I’m sure he’ll furnish you with the relevant information.

In the #maria IRC channel the other day I fielded a question someone had about a DATETIME column where they wanted to SELECT by the year. The answer (which is probably obvious to many of you) is to use the YEAR() function like so:

(The above assumes the table is named “t1” and the DATETIME column is named “d“.)

In my reply I provided a link to the Date and Time Functions section of the AskMonty Knowledgebase, but when I looked at the entry for the YEAR() function, I noticed that the example given (which originated from the file scripts/fill_help_tables.sql which is found in the MySQL and MariaDB source) was not very helpful:

The above is certainly a valid use of the YEAR() function, but it’s not a real-world use (at least, I don’t know why anyone would use the above SELECT statement in a real application). So I added an example which I feel is more useful, especially to someone unfamiliar with using SQL functions:

Looking at the entries for other functions in both the Date and Time functions section and elsewhere there is a pattern of examples that are useful, but — like the original YEAR() example — useless in the real world.

I have now added better examples to several of the date and time functions but they can probably be improved even more and there are many more entries in the Knowledgebase that would also benefit from better examples. The good news is adding examples to Knowledgebase entries is very easy to do. The bad news is that if I think of all of the examples on my own they will be similar and probably boring, so I’d like to ask for some help.

If you’ve ever wanted to contribute to MariaDB, but didn’t know where to begin, I have a suggestion: Look under the Functions and Operators section of the AskMonty Knowledgebase, find a function or two in need of better examples, and add some (either directly or via a comment). Don’t worry if you are unfamiliar with editing the Knowledgebase. I can clean things up and make your examples look pretty after the fact. Just make sure your awesome new examples actually work. :)

Thanks!

Every morning before any of the meetings get started I print out a small one page newsletter which contains (among other things) the program for the day. Rather than keep them private, Colin suggested I post them here. I call the newsletter the “MariaDB Programador de Journal” which (I think) translates to “MariaDB Programmer’s Journal” in Portuguese.

MariaDB Programador de Journal 11 March 2011
MariaDB Programador de Journal 12 March 2011

[Updated, 13 Mar 2011, to add the newsletter for that day.]

At the meeting we’ve also been taking notes and posting them online for what improvements we want to make this year in MariaDB to make it even better. You can find the notes in the Knowledgebase. If you have any suggestions for things you would like to see in the next version of MariaDB, please leave a comment in the Knowledgebase.

We want MariaDB to always be the best version of MySQL available anywhere, and letting us know what you need and new features that you like to have is an important part of the process.

MariaDB Programador de Journal 13 March 2011