Home » Archive

Articles Archive for January 2004

Uncategorized »

[30 Jan 2004 | Comments Off on Updating views on multiple tables | ]

I think most databases are happy to update views that only involve a single table. But when you involve multiple tables, you have to provide a rule of some sort to tell the DBMS what to do when it can’t necessarily figure it out. Apparently Oracle will try to do an update on multiple tables, but the update will fail if there are issues. But as of Oracle v7.3, you can update views on multiple tables by using INSTEAD OF triggers.

Uncategorized »

[28 Jan 2004 | One Comment | ]

In his BuildLanguage Bliki Entry Martin Fowler says:
“Simple builds are easy to express as a series of tasks and dependencies. For such builds the facilities of ant/make work well. But more complex builds require conditional logic, and that requires more general programming language constructs – and that’s where ant/make fall down.

[I’ve] concluded … that a programming language is more the way to go and [that ant is] not a good UseOfXml.”
I have to agree that there have been many times that I have wanted to just use a programming language …

Uncategorized »

[27 Jan 2004 | Comments Off on Two cool features in C# that don’t exist in Java. | ]

Strongly Typed Generics

Uncategorized »

[20 Jan 2004 | Comments Off on Not-so-Extreme Programming | ]

Extreme Programming is a horrible name masking a great idea. People don’t want to have anything to do with it just because of the name. I think that is why the term Agile has become so popular now.
Extreme Programming is not so extreme. The extreme ends of the software methodology spectrum are no methodology and very heavy-weight methodology. Extreme Programming doesn’t get its name for being an extreme in the spectrum of methodologies. It gets its name from taking the practices that work well in software development and putting …

Uncategorized »

[9 Jan 2004 | Comments Off on Rewriting Software | ]

I’ve done two large rewrite projects and I have been involved in a several smaller ones. I have learned over and over again that a complete rewrite is the most difficult, most risky, and most costly approach.
My current client has a project that was moved from another department into the one I’m working for because of business (i.e. political) reasons. The existing application was written in Perl/CGI/Oracle and might be described as a “hack”. The database schema was not normalized, and they managed security through an archaic …