Articles Archive for January 2004
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.
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 …
Strongly Typed Generics
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 …
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 …