Even though my first experience with a DB was with DB2 at the university what I ended up using at home, at first, was MS SqlServer 2000. As my project needed some sort of hierarchical category system I wanted to create a table that is self referencing itself and can do ON DELETE and ON UPDATE CASCADE triggers. Unfortunately MSSQL2K did not support this feature (I don't understand how you can do any reasonable graph data structure without it) so I had to make some scamontage tricks (google for CELKO tables and nested set) that I didn't like. I eventually tried the same thing with DB2 and it seems to work but it's out of the question as it's not free. It seems that mySql for the moment has a limit on the recursion depth of the triggers. What surprised me is that it seems PostgreSql supports such tables so at the moment it looks it'll become my favorite DB.

Comments

Velvet said…
if yer gonna learn how to live- italia is the place to learn!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
8/06/2005 8:05 PM
Post a Comment

Popular posts from this blog

Kaspersky Anti Virus 6 and Subversion problems

I've spent a good part of my day today in trying to understand why I can't checkout our subversion repository. I was getting this: svn: REPORT of '/svn/repos/!svn/vcc/default': 400 Bad Request google searches would make you think it's a proxy issue but I don't use or need one so after a lot of trial and errors I've found out that if you use Kaspersky Anti-Virus 6 it seems that if you use the Web Anti-Virus options with the recommended settings and you have the "Scan HTTP traffic" option on you end up with the problem above. It seems Kaspersky doesn't like the HTTP packets subversion uses so they get blocked. I really like Kaspersky and I recommend it to all but I hope they will address this issue as soon as possible as subversion is becoming the main open source VCS system. Any tips on this issue are welcome.
Read more

Relaxing SSL validation for JaxWS

I've recently had the need to access a web service developed in .Net and signed with a self signed certificate. I've decided to use the JaxWS and the Metro stack to develop the client and run it on Java6. As a plus, the service was protected with username and password. The service was exposed on an IP address and I repetedly had problems in establishing a connection. In the end, thanks to this article, it was obvious that the certificate was not created with the alternative name attribute but it was not an option to change the certificate as the web service was already used by other consumers (.net clients don't suffer by this issue). So, on my quest to relax the validation, I've found out this article and code snippet, which did not compile at first (I guess package names were changed in JDK6) so I've did some trivial refactoring and now, after invoking the static methods in the client code, the SSL connection gets validated with no problems. Hope it helps and th...
Read more

Search and Replace in ODT using AODL

Recently I needed to create a way to search and replace a word in a OpenOffice OpenDocument ODT. It would seem the project itself already has a library AODL (take care, at least two other project pages but with older code) that exposes the format model but I didn't find any utility methods like search and replace functionality. I've created two versions of the method, one a old-style, imperative approach, and the other, a LINQ version. As I'm still new to LINQ it would seem that the classical approach produces a more efficient code. Anyone care to chip in and make a faster algorithm? In this particular version I'm just going for simple string equality, I didn't want to go with other StringComparison methods (just look at the Equals overload method). public static void SearchAndReplaceString(TextDocument document, string searchText, string replaceText) { var content = document.Content; foreach (var item in content) ...
Read more