A couple of weeks ago I got an unhappy email from my web
hosting provider telling me I was in violation of their Terms of
Service. Of course I called them immediately and was told that
there was a “phishing page” hidden in one of my web directories.
My blog had been hacked, so I immediately started doing some
house cleaning.

After the initial once over and deletion of any suspicious files
I went looking for advice on how to “harden my installation”.
Here’s what I found:

I just applied the external stored procedure patch to a branch of
MariaDB and uploaded it to LaunchPad.You can see the branch at
https://code.launchpad.net/~atcurtis/maria/5.1-wl820Note that
this is not in any reasonable condition to merge into MariaDB.
Hopefully we can engage in dialog as to how we can bring this
feature properly to MariaDB, MySQL and Drizzle, hopefully making
the plugins

It appears that LaunchPad.net is pretty slow.So that people can
have something to play with, I have transferred files to my own
web site.Presentation files:UC2009_presentation.zipSource
downloads:mysql-5.1.34.tar.gzmysql-5.1.33.tar.gzPlease don't melt
my router.... kthanx.

Files used in conference presentation here: UC2009 presentationI
think todays presentation for Perl Stored Procedures for MySQL
was quite successful. The audience was quite engaged and asked
questions throughout (yes, I invited questions through the talk).
I made sure to mention Eric Herman's Java plugin because even
though he didn't get time to submit a talk, the work is
noteworthy. Sometimes I

Finished my presentation earlier this afternoon. I had a better
audience than last year and there was interest in the download
URL for the source tarballs so I hope to see people hacking on it
soon.The link to the presentation is here.There has been lots of
good communication with staff from MySQL^WSun
Microsystems^W^WOracle so maybe we shall see this code to begin
to be integrated soon. In other

I have synced the codebase with the 5.1.32 release of MySQL and
it appears to work just fine. Sometimes frustrating that Bazaar
takes a bizarre amount of time to do a merge.Download link for
the source tarball are available from LaunchPad Download.As an
experiment, I have built a Mac OS 10.5 installer package (x86
32bit) which I have also placed there. Took a bit of fiddling
about to discover how

Python support has
been added to the latest version of MySQL Workbench.

In addition to Lua, you can now write scripts and modules or
interact with the GRT shell using the Python language. The
integration allows you to use GRT objects and modules mostly in
the same way you would do with normal Python objects. The
built-in grt module contains everything related to
the GRT that’s exposed to Python, including:

custom types for GRT lists, dicts and objects

wrappers for GRT classes, that can be used and instantiated
as a normal Python class;

wrappers for registered GRT modules, that can be used like
normal modules;

a reference to the root node of the GRT globals
tree;

You can inspect these objects with the standard
dir() command and in some cases with
help(), to access the …

Using Perl, a stored procedure which counts to the same value is
obviously not going to be as fast as bytecode languages with JIT
compilers but it is a lot faster than MySQL's native SQL stored
procedures. These perl stored procedures are able to perform
dynamic SQL using the familiar DBD::mysql driver without any risk
of self-deadlock.

Of course, you can also write stored procedures in Java for many
databases but I haven't yet written the neccessary Type 2 JDBC
driver to perform a in-thread connection back into the database
server to be able to do sophisticated work with MySQL.

Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.