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:
select * from t1 where YEAR(d) = 2011;
(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:
MariaDB [(none)]> …
We all know that Kurt von Finck is going to give a talk at Percona Live NYC happening May 26 2011. If you want to attend we’ve got three tickets to give away (worth USD$249 each).
This should be the easiest contest ever to enter and win. Just go to the Knowledgebase, create an account and write one new article, longer than 2 paragraphs. Once you’re done, send a quick email to community@montyprogram.com with a link to the article, and if there is no duplicate content already on the Knowledgebase, you’ll get your ticket to Percona Live NYC.
…
Yesterday I set up a new machine for our MariaDB Buildbot. This is quite an important build host for us, it runs more than 20 different builds for each push into our most important trees, and is the host that builds most of our release packages. So quite a workhorse! It is a pretty fast machine, with 5 SSD disks, 48GB of RAM and 2 x quad-core Intel Xeon E5420.
This is a replacement for the previous machine serving the same builds. The previous machine was also nice, at least on paper, with no less than 24 cores. …
Monty gave a keynote on Wednesday morning, on the State of MariaDB. He’s also just posted his thoughts and updates from the conference. Check out his slide deck embedded blow, and don’t forget you can also watch the video (running time ~30 minutes).
…
Continue reading “State of MariaDB Keynote at the O’Reilly MySQL Conference & Expo 2011”
Santa Clara, CA, USA — Wednesday, April 13, 2011 — Monty Program Ab today announced that SkySQL Ab is the first partner to achieve Platinum Support Partner status with Monty Program. The criteria include offering 24 x 7 support worldwide, a proven ability to handle first and second level support cases for MySQL® and MariaDB®, as well as having delivered a certain amount of well-defined commercial 3rd level support cases in the form of bug fix requests to Monty Program Ab.
“We’re happy to work with the SkySQL support team” says Rasmus Johansson, COO of Monty Program Ab.
…
Continue reading “SkySQL Ab first to pass the Platinum Support Partner criteria for Monty Program”
Are you a developer who is writing storage engines and plugins, knowing the plugin architecture of either MySQL, the extensions in MariaDB as well as the differences in Drizzle? Do you write User defined function (UDF)? Then you definitely want to be at the Plugins & Storage Engines Summit for MySQL/MariaDB/Drizzle 2011.
Its happening after the conference, on Friday April 15 2011, from 10am-4pm, at the Facebook campus.
You need to sign-up to attend – seats are limited. Sign up now!
…
Continue reading “Plugins & Storage Engines Summit for MySQL/MariaDB/Drizzle 2011”
Monty just got interviewed by Packt Publishing in a Q&A format. There’s no way to comment on that article, so I’m wondering if you have any feedback — drop it here.
Also decided to start collecting interviews related to MariaDB on the Knowledgebase. Remember that its open for all to edit, so sign up.
…
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.
[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. …
Continue reading “Newsletters from the MariaDB dev meeting in Lisbon”