Trudy has posted to MySQL Forge the design that we are planning for pluggable authentication and authorization. Internally we are not working on this at the moment but we have had others ask what the roadmap is in terms of adding support for Roles, LDAP, and etc. The pluggable authentication system is a good project for someone who wants to learn the MySQL server's source code and it is a project that will enable additional projects.

Here is the link to the current design, feedback is welcome:
http://forge.mysql.com/wiki/PluggableAuthenticationSupport

If you are interested in what MySQL is planning, then you should keep an eye on MySQL Forge. We will be publishing more of our design docs in the future. At the moment we don't have a good way to make everything public in our project tracking tool, but we are working on making …

I just saw this article:
http://opensource.sys-con.com/read/261119.htm

It quotes from the personal (not corporate!) blog of Simon Phipps, Sun’s chief open source executive. The first time I heard Simon speak out on patents was in November 2004 at an FFII conference in Brussels. A couple of months earlier, I had criticized him in the forum of NoSoftwarePatents.com in a way that I later on regretted. Even though the NoSoftwarePatents campaign was highly successful, there are three or four things that I shouldn’t have said or written during those days, and what I said about Simon’s credibility has the top spot among that list of things.

Anyway, Simon has now said that “today’s software patents …

Yesterday I sent out the invitations for our third MySQL User Group Meeting in Hamburg, which will take place on Monday, 4th of September (which is the United MySQL Meetup Day). As usual, we will meet at 19:00 in the Chinese Restaurant "Ni Hao" - the food is excellent and we can use a separate room with a video projector there. If you happen to live around Hamburg, Germany and would like to join, please RSVP and join our mailing list!

Currently I am still pondering on the topic of the presentation - I suggested to invite Paul …

A few years ago I started an open source project called mondrian. I had been building some business intelligence applications, and had taken a liking to OLAP. I was hoping to see OLAP applications popping up here and there, on websites, in desktop applications like Quicken, and it just wasn't happening.

I soon figured out why. OLAP was cool, but it was complicated and the software was expensive. These two facts are not unrelated. If you're a software vendor who has just developed a cool new technology, you're going to want to charge a lot of money for it. But your customer, who is paying a lot of money for it, wants to see a lot more in the box than a CD and some packing peanuts. So, the software tends to get expensive, to match the customer's expectations.

Now, don't get me wrong. Business Intelligence is a complicated process. It involves getting a business …

so turns out that the ruby on rails developers had already added 4.1 authentication support for their bundled version of ruby/mysql, but they?ve found the upstream maintainer as unresponsive as i have. their implementation wasn?t quite complete, so i?ve submitted a patch to round it out.

the version included with ruby on rails doesn?t include the test suite, though.

About every second application I look at has some tables which have redundant or duplicate indexes so its the time to speak about these a bit.

So what is duplicate index ? This is when table has multiple indexes defined on the same columns. Sometimes it is indexes with different names, sometimes it is different keywords used to define the index. For example it is quite frequite to see something like
PRIMARY KEY(id), UNIQUE KEY id(id), KEY id2(id)

The logic I heard behind this often - create primary key as object identifier, now we create UNIQUE because we want it to be UNIQUE and we create KEY so it it can be used in the queries. This is wrong and hurts MySQL Performance. It is enough to create PRIMARY KEY and it will enforce unique values and will be used in the queries.

The other case is simply having multiple keys on same column(s) - I guess someone thought key would make sense while did not …

SciBit is proud to announce the release of MyReporter CGI and ISAPI for Win32 platforms.

Changes:
* Fix: IIS ISAPI relative directory issue. The CGI and ISAPI behaviors are now identical and all templates can be positioned relative to the MyReporter directory.
* Enhanced: Faster emailing facilities
* Add: Emailing now allows for display of the report or redirection to a URI of your choice
* Add: Support for the newest MyCon 2.10 report engine

For more information. examples and downloads see: MyReporter

For previous releases, see:
MyReporter v3.0

While Web 2.0 is probably at least as hard to define as pornography (e.g. I know it when I see it) there's no doubt that it's growing rapidly.  By our estimates, more than 90% of all Web 2.0 sites are powered by MySQL including the likes of media darlings like YouTube, FaceBook, Digg, Wikipedia, Cyworld, Flickr and most of the social networking sites.  In fact, if you add in all of the sites using MySQL it's probably over a billion page views per day and doubling every six months. 

And if you don't like Tim O'Reilly's definition of Web 2.0, then you can …

automation, best practices, database, internet, technology, tips web

http://www.artfulsoftware.com has a “Common Queries” page, which I find rather useful. I hadn’t realized its history, as described on the homepage:

Our collection of common MySQL queries outgrew Chapter 9, and is still growing, so we turned it into a PHP page driven from a MySQL table.

We’ve released new bits for the beta of solidDB for MySQL. We now have a version compiled for 64 bit Linux. Check it out at http://dev.soliddb.com/download/