Lenz Grimmer's blog

With IntelliJ now being available under an Open Source license, developers have another option to choose from when it comes to Java-based IDEs/Frameworks (Eclipse and NetBeans being the other two prominent ones). Choice is always good, and being an Open Source enthusiast, I of course welcome JetBrain's move!

However, as I'm not really a heavy GUI-based IDE user myself, I can't really comment on which one is the best. These kind of discussions tend to turn into a Holy War anyway... In the end it's likely that each of them gets the job done and you have to come to your own conclusions, based on your personal preference and requirements.

I personally would be interested in seeing how their support for PHP or Python compares to the one in NetBeans. Their plugin repository lists more that 560 plugins, including many for database connectivity/modeling/navigation (incl. support for MySQL). I'm also glad to see that they have a plugin for Bazaar, something that I'm desperately missing from NetBeans!

Interestingly, they decided to keep a few parts proprietary, it's going to be interesting to see how this will turn out for them and if developers will be willing to pay for these extra features, considering that most of this is available for free from the other two projects.

Their Contributor License Agreement looks like it has been derived from the Sun Contributor Agreement (SCA), which is always nice to see. I assume this can be attributed to Roman Strobl - I was positively surprised to notice that he joined their team as a technology evangelist in June! Roman did a great job in spreading the NetBeans and OpenSolaris gospel at Sun before and I briefly met him at this year's FOSDEM conference in Brussels. Congratulations!

The summer break seems to be over and the event season is heating up again! There is a number of conferences and events coming up in the next months — here is a quick summary of the events that I plan to attend.

This Friday I will attend an event here in Hamburg: the "Silpion Sommerfest", organized by Silpion (a local IT solutions provider which is a partner of Sun Microsystems as well). I will be there to network and talk about MySQL.

This coming weekend (2009-09-12/2009-09-13), there will be the PHP Unconference here in Hamburg, Germany . It will consist of two days of Barcamp-style sessions about PHP. Sun/MySQL are sponsors of the event and I expect several of my team mates to be there as well. With more than 180 participants, the event is already sold out.

The following week I will be attending the openSUSE Conference in Nuremberg, Germany on 2009-09-17/2009-09-20. I will give the opening keynote on Thursday morning. Titled "Working in a Virtual Community", I will talk about the pros and cons of working in a virtual organization, giving an overview about some of the technical and social aspects that play a role in working with virtual communities.

On December 10th and 11th I will be attending the 4. Secure Linux Administration Conference 2009 (SLAC) in Berlin, Germany. I've been invited to talk about MySQL and will give two sessions about MySQL Backup & Security as well as MySQL High Availability Solutions. The Call for Papers for this event is still open, so if you have a technical, "best practice" talk that might be relevant for system administrators, consider submitting your proposal!

 

IPC 2009, the International PHP Conference will take place on November 15th-18th in Karlsruhe, Germany. While the deadline for the call for papers for the main conference program has already passed, there is still an opportunity to submit MySQL-related content: the organizers plan to have a special MySQL Day, which will take place on Tuesday, 17th of November.

Quoting for the Call for Papers web page:

We are looking for speakers joining the Architecture Day or the MySQL Day. "Architecture", in terms of project organization, business organization, tools & approaches etc. is becoming a key qualification to developers and teams. And MySQL still is one of the most common open source databases used in many of todays leading web applications. The International PHP Conference will provide attendees with professional and up to date information on both MySQL and Architecture in the world of PHP.

We are looking forward to you numerous suggestions and proposals, as usual via http://phpconference.com/input.

We would like to encourage you to support and contribute to this event by submitting interesting talks related to MySQL and PHP! If you have any questions or comments about this MySQL Day, feel free to get in touch with Robert Lippert or Björn Schotte directly. Thank you!

 

Just a short announcement: I am going to join Ulf for his PHP Barbeque Tour across Germany, which will take place between June 15th until the 21st. We will start in the south of Germany and will work our way up north in one week, stopping by at various cities in Germany to enjoy a barbecue with local PHP User Groups and to talk about PHP (of course), MySQL, Open Source, The Web and anything else. We've set up a Wiki page that outlines the various stations of our journey. At the Moment, we will visit the following cities:

• Monday, 15th: Munich
• Tuesday, 16th: Frankfurt
• Wednesday, 17th: Karlsruhe
• Thursday, 18th: Berlin
• Friday, 19th: Dortmund
• Saturday, 20th: Hamburg
• Sunday, 21st: Kiel

I look forward to this trip and to meet and talk with people from all across Germany. If you are located in a city nearby and are interested to meet with us, please come over! The events will be organized by the respective local user groups, so please get in touch with them for the details — check the Wiki for contact information/links.

I just realized that I haven't blogged for more than a month! Shame on me. But I will blame it on being away on conferences and vacation for quite some time And if you are following me on twitter, you may have noticed what I was going on in my life and that I did't get hit by a bus...

So what was going on since I returned back home from the MySQL Conference? First off, I uploaded und sorted my pictures from the conference and the Drizzle developer day on Flickr. I also uploaded the slides (PDF) from Colin and myself speaking about "MySQL Server Backup, Restoration, and Disaster Recovery Planning" to the MySQL Conference site and they are now available for download from the session page.

On May 4th and 5th I attended the amoocon in Rostock, Germany - a conference primarily about Open Source Telephony and VoIP, where I gave two talks (in German) about MySQL HA Solutions and MySQL Backup and Security Best Practices. There were several other MySQL-related sessions at this conference (e.g. Geert speaking about MySQL Cluster) and I was quite impressed to learn about how widely used it is in the VoIP/Telephony sector. The PDFs of my slides for both talks are available from the conference web site as well as on my slidespace on SlideShare (a very convenient service that I recently started using). There even is an MP3 and video recording of the HA talk, which is also linked from the session page mentioned above.

Right after the amoocon, I attended the next09 conference, which took place in Hamburg, Germany. On the first day I helped manning the Sun booth for some time (Sun Startup Essentials Germany was a sponsor of the event) and listened to some talks, on Wednesday I gave a presentation about "Working for a Virtual Company: How do we do it at MySQL?". A video recording of my talk is available from sevenload. Last time I checked the video was truncated, but I hope they will publish a complete version of it soon. Unfortunately I had a very bad speaking slot - the very first one in the morning (9:00am), after there was a party/social event going on the night before... But luckily there still were ~20-30 people in the audience. This was the first time that I gave this presentation and talked about something less technical, which was actually quite fun! As for the other recent talks, the slides are on SlideShare.

From May 14th to the 16th I was in Verona, Italy to speak about MySQL Backup and Security and bzr - The Bazaar source revision control system at the Italian phpDay. This was quite a nice event with ~150 attendees and Rasmus Lerdorf giving two talks as well. However, many of the sessions were in Italian, so I decided to spend some time walking around the city and taking lots of pictures. I also took a number pictures from the conference, but the light was pretty dim in the room and many shots turned out to be too blurry. Next year they plan to have the phpDay in Rimini - I definitely plan to be there!

A (slightly belated) Happy New Year to you! I just returned from my Christmas vacation two days ago, which I spent mostly at home and with my parents-in-law in St. Radegund, Austria. Now I am busy catching up with what has piled up during my absence (I managed to resist the temptation to check my work email during the time off).

Some MySQL-related news that came up in the past weeks and are worth sharing:

• My talk about MySQL HA solutions has been accepted in the main FOSDEM conference track
• The FOSDEM organizers also accepted my lightning talk proposal about Bazaar - it will take place on Saturday, 14h20 (tentative)
• MySQL will have a project stand, that we will share with the OpenSolaris Community. We're still looking for one or two more volunteers that would help us manning the table! If you would like to help out, please register here!
• MySQL will have a developer room at FOSDEM on Sunday. We will be in Room AW1.126 (72 seats) and the session schedule looks great already! We're still working on the fine tuning and scheduling.
• We've almost finished with creating a Japanese version of Planet MySQL (some minor encoding quirks remain to be fixed) and I finally got rid of the remaining parts of code that still used MagpieRSS (only in the admin backend parts) - now everything uses SimplePie instead.
• Dups added the MySQL Buzz to Planet MySQL
• I'm also working on sending out invitations to various MySQL-related projects to represent and showcase their work at the DotOrg Pavilion of the MySQL Conference Exhibition Area. Currently we have confirmation for attendance from Drupal, phpMyAdmin and Sphinx. What other projects would you like to see there? I am open for suggestions/applications

Quite a lot of exciting stuff going on, and more to come. This is a great start into the new year!

This is more of an "behind the scenes" update and I hope that you won't see any (negative) changes on the PlanetMySQL front page or the RSS feeds: I just finished and commited the conversion of the backend script that performs the parsing and aggregation of feeds from requiring MagpieRSS to SimplePie.

This will provide better support for a wider range of feed types and should also fix a few quirks, e.g. that some postings (for example the one from Kevin Burton) only showed up as an "A" in the Planet's RSS feed. It hopefully also fixes a weirdness with time zones that some people were reporting, but this requires further investigation.

The size and complexity of the script was reduced significantly because of this change - SimplePie is a breeze to use in comparison to MagpieRSS and it's very well-documented. The developers provide some more reasons and a comparison on why you should also make this switch!

And in case you notice anything broken or weird on PlanetMySQL that might be related to the change, please let me know! This change was an important step for future improvements of the site.

Tomorrow (Thursday, 11th of September) at 9:00 PST/16:00 UTC/17:00 GMT/18:00 CET, there will be an new free MySQL University Session. MySQL University started as an internal training program for MySQL engineers, to share and spread knowledge about their areas of expertise and has been available to the public for quite some time now. It covers a wide range of technical topics around the MySQL Server and usually takes place once per week.

For the first time, the presentation will not be performed by (former) MySQL employees/developers, but by two of our "Sun Classic" colleagues: Jyri Virkki (OpenSolaris Web Stack community lead) and Murthy Chintalapati (Sr Engineering Manager, Web Stack development) will talk about the OpenSolaris Web Stack:

OpenSolaris Web Stack is an OpenSolaris project and community building an integrated stack of popular open source web tier infrastructure technologies such as Apache HTTP server, MySQL, memcached, PHP and Ruby On Rails optimized for Solaris platform. This session introduces OpenSolaris Web Stack, its status and future development including addition of newer technologies such as lighttpd, Varnish etc., as well as the ease of use features for developers and deployers. We will also be discussing an experimental web stack IPS package repository and it could be leveraged to build and make available popular end user applications such as Drupal.

MySQL University sessions are free to attend - all you need is an IRC client (to post your questions and comments) and an audio player capable of playing back an OGG audio stream, so you can listen to what is being said. See the Instructions for Attendees on the MySQL University pages for more information on how to log in and attend. The audio stream will be recorded and published on the MySQL University pages for later consumption, in case you can't make it or want to listen to a previous session.

 

One of the sessions at DrupalCon I attended was Larry Garfield's talk about "Drupal Databases: The Next Generation", which gave me a good insight into the current state of the Drupal database layer and how they plan to overhaul it for Drupal 7. The key points that I took away:

• A new API based on PDO
• Object-oriented, requiring PHP5
• Support for using prepared statements
• A unified access API
• A query builder
• More support for other database systems (currently Drupal supports MySQL and PostgreSQL only). In particular, they are keen on adding SQLite support, to ease local development.
• Support for master-slave replication (by randomly distributing reads among the hosts)
• Support for using different database types in parallel (e.g. using SQLite for read-only tables, MySQL for everything else)

The slides and a video of the presentation are available, if you want to check it out. There is a task list on the Drupal.org web site that keeps track of the ongoing activities.

The MySQL 5.1 Use Case Competition is in full swing - we've already received a number of cool and interesting submissions, which we will turn into articles that will be published on the MySQL Developer Zone over the course of the coming weeks. Today we received a note from Jakub Vrána from the Prague, Czech republic. He's the author of phpMinAdmin, a MySQL management tool written in PHP. Here's what he wrote:

In the beginning of September 2008, I have implemented MySQL 5.1 Events to the database management tool phpMinAdmin. I've used the Windows version of MySQL 5.1.26 for the development.

As phpMinAdmin tries to be full-featured, yet compact management tool, I have implemented Events to allow users of MySQL 5.1 manage it.

The implementation was quite straightforward, it took only 4.5 kB of PHP code. Events management is well described in MySQL documentation and easy to understand.

During the development, I've reported three bugs: Bug#39163, Bug#39165, Bug#39173. I have been positively surprised by the speed of reaction to these reports

Thank you very much for your submission and the support, Jakub! We appreciate it.

If you're reading this and are using MySQL 5.1 and any of it's new features: have you considered telling your story yet? You may even win something when doing so!

Just to remind you that Packt Publishing is running their Open Source CMS Award again:

The Packt Open Source Content Management System Award is designed to encourage, support, recognize and reward Open Source Content Management Systems (CMS) that have been selected by a panel of judges and visitors to www.PacktPub.com. Now entering its third year, the Award has established itself as an important measure for quality and the popularity of Open Source Content Management Systems.

You have two more weeks to submit your favourite CMS in the following categories:

• Overall Winner
• Most Promising Open Source CMS
• Best Open Source PHP CMS
• Best Other Open Source CMS

As for the last two years, I'll be a member of the team of judges that have to choose from the finalists that received the most nominations during the nomination stage.

I look forward to the list of finalists - it's always interesting to find out about new developments in this area and how the established projects in this market have developed over the course of the year!

I just got informed that two of my session proposals for DrupalCon 2008 got accepted - I will be speaking about the following topics there:

• MySQL Backup and Security - Best practices
• High availability solutions for MySQL: An Overview and practical demo

The second talk will be held in cooperation with Jakub Suchy, who will take over the practical demo. Sun Microsystems is a Gold Sponsor of the event and I am glad that we can show some support for this truly amazing and vibrant community CMS. DrupalCon 2008 will take place from August, 27th-30th in Szeged, Hungary. The list of proposed talks looks truly impressive! Among the key note speakers will be Dries Buytaert and Rasmus Lerdorf. I look very much forward to this conference. If you have a chance, make sure to attend it!

While we're on the topic of Bazaar - this week I got informed by the organizers of the FrOSCon 2008 conference that they accepted two of my talk proposals: one session will be an introduction to this source code management system (what a coincidence), the other one will be an introduction to OpenSolaris for Linux users, explaining some of the underlying technologies and how they differ from what a seasoned Linux user may be accustomed to.

And no, I have not given up on using Linux - quite the contrary! I have been very impressed by the latest OpenSUSE 11.0 release and already run it for since quite some time on several of my work systems. In fact, I already convinced several colleagues of mine to give it a try as well! I am amazed by the speed and "out of the box experience" of this version and I actually plan to install it on my Genesi Pegasos PowerPC machine as well, replacing Debian on there. But as a Sun employee, I of course have to familiarize myself with the other products and projects that we're involved in. And on the Server side, Solaris does have a few interesting features that Linux currently lacks. But I digress.

I look forward to speaking at FrOSCon again - it has been a great conference in the past two years. Very well organized, nice venue, a relaxed atmosphere and excellent technical sessions and speakers.

Other MySQLers submitted talks as well - for example, Giuseppe will give a presentation titled "MySQL Community How To", Susanne will give a PostgreSQL tutorial and others will participate in the separate PHP subconference. Don't miss it - this year's FrOSCon will take place on August 23rd&24th in St. Augustin, Germany (close to Bonn). For the first time, we will also try to set up a MySQL project table. So if you are there, make sure to stop by and have a chat with us!

 

A bit late in the game, but maybe somebody would be interested in working on this proposed project of mine:

PlanetMySQL currently is merely an aggregator of submitted RSS feeds, with some functionality for filtering content to keep the discussion on topic. Due to its high volume of posts, many gems get "lost in the noise" and are hard to retrieve.

We'd like to expand the functionality of PlanetMySQL significantly to provide more possibilities for community participation and interaction. For this project, we are looking for a talented PHP hacker to set up a site that provides the current functionality and more:

• Voting on articles/blog postings: it must be possible for logged in users to cast a vote on articles, similar to the Perlmonks.org voting system. This would allow providing different RSS feeds, e.g. only articles that have a certain rating and rankings for articles and authors. Positive votes accumulate and increase the "karma" value of the individual author as well as identifying the quality of a particular posting.
• Archiving/Tagging/Searching: it must be possible to add tags to the aggregated blog postings, to ease the searching of older articles and to facilitate the creation up of a searchable "Community Knowledgebase"
• Authentication: User logins must use the same username/password pair as MySQLForge and the rest of the mysql.com web site (to reduce duplication and allow better integration with other parts of MySQL Forge, e.g. the user profile page)
• Optionally, it should be possible to comment/discuss on the aggregated articles directly on the new PlanetMySQL site. These comments should be sent back to the original blog via Trackbacks (if applicable)
• It should be possible to group feeds from multiple, different authors as a "Team Feed", to allow rankings by Team/Group in addition to the ranking of individuals
• The site must provide Unicode support to allow the handling of postings in multiple languages (e.g. Japanese, Chinese)
• New feed submissions should not be subscribed automatically, but rather should be reviewed by a moderation team first (to avoid spam and off-topic feeds)

The implementor should first make an assessment if these new functions should be developed on top of the existing code base, or if it would make sense to rebuild the existing functionality plus the new features on top of an existing PHP Framework (e.g. Drupal, Silverstripe, Symfony or similar). Making use of Web2.0 techniques (AJAX) is encouraged, if it makes the site easier to use and visually appealing.

Please contact me directly (firstname at MySQL.com) or the mailing list, if you are interested in working on this task. Thanks!

 

Yesterday, Drupal 6.0 was officially released - check out this screencast to get a 29-minute tour on the new features in this release.

We'd like to congratulate the Drupal Developer Team and Community for reaching this milestone and are happy that the MySQL Server continues to serve well as the database backend for this awesome content management platform!

I had the pleasure of evaluating and reviewing a previous release of Drupal for the Open Source Content Management System Award from Packt Publishing and it has been one of my favourites.

Keep up the good work!