Use the command described in the tutorial to find complete CREATE TABLE SQL statements for MySQL tables.

If you are faced with a situation where you need to find if your MySQL Database server supports partitioning or not then follow the instructions described in this tutorial.

It is sad to see how 9X% (or should that be 99.X%?) of SQL applications are riddled with SQL injection bugs.

There really is no excuse for this. Nobody writes code like this:

sub stupid_sum {
    my ($list) = @_;
    my $string = shift @$list;
    for (@$list) {
      $string .= " + " . $_;
    }
    my $sum = eval($string);
    return $sum;
}

Right? Just because our computers use the Von Neumann architecture, where CPU instructions and data is stored in the same memory, does not mean that we cannot distinguish between code and data (ok, so in TeX we do not, but there is a reason TeX is not pleasant to write applications in).

So when we use …

Would you like to know how JRuby, NetBeans, GlassFish, and MySQL can power your Rails applications ?



This informative technical webinar explains the fundamentals of JRuby and how the NetBeans IDE makes developing/debugging/deploying Rails applications on GlassFish quick, fun and cost-effective.

The webinar starts 10am PT on Jan 27th, 2009 and can be accessed from a browser.

Register here.

…

Would you like to know how JRuby, NetBeans, GlassFish, and MySQL can power your Rails applications ?



This informative technical webinar explains the fundamentals of JRuby and how the NetBeans IDE makes developing/debugging/deploying Rails applications on GlassFish quick, fun and cost-effective.

The webinar starts 10am PT on Jan 27th, 2009 and can be accessed from a browser.

Register here.

…

It’s easy to decide that you’re going to store changes to your database in source control, but it can be difficult to figure out what and where it should be stored.  In this article I’ll explain what I like to see put into source control, and how I layout my source control folders. There are […]

I'm trying to figure out for a friend what results in something like this

Restart the MySQL server and then run the query once. Then check the status variables.

Created_tmp_disk_tables = 0
Created_tmp_files = 362
Created_tmp_tables = 2
Sort_scan = 0
Sort_merge_passes = 0

What could be creating all those tmp files? It's not sorting on disk....

Learn how to extend your existing MySQL based website to leverage the power of MySQL variants, AWS cloud based MySQL deployments and RDBMS alternatives. Evaluate how to integrate and use these different various technologies such as MySQL based variations KickFire, a column based optimization and InfoBright, a data warehousing solution. Understand the means of approach towards data synchronization between various database solutions in your business.

At the MySQL Meetup in New York this month, I spoke on “Extending the MySQL Data Landscape“. A MySQL centric view on an earlier work, “The Data Landscape” which I presented at a recent GoDaddy Tech Day.

You can download the presentation on my Presentations page.

Good news!

DBD::mysql

I have a new co-maintainer who is going to help out with DBD::mysql, particularly with Windows build issues with Strawberry Perl. His name is Matthew Wilson. He "works part-time for a hedge fund maintaining predictive market models. " and I'm looking forward to working with him to improve DBD::mysql.

Things on the agenda for DBD::mysql :

* Build issues, particularly with Windows
* Any bugs that need fixing
* Change to a new SVN server, as well as get moved to Launchpad

Memcached Functions for MySQL

New release this week, 0.8. Numerous fixes, particularly to behaviors functions. They will work now!

Thats all for now. I'm in the middle of writting a book, so must get back to work!

So, a colleague ran into issues booking the Santa Clara Hyatt Regency Hotel—apparently there were no rooms with 2 double beds left for the MySQL 2009 Conference and Expo.

I could not imagine that the conference hotel would sell out so quickly!

The conference’s travel/hotel web page links directly to the online reservations page at http://santaclara.hyatt.com/groupbooking/clara2009orea.

I went there and did a little detective work. What I found was:

• When I chose Mon Apr 20 - Thu Apr 23, there were rooms with 2 double beds available.
  
• When I chose Sun Apr 19 - Thu Apr 23, there were rooms with 2 double beds available.
  
• When I chose Sat Apr 18 - Thu Apr 23, there were rooms with 2 double beds available. …