First I'd like to say - I absolutely like the way that MySQL
QueryBrowser is supposed to work! All the windows can very easily
be arranged so that everything's in sight (one one screen) that's
necessary to write complex queries - I can e.g. show the results
of a query in one screen, open the field lists of the tables that
I need, so this way, everything's available that I need to write
big queries (including complex joins) without the need to switch
between different screens. I haven't found another programm
(neither for MySQL, nor for PostgreSQL) that makes the work of
query writing more comfortable!
However, since version 1.1.15, evil bugs have found their way
into QueryBrowser. For some time, it wasn't possible to drag and
drop a table name into the result area to immeditely show the
contents of a table. In one version, it wasn't possible to open
the window to write a Stored Procedure or User Defined Function.
And in another version …
MySQL has announced two very useful new features for versions
5.1.5 and 5.1.6.
5.1.5 will get new XML capabilities and 5.1.6 will be able to
schedule event tasks. That will be very
helpful to clean up outdated data, for example - a task that had
to be done on the client side so far, but now it can be delegated
to the database server.
I still wonder if MySQL 5.1 will introduce check
constraints, as this is still another thing that still has to
be done on the client side, although it would be useful to
transfer this to the database server.
Another thing that should abolutely be in 5.1 are separate
privileges for trigger creation and deletion.
If these both features, together with the …
So it seems that my original plan of just a few RCs for MDB2 did not go through. I am now at RC4. I have spend alot of time over christmas just reading the source up and down. That way I found a number of bugs and ugly spots that I fixed within those 4 RCs.
Also I am very happy that most PEAR developers have accepted my patches to add MDB2 support. This means that soon most PEAR packages should provide MDB2 support. Especially Mark Wiesemann has been very helpful in prodiving feedback and patches as he was expanding my original patches for DB_Table. This has helped alot in finding little bugs as well problem in the way we were handling the "seqname_format" and "idxname_format" option with legacy databases not created with MDB2.
I encourage everyone to play around with MDB2 so that we can uncover any potential internal deficiencies that may still lurk somewhere in the code. I am really trying to solve all kinks that might lead to BC …
[Read more]
Hey all,
I hear that the collective "you" are annoyed by all of the
technical bits on this blog. So I've decided to move non-personal
blog entries to my movable type server at mt.colliertech.org.
Specifically, work blog posts will be made to
http://colliertech.org/~cjcollier/mysql/
If this works well and I start making lots of posts, I will have
the planet mysql aggregator point to the new atom feed:
http://mt.colliertech.org/mysql/atom.xml
good fun, that. For those of you who don't read this blog to get
new and juicy bits of information about MaxDB and MySQL, rest
assured that posts to this blog will now be easier to consume :)
Hey all,
I hear that the collective "you" are annoyed by all of the
technical bits on this blog. So I've decided to move non-personal
blog entries to my movable type server at mt.colliertech.org.
Specifically, work blog posts will be made to
http://colliertech.org/~cjcollier/mysql/
If this works well and I start making lots of posts, I will have
the planet mysql aggregator point to the new atom feed:
http://mt.colliertech.org/mysql/atom.xml
good fun, that. For those of you who don't read this blog to get
new and juicy bits of information about MaxDB and MySQL, rest
assured that posts to this blog will now be easier to consume :)
In this article, I'll give a preliminary description of a new MySQL feature for scheduling and executing tasks. In version 5.1.6, MySQL has added support for events. That is, you can now say: "I want the MySQL server to execute this SQL statement every day at 9:30am, until the end of the year" -- or anything similar that involves any number of SQL statements, and a schedule.
In the tradition of my 2003 and 2004 highlights, I'm posting my personal highlights of 2005. As in years past, this is mainly for my own benefit. I hope everyone has a wonderful 2006. :-)
- Launched the PHP Security Consortium (31 Jan)
- Interviewed for the first time (01 Feb)
- Launched Brain Bulb (28 Feb)
- Spoke at PHP Quebec for the first time (30 Mar - 01 Apr)
- Spoke at NOAA's IT Security Conference for the first time (04 May)
- Spoke at php|tropics (now …
Last week my laptop crashed and while installing the new one I decided to update my perl versions. I mainly use the DBD::mysql and DBD::Oracle modules and although I'm confortable building them on Linux/Unix, like most people I use the Activestate binaries on windows.
However it turns out that Oracle licensing changes now prevent Activestate from distributing an Oracle binary, so I was forced to build them from source. It wasn't easy, but now both the Oracle and MySQL modules are working. Here's the procedure in case it helps anyone.
Install Pxperl
Firstly, you probably want to move to the pxperl windows binaries. Pxperl support the familiar CPAN system for updates. Get Pxperl at www.pxperl.com. The installation should be straight forward.
I installed into c:\tools\pxperl
Install MinGW
You'll need a C compiler capable of building native windows binaries. I used the MinGW system. You can't …
[Read more]
I have lights on the front of my house!
Its been 15 months since that has been the case! I even have
a
ceiling light in the entrance way. Sure... no ceiling, but I have
a
light!
Amazing, my house now won't look like some sort of scary
haunted
house from the street.
In other news I added bittype support to the archive engine in
MySQL.
Eight characters to create.
Just have to love low hanging fruit....
I have lights on the front of my house!
Its been 15 months since that has been the case! I even have
a
ceiling light in the entrance way. Sure... no ceiling, but I have
a
light!
Amazing, my house now won't look like some sort of scary
haunted
house from the street.
In other news I added bittype support to the archive engine in
MySQL.
Eight characters to create.
Just have to love low hanging fruit....