Databases
More on Oracle Procedures Functionality (Part 2)
As mentioned in my earlier post Emulating Oracle Output Functionality, I’ll be speaking at the MySQL Users Conference on the topic of MySQL for Oracle Developers. Here is the second in a series of points regarding current MySQL Stored Procedures and Functions functionality.
Read moreCorrection to earlier MySQL Statement
I stand corrected on my earlier post Emulating Oracle Output Functionality (which I’ve updated) when I made a reference to MySQL catching up. That was not what I was implying, that MySQL had to catchup to Oracle.
Read moreA Basic MySQL Developer Installation
Given a new Linux Installation, the following is my recommendation for installation of MySQL for a experienced software developer giving flexibility in a development environment. Under normal circumstances, most distros include MySQL either in a default server installation or on the distribution CD’s.
Read moreData Modelling
I’m a data modeller. I specialise in this, and for a number of years on large projects I’ve been able to focus on this single task within the System Development Life Cycle of software development for several months at a time.
Read moreContributing to JMeter
As part of my using JMeter for the purpose of testing a new Transactional storage engine PBXT for MySQL, I’ve been investigating the best approach for handling transactions. Read more about earlier decisions at my earlier post Testing a new MySQL Transactional Storage Engine .
Read moreEmulating Oracle Output Functionality
Updated 28-mar-2006 There really is no way to do a comparision by numbers in features and functionality when it comes to Oracle and MySQL in the area of Stored Procedures and Triggers.
Read moreJust how many articles are at Planet MySQL?
I was trying to find an old article at Planet MySQL . One about a MySQL UDF to write to /var/log/messages. No luck. Anyway, there is no search option on the site, and the latest addition of 10 entries per page makes it difficult to review pages.
Read moreMySQL Forge
I was reading Zack Urlocker’s MySQL Workbench Beta article and was keen to look at the Extensible architecture. Not much detail yet in the Figure Stylesheets, Scripts and Plugins, which will be good when it’s there, however it lead me to another secret.
Read moreAnother dissappointing MySQL article
Another slightly disappointing article regarding MySQL, this one from a printed magazine. Below are my comments to the editor of Linux Format. The Dear Editor is an email link should others wish to make any comments.
Read moreAtomicity, Consistency, Isolation, and Durability = ACID
ACID is the key transaction processing feature for a RDBMS. Without this, the integrity of the database cannot be guaranteed. In Summary. Atomicity is an all-or-none proposition. Consistency guarantees that a transaction never leaves your database in a half-finished state.
Read moreTesting a new MySQL Transactional Storage Engine
As part of my A call to arms! post about a month ago, I’ve had a number of unofficial comments of support. In addition, I’ve also been approached to assist in the completion of a MySQL Transactional support engine.
Read moreLatest MySQL Versions under VMWare
I made reference previously to Testing/Trialing new MySQL Releases using VMWare. Well, I’ve just about completed my own Image for the lastest MySQL 5.0 (given I’m now running MySQL 5.1). I’m interested in sharing my experiences, and even providing some images for users if there is any demand out there.
Read more