Sure, ArcSDE (or whatever it's called these days) is pretty cool, but to be honest I've never seen it deployed in the wild on anything other than Oracle, and often in conjunction with Oracle Spatial. What I've heard is that while the technically support a bunch of databases, they're pretty in bed with Oracle and that is what it works best with.