On The Margins

Tuesday September 22, 2009

[ Announcements ] More on Derby

Kristian Waagan and Rick Hillegas, both Derby committers and members of Sun's Java DB team, have given a couple of recent presentations to an international conference and a San Francisco Java users group. These are now available on YouTube, as Francois Orsini, another member of Sun's Java DB team, notes in his blog. 

2009-09-22 15:30:36.0 -- ; Permalink ; Trackback.
apache databases db derby java

Wednesday August 19, 2009

[ Technology ] Advancing MySQL Open Development One Important Step Forward

Giuseppe Maxia writes about the availability of the active development/test ("pushbuild") MySQL binaries for users—on multiple platforms.

This is a wonderful step forward in bringing greater openness to current MySQL development and in bringing greater value to the MySQL user community!  

2009-08-19 00:27:17.0 -- ; Permalink ; Trackback.
binaries current databases mysql pushbuild technology tests

Monday August 10, 2009

[ Announcements ] ADO.Net Entity Framework on MySQL

Reggie Burnett, the lead behind MySQL Connector/NET, will be presenting a MySQL webinar, "For ISVs: ADO.NET Entity Framework for MySQL", tomorrow at 10 Pacific Time!

Among other topics, Reggie will discuss how to

• Develop your application against SQL Server and then switch it to MySQL with zero code changes

• Optimize your database schema without requiring any code changes in your application

• Use LinQ syntax for type safety in your applications

(Interest in using MySQL on Windows is growing. The 2008 MySQL OEM Annual Survey, which closed in March 2009, shows that some 73% of MySQL OEM customers develop applications on Windows, and some 59% deploy these applications on Windows.)

If you're interested in Windows programming with MyQL, do not miss Reggie's other upcoming webinar for Sept. 15: "For ISVs: What's New in MySQL Connector/NET 6.1".

2009-08-10 14:23:37.0 -- ; Permalink ; Trackback.
.net connectors databases microsoft mysql programming software technology web windows

Thursday July 30, 2009

[ Announcements ] Workbench 5.2 Alpha

In case you have not already noticed, Workbench 5.2 alpha / preview release of MySQL's premier development and design tool, has been announced.

For an independent preview, you can also see here. 

2009-07-30 10:44:29.0 -- ; Permalink ; Trackback.
databases design development mysql workbench

Wednesday June 24, 2009

[ Code ] Contributing to MySQL

If interested in contributing code to MySQL, you should attend the MySQL University session on contributing code to MySQL.

(Live broadcast with Q&A will be held on Thursday, June 25, 2009. You can still have access to rebroadcasts afterwards.)

2009-06-24 01:57:05.0 -- ; Permalink ; Trackback.
code community contribution databases mysql

Thursday June 18, 2009

[ Code ] Among the favorites

One of my favorite JIRAs on Apache is #Derby-646.

2009-06-18 23:12:12.0 -- Comments [1] ; Permalink ; Trackback.
apache databases derby java-db jira open-source

Thursday June 04, 2009

[ Persian (فارسی) ] Network Management Data Reduction and Smoothing -- A MySQL Webinar

ScienceLogic embeds MySQL in its EM7 network management appliances. An installation of EM7 can perform over half a billion database queries daily, storing massive amounts of data for both real-time and trended performance reporting.

Michael McFadden, senior software architect with ScienceLogic, will discuss all this in an upcoming MySQL webinar.

2009-06-04 15:57:24.0 -- Comments [1] ; Permalink ; Trackback.
analysis data databases learning management mysql networks software

Wednesday June 03, 2009

[ Announcements ] Java DB 10.5.1 is Released!

By now, it is already a 5-day-old news that Java DB 10.5.1 has been released!

Great team work and effort went into this release!

Thank you Kim Haase, Liz Drachnik, Hery Ramilison, Edward Ort and the Java DB engineering team!

Read more about it all on Knut Anders Hatlen and Francois Orsini's blogs.

2009-06-03 12:28:02.0 -- ; Permalink ; Trackback.
databases java software. technology

Thursday May 28, 2009

[ Java ] User Has It Right! ....

Kristian Waagan (of Sun's Java DB development team) has really given Java DB (Sun's distribution of Apache / Derby) a new life of its own when it comes to handling CLOBs, starting with Java DB 10.5.

Check out this thread. 

Note the following testimony from David Goulden:

The performance improvements with CLOBs are dramatic. I created a record with a CLOB containing about 10 million characters using derby 10.4. The following query took over 6(!) minutes:

       SELECT CONTENT FROM MESSAGES WHERE ID = 1

(CONTENT is the CLOB column.)

I then installed derby 10.5 and did a soft upgrade. The same query now takes less than three seconds!

2009-05-28 11:10:55.0 -- ; Permalink ; Trackback.
databases java java-db

Tuesday May 19, 2009

[ Announcements ] Webinar on the New MySQL Connector/C++

Tomorrow (Wednesday, May 20, 2009), Ulf Wendel and Andrey Hristov, engineers working in the Connector team of Sun|MySQL database group, will be presenting a webinar about the new MySQL Connector/C++. This connector, which uses much the JDBC API patterns, was recently made available as a GA release during the MySQL Conference and Expo.

Register from anywhere in the world and listen to Ulf and Andrey as they talk to you about Connector/C++ from somewhere in Germany!

Addendum: At this very moment, I'm attending this free Webinar. It is truly amazing how well-coordinated this is. So, if you couldn't get to this, try to make it to some other upcoming MySQL Webinar.

2009-05-19 12:39:43.0 -- ; Permalink ; Trackback.
connectors databases developers mysql open-source webinars

Sunday May 10, 2009

[ Business ] Sun Contributor Agreement and MySQL

On my last count, there are now 20+ Sun Contributor Agreement (SCA) signatories whose names appear on the master list and who are interested in contributing to MySQL. Only this week, three new members signed the SCA.

These 22+ signatories have all been added since mid-February when we launched the new, Sun-compliant SCA signing process. Before the end of 2009, if we proceed at this same rate, MySQL SCA signatories list should grow to about 70 to 90 contributors.

In the meantime, contributions from many of these contributors have already been accepted and integrated. (I had earlier pointed to Armin Schöffmann's contribution as a simple example of how all this works.)

Some people continue to wonder why an SCA is required.

First of all, it is important to note that by signing the SCA the contributor retains copyrights while also granting those rights to Sun as the project sponsor. This granting is very specific to a particular code base and the community around it. (This is a code base that has been available under GPL.)

Second, as I have summarized, in a series of Golden Rules for Open Source Contribution-Based Communities, several important rules for such communities help it to operate well. As part of rule G, "Setting Expectations," I did mention how

2. Anticipating the future and related risk management helps all market participants to reduce transaction costs.

However, I failed to add that an important ingredient in that risk management is the management of ownership claims.

I believe this particular aspect of rule G, which is implicit there, and which perhaps needs to be made more explicit, explains clearly why something like an SCA is required in order to maintain a flow of contributions to MySQL in a form that allows clear code ownership. 

Note that other open-source communities, such as the Apache Software Foundation, also require their own contributor agreement. Often, these agreements are there to protect the maintainers of the project/product or the general integrity of the products' ownership.

BSD-based communities seem to avoid this need by posting various clear signs in various places -- in their member-initiation or commit e-mails -- that all contributions are made under BSD. However, these communities have remained somewhat fragmented due to the greater openness of BSD licenses. Don't get me wrong. I love BSD. Note that often, BSD contriutors would rather contribute to a BSD project. The whole objective of contributing to a BSD project is that you are building a based that can be used by anyone for open and closed business with that same base. This is very unique to BSD type or Apache type licenses and forms one of the main reasons contributors contribute to these projects.

So, let's now go beyond the question of SCA and see what else is going on.

The update and simplification of SCA submission process for MySQL, came along with equally important simplification of forge pages for contributors and with an effort to speed up the review of contributions and continuting with greater openness in MySQL development processes. [These apparently fragmented but hopefully useful (and ultimately coherent) steps have all been part of a larger initiative to facilitate openness, community participation and contributions. Again, please refer to the Golden Rules. Hopefully, you can faciliate and help the MySQL community to get more open and vibrant as an open-source community.]

It is important to note, here, that roots of this initiative go back to some years earlier. So, the initiative is related in part to a continuing series of efforts to make MySQL more open and more contributor friendly, including the famous "quality contribution program," which was originally launched by the MySQL community team. (In a sensem the "quality contribution program" has evolved into this simpler, more robust model and many of the lessons learned there have also been applied and used here.)

Under the SCA, contributors can contribute to all MySQL open-source products in open forums and issue tracking "systems"-- internals list, bug tracking system, worklog system. I put quotes around "systems" because there's more to be done to make these systmes work better together in a more open environment. Note that the MySQL team prefers to receive code contributions and bug fixes through the first two modes because those two modes (i.e., bugs db issue tracking and the internals mailing list) better afford two-way communications. Note, too, that contributions can be at the level of bug fixes or features.

Why would anyone contribute?

Well, there's a great deal of challenge to contribute anything to a software as sophisticated and complex as a database.

Besides the reputational effects, there's also this practical effect that once a contribution has been absorbed, the contributor will no longer have to worry about constant merges to get the effect he or she expects form MySQL.

Of course, there are many other reasons as well. For example, there are those who are just problem solvers, and find it exciting to contribute to MySQL. However, let me stop speculating on this any further. Instead, let me point you to an "internals" posting by Stefan Hinz, regarding a "MySQL University" session on replication features in 5.1 and 6.0.

2009-05-10 23:32:36.0 -- Comments [4] ; Permalink ; Trackback.
communities databases development governance mysql open programming sca software

Friday May 01, 2009

[ Java ] JavaDB 10.5.1.1

Now, a new release of Apache/Derby is out.

Francois Orsini has a more detailed note on this. It is great to see that many of the features listed are developed by our small but amazing team of Java DB engineers.

(See my previous post about this cauldron where Java DB is forged!)

2009-05-01 23:45:35.0 -- ; Permalink ; Trackback.
apache databases derby java java-db

Thursday April 30, 2009

[ Technology ] Derby, the Cauldron and Java DB

Apache Derby project is the cauldron where Sun starts the forging of Java DB, Sun's distribution of Derby and the premier Java database in the world! Most recently, Knut Anders Hatlen, Java DB engineering and committer to the Apache Derby project, has been writing about the new features being shipped in Java DB 10.5.

It is important to know that Java DB is a project 3 years in the making, and we're now witnessing people interested in installing this database in hundreds of instances, in the middle tier of their applications. Java DB is particularly unique because it can easily be embedded with a Java application in a JVM. (Anyone who has studied Java somewhat closely should already be completely familiar with this fact.) 

You can review the derby-users list on Apache to discover the level of sophistication in the user community, or go to the derby-dev list on Apache to discover and contribute to recent ideas and development with Derby replication.

In one of his many Derby 10.5 preview blog entries, Knut describes the use of generated columns, and follows up on their usability in a particular example involving case-insensitive search.

2009-04-30 23:20:33.0 -- ; Permalink ; Trackback.
apache databases java java-db jvm software

Monday April 27, 2009

[ Code ] More Code Contributions to MySQL

MySQL has deep roots in open-source software development communities and code contributions to MySQL keep flowing in, being reviewed and integrated into the MySQL. 

During our BoF at the MySQL Conference and Expo, Lenz Grimmer talked about our work to make MySQL (even more) contributor friendly, with some more focused effort starting on February 1, 2009¹.

The desire to contribute code to MySQL remains as strong as ever as evidenced by this year's MySQL Conference and Expo, where I had an opportunity to speak with some contributors and partners who wish to contribute to MySQL. Of course, there are a lot of strong and varying opinions in this area.

As I said above, code has been contributed and absorbed in MySQL (according to either the MySQL CLA or SCA contributor agreements) for years now.

Examining just the patches and contributions submitted through the MySQL Bugs database, some 16 pieces of code contributions to MySQL have been absorbed into some version of the MySQL server in the first 4 months of this calendar year, and there are some 17 SCA signatories who are intent on contributing to MySQL.

As examples of code contributions being currently reviewed, one may point to two thread on "internals," one involving a review by Konstantin Osipov (contributor: Antony Curtis, WL#820) and another a review by Guilhem Bichot (contributor: Erik Ljungstrom). 

[1] February 1, 2009 was exactly 10 years from the day I started working for Sun Microsystems Inc., February 1, 1999, when I started in the J2EE RI development team.

2009-04-27 22:28:17.0 -- Comments [5] ; Permalink ; Trackback.
code contributions databases mysql open-source

Thursday April 23, 2009

[ Technology ] Workbench Rocking

Mike Hillyer talks about MySQL Workbench. Very nice workshop! (Hillyer will make slides and screen recording of his talk available.)

This is a great platform-native application. All presentation code is written for each specific platform. It is the second most-popular download and the second most purchased product in the MySQL online shop.  There's a community edition and there's a standard edition of the Workbench. People in the workshop got a 1 year subscription to the commercial, standard edition.

I'm sitting in the room here in MySQL Conference. I'm running a WB 5.1 edition I've built on my MacBook Pro laptop.

2009-04-23 15:09:47.0 -- ; Permalink ; Trackback.
data-modelling databases mysql tools workbench

Wednesday April 22, 2009

[ Technology ] Another Pluggable Storage Engine for MySQL

Kazuho Oku of Cybozu Labs, Inc., a community contributor to MySQL and SCA signatory, gives a talk on Q4M, a message queue stroage engine for MySQL.

2009-04-22 12:17:45.0 -- ; Permalink ; Trackback.
contribution contributor databases developer message messaging middleware mysql products programming queue storage

[ Technology ] Kaj Shoot Out on Cloud Computing

I'm sitting in Kaj Arnö's Cloud Computing Shoot Out here in the MySQL Confernce & Expo. Great panel, great discussion! The important question, always, is about business models related to storage vs. compute clouds.

2009-04-22 09:47:14.0 -- ; Permalink ; Trackback.
cloud-computing conference databases mysql

Friday April 17, 2009

[ Code ] A BoF on Community Code Contributions to MySQL

The BoF schedule for MySQL Conference and Expo (2009) is now published. Lenz Grimmer, Sergei Golubchik, Tomas Ulin and myself will be available during a BoF which focuses on MySQL Community Code Contributions. Lenz will be moderating. For background material, you may start here.

2009-04-17 22:12:34.0 -- ; Permalink ; Trackback.
code conference databases developers mysql programming technology

[ Networks ] A Real Student Bargain for JavaONe

This year, JavaOne let's students get in free!

Plus, they can sign up for CommunityOne at the same time.

Both passes are full conference passes with access to everything!

Educators can also get in free when they bring 10 students with them to the conference. If they aren't able to do this, they still get a fantastic deal of $895 for a full conference pass.

This is an unprecedented bargain and discount!

What is a Full Pass?

All the benefits of a FULL conference attendee, which includes: JavaOne general and technical sessions, panel discussions, HOLs (Hands-on-labs), BOFs (Birds-of-a-feather), the Pavilion and the After Dark Bash / Networking Mixer! Not to mention a "hang space" (which includes video games, movies & more!), plus you will be able to check email any time at one of our many hacker stations.

PLUS

Admission to the CommunityOne Deep-Dives. What does this mean? FREE training by our very own SLS on some really great topics, plus hugely discounted certification (vouchers will be handed out at the event)- certification can even be done on-site! There will also be numerous parties and chances for you to network with the best and brightest in the industry, from community leaders to "Rockstars" and everyone in between.

2009-04-17 01:25:29.0 -- ; Permalink ; Trackback.
databases java javaone open-source software technology

Wednesday April 15, 2009

[ Code ] Developing with MySQL Connector/C++

Giri Mandalika has written an article showing how to develop C++ database applications for MySQL and another article showing how to install MySQL Connector/C++ from the source.

2009-04-15 14:29:34.0 -- ; Permalink ; Trackback.
c++ connectors databases development drivers mysql programming