Showing entries 1 to 10 of 12
2 Older Entries »
Displaying posts with tag: MySQL Forge (reset)
eulogy for mysql forge

When the mysql librarian closed, I didn’t think too much about it; it was a feature I probably never used. However this month brings the end of the mysql forge. The MySQL Forge was something I worked on while I was at MySQL so I am a little sad to see it go. 

Now for a little bit of a history lesson. We wanted some kind of “forge” back in 2005, because sourceforge was all the rage then (today, you can’t even find mariadb or mongodb listed there). We didn’t want to pay the exorbitant fees associated with sourceforge, so we investigated …

[Read more]
Vote for Kontrollbase on MySQL Forge

Just a reminder to all of those users that are enjoying Kontrollbase – if you get a minute in your day please go to the MySQL Forge site and put your vote in on Kontrollbase. It’s a simple star based vote on the right side of the page located here: http://forge.mysql.com/projects/project.php?id=318

Update: Find Query Per certain Seconds

In my old post there is a bug when run in MySQL 5.1.30 and old, because the status variable Queries was added in MySQL 5.1.31. So i change to choose between Queries and Questions status variables, and I think the Queries represent more accurate result.

http://forge.mysql.com/tools/tool.php?id=217

By the way:

# Queries The number of statements executed by the server. This variable includes

Starring Sakila: MySQL university recording, slides and materials available onMySQLForge

Hi!

Yesterday I had the honour of presenting my mini-bi/datawarehousing tutorial "Starring Sakila" for MySQL University. I did a modified version of the presentation I did together with Matt Casters at the MySQL user's conference 2009. The structure of the presentation is still largely the same, although I condensed various bits, and I added practical examples of setting up the ETL process and creating a Pentaho Analysis View (OLAP pivot table) on top of a Mondrian Cube.

The slides, session recording, and materials such as SQL script, pentaho data integration jobs and transformations, and Sakila Rentals Cube for Mondrian are all available here on MySQL Forge.
Copyright Notice
Presentation slides, and …

[Read more]
Kontrollbase is on MySQL Forge

Spread the word; Just added Kontrollbase to MySQL Forge: http://forge.mysql.com/projects/project.php?id=318

Kontrollbase is on MySQL Forge

Spread the word; Just added Kontrollbase to MySQL Forge: http://forge.mysql.com/projects/project.php?id=318

Case Insensitive REPLACE() for MySQL

One request I occasionally see is for a case insensitive version of REPLACE() for MySQL. I wrote this a while back, but here it is now for all of you to play around with. It uses a basic naïve string search algorithm, so can be slow under some circumstances.

DELIMITER $$
 
DROP FUNCTION IF EXISTS `replace_ci`$$
CREATE FUNCTION `replace_ci` ( str TEXT,needle CHAR(255),str_rep CHAR(255))
    RETURNS TEXT
    DETERMINISTIC
    BEGIN
        DECLARE return_str TEXT DEFAULT '';
        DECLARE lower_str TEXT;
        DECLARE lower_needle TEXT;
        DECLARE pos INT DEFAULT 1;
        DECLARE old_pos INT DEFAULT 1;
 
        SELECT lower(str) INTO lower_str;
        SELECT lower(needle) INTO lower_needle;
        SELECT locate(lower_needle, lower_str, pos) INTO pos;
        WHILE pos > 0 DO
            SELECT concat(return_str, substr(str, old_pos, pos-old_pos), str_rep) INTO return_str;
            SELECT pos + char_length(needle) INTO pos;
            SELECT …
[Read more]
Google Summer of Code 2008 Update

phpMyAdmin and MySQL Forge, along with the MySQL Build Farm initiative were the main MySQL related benefactors of Google Summer of Code 2008. phpMyAdmin got BLOB Streaming support and a simplified setup script, MySQL Forge got RSS and Atom feeds and the MySQL Build Farm got a test schedule.

Directly mentored by phpMyAdmin originator Marc Delisle, GSoC student Raj Kissu Rajandran completed the BLOB streaming support in phpMyAdmin. This is how he describes his project goals (which are now achieved):

It is often common to come across a website, especially a blog, that is built on a pairing of MySQL and PHP. Seeing as how most of those who run such websites on the Internet do not have access to a Shell account or have experience in managing applications from the command-line, …

[Read more]
Moving from MySQL’s Contributor License Agreement (CLA) to Sun’s Contributor Agreement (SCA)

Today is Good News Day. In addition to my note on Ivan Nikitin’s improved health, I have good news for our current and potential code contributors:

We have moved from having used MySQL AB’s own Contributor License Agreement (CLA) to now using the Sun’s Contributor Agreement (SCA), which is shorter and easier.

I’ve been asked about our contributor licensing on several occasions, such as back in July, at MySQL Camp in Bangalore, India, as Parvesh mentioned in his blog.

The MySQL Contributor License Agreement (CLA) was an agreement that we asked patch and feature contributors to sign …

[Read more]
Another Quick Feature Added to MySQL Forge

Calvin had a good suggestion for a search filter in the public worklog system on the targeted version that the Worklog task is aiming for. I have thus added the filter to the Forge search pages, as shown to the left. You can select from the dropdown list of versions in the top of the search column and the search will filter automatically to only tasks targeting that version. Cheers.

Showing entries 1 to 10 of 12
2 Older Entries »