Managing SQL Drift: Ensuring Stability in Database Transitions

SQL drift is a significant challenge that occurs when SQL statements from an existing system produce unexpected results after migration to a new environment or system. These issues manifest in several critical ways: SQL statements may generate new execution errors, experience significant performance degradation, or yield differences in data integrity.

Read more

Web 2.0. Not to be confused with Internet2

What is Web 2.0? Well the definitions out there aren’t clear and precise. Tim O’Reilly from O’Reilly Publishing has a detailed description at http://www.oreillynet.com/lpt/a/6228 . (More notes from this below) His compact description is:

Read more

Quotes from Web 2.0 Conference Web Site

I’m writing something about Web 2.0, but I got distracted by the random header quotes that appear on the website at www.web2con.com . Never being a Simpon’s fan, but it reminds me of those sites out there with all Bart’s blackboard quotes.

Read more

JUnit 4.0 is getting nearer

For those Agile developers out there, JUnit requires no explaination. I’ve got CVS details and some examples in my JUnit 4.0 Tutorial.

Read more

A better approach to using China for software development

India and China are the next powerhouses of software development, simply due to the numbers, but I’ve never heard a good report (maybe I have to dig deeper). My recent experiences are with Australian companies placing call centres in these countries, and almost always the language barrier is a clear limit.

Read more

Further to the FireFox debugger problem

Installing the current version of Firefox 1.07 directly of course fixed my debugging problem. However, Firefox has now released 1.5 Available here. The problem is the debugger 0.9.85 is not supported in FireFox 1.

Read more

Handling SPAM

Well it’s not a new debate, thats for sure, and I have very strong views on this topic (especially blacklists and ISP’s restricting trade), as well as an approach to a new Protocol termed ‘Authenicated Mail’ or ‘amail’.

Read more

Blog Upgrade Time Again

Well, in the space of a few months, I’ve outgrown the previous Drupal version I was using for Blogs, which was a replacement of an earlier Blog implementation. The primary reason was better date based indexing, either by months, or calendar functions.

Read more

Degrees of Separation 1 – MySQL to Open Source Definition to 2005 Open Source Awards

I often when reading articles end up where I never started on the web. You can find some amazing things, and of course lose a lot of time. I think it’s about time to document my degrees of separation from time to time.

Read more

Responses to some Oracle v’s MySQL Questions

I was asked a few questions by a reporter thru a collegue, here is an extract of the discussion. 1) Based on your initial experience with Oracle Database Express Edition, what are your initial thoughts on the product in terms of meeting developer needs?

Read more

How can Oracle 10g Express Edition target MySQL?

As I mentioned earlier , is MySQL a target of the new Oracle 10g Express Edition. Maybe not specifically, but let’s assume it’s on the radar screen. What can Oracle do to woe MySQL users and developers?

Read more

Oracle 10g Express Edition Target Audience. Is it MySQL?

Just where is Oracle planning on targeting the new Oracle 10g Express Edition? The obvious answer would be to counter the arch nemesis Microsoft, and the low end product offerings, like the MS SQL Server and the low end free engine MSDE.

Read more

Oracle 10g Express, Free v’s Open Source and OFA

In lunching with an old Oracle Friend, the topic turned to Oracle 10g Express Edition, and we discussed the pros and cons for organisations. The first thing he asked me was, “Have you tried loading the database larger then the 4G limit yet”.

Read more

Sending email using PHP

I’ve had a number of recent inquiries about sending emails on a Web Form using PHP. The following examples using the core PHP mail() function. mail() syntax http://www.arabx.com.au/example/mail.php – View Source

Read more

Oracle for FREE

Oracle software has always been free to develop with, however to deploy you have to buy a license and for web apps, it could never be limited to users, it was limited to CPU’s and that was expensive.

Read more