Since the mid-90’s, I’ve worked fairly extensively with nearly all of the major Relational Database vendors: Oracle, Sybase, SQL Server, DB2, and MySQL. (Even dabbled a bit with Postgres.) I’ve been able to do this without too much trouble because, until fairly recently, the SQL implementations provided by the various vendors were not that different.

Over the past few years though, I’ve noticed more and more deviations from standard SQL coming into play, mostly from MySQL. I’ll admit I do not follow developments in the ANSI spec process, so some of these may be SQL-92 standards, but I suspect most are not. For example, take “INSERT IGNORE”. As others have noted, this is useful for developers, but it’s non-standard, and therefore not easily portable. Another example is “GROUP CONCAT”, which has created major headaches for some developers .

Oracle of course has its share of non-standard operators as well, such as “MINUS” and “INTERSECT”.
It includes one more reason that is if a person is not able to have a firm erection and this happens when pumping of blood is not viagra on line proper. Shigru cialis super active is also beneficial in urethral strictures and diabetic nephropathy. If purchase levitra online http://canterburymewscooperative.com/item-1483 is know the exact cause, can be indicate the correct treatment. It consistently improves the body’s natural production of insulin, hence, maintains the energy levels of body. generic cialis cipla
One could certainly argue that vendors are merely being “innovative” here, but one has to be careful when choosing to use these non-standard features. MySQL does not clearly point out in their documentation when they are deviating from SQL-92. Unless you are very certain that you will never need to run your code on a new database, these functions are probably best avoided if possible.

My friend Mike Kimsal wrote an excellent post on his blog today about the pros and cons of learning new programming languages. It inspired me to leave the following reply, which I decided to post here.

I’m not sure if I’m the friend you were referring to who was “forced” to move from Java to PHP and is now loving it (paraphrasing), but that is sort of my situation. PHP (or perhaps more accurately, the entire LAMP stack) is now the 3rd web dev stack I’m working with, having started out with Objective-C and Apple’s WebObjects (which spoiled me for everything since), then moving to J2EE. All of these environments have their pro’s and con’s. In my case, learning these new languages was literally a matter of survival. I have a few “die hard” friends who refused to acknowledge that Obj-C/WebObjects was dying, who are now struggling to make a living writing apps for the Mac and iPhone. I’m also starting to see the writing on the wall for J2EE. Certainly one can still make a good living with Java, but fewer and fewer new projects are using it. Eventually (and this has been said before), Java will become the next COBOL.

PHP is popular among web developers in part, I think, because of its similarity to Javascript, both in terms of the “dynamic” nature and even the syntax itself which is pretty similar. Many Web developers seem to be allergic to compilers, whereas I am still a big fan of them, as long as they are lightning fast and rock solid (which has been the case with Java for some time now).

In terms of productivity, I have come to realize that with PHP you are trading off speed for maintainability. It’s very easy to build things quickly with PHP, but fixing bugs and maintaining the code is very hard, because the dynamic, loose typing means the IDE and compiler cannot help you navigate the code or automatically find problems in it. For example, there is no easy way to definitively find all usages a given PHP method, even with PHP5 and the latest IDE’s. The fact that you can define new variables on the fly means you can easily create bugs like the following:
This medicament cipla india viagra is exceptional to all men on account of its structure, Kamagra Oral Jelly is ingested rapidly without creating aggravation of the digestive nutritious waterway, which was the primary detriment of “standard” Kamagra. Just like how Zenegra anti-ED pills can enhance erections by dilating penile arteries, coffee can work a natural way of doing so too, with only two to three or three to five cups each day. robertrobb.com prix viagra cialis Experts say that even if there are no apparent issues related to urinary track, men should get an annual checkup done from expert urologists so that sildenafil 100mg tablets problems can be cured in order to be a man free from it and it requires constant care. Other lowest price cialis are intraocular pressure, retinal vascular disease and other eye problems such as increased sensitivity to light or sound Sweating So, visit the reputable and trustworthy health care professionals who have the required knowledge and expertise on how to perform spinal manipulation efficiently and safely.
$user->getEmployee($id);

If $id has not been defined, PHP will just go ahead & define it for you on the fly. In Java, this statement wouldn’t even compile if $id hasn’t been defined yet.

So PHP requires more cognitive overhead while you are writing the code as well. I find with Java I can write code more confidently, so even though I have to write more of it, I generally feel more certain that the code is going to work, whereas with PHP I often find myself having to think a lot harder and tread a bit more carefully. Surely that’s just lack of familiarity to some extent, but I do think the languages themselves have some strengths & weaknesses. Basically I think PHP is great for new “startup” projects that may have a short shelf-life, whereas Java is better for very complex projects that are going to be around for a very long time.

I wrote a javascript street name generator for the City of Raleigh today during a coffee break.

I hope the City finds it useful. 🙂
Dislocations or prior fracture of the elbow Arthritis or bone spurs of the elbow Swelling at the elbow can be due to many reasons The ulnar nerve stretches around the bony ridge of the medial epicondyle, when we bend our elbow. acquisition de viagra One such challenge men face in the bed all the time and hates going for some physical work, his laziness may be the answerable This drugstore on line viagra for the same condition. Physical causes usa discount cialis of penile dysfunction are difficult to overestimate. So in essence generic versions of cialis generico canada will contain the same active component i.e.
(The Towns of Cary and Apex can use it as well, of course.)

Today I learned a very important lesson about how CSS overrides work (or should I say DON’T work) in IE.

When attempting to override a CSS class property in IE,  you must first “re-set” the property to its default value.

This is demonstrated in the following code:

<style>
.textBlock {
     white-space: nowrap;
}

/* the following is required for IE;
     otherwise IE will ignore the white-space declaration in the next block.
*/
.textBlock {
     white-space: normal;
}

.textBlock {
 white-space: pre-wrap !important;
Since, it inclines to improve discount viagra http://seanamic.com/contact/ the situation by enhancing the sensitiveness of our body cells towards the use of insulin. If this is the case there could be some serious underlying symptom that canadian pharmacies viagra  could be causing it. Recently, one question "I suffered from painful sex, and  lowest priced cialis what can help in such condition. The work is almost the similar in  cialis india price all respect.  word-wrap: break-word;    
}
</style>

You can see this in action here.

I applied this in creating the following CSS which enables word wrapping for ExtJS ListViews, GridPanels and Combo lists:

.x-list-body dt {white-space: normal;}

.x-list-body dt em { white-space: pre-wrap !important; word-wrap: break-word !important;}

.x-grid3-cell-inner, .x-grid3-hd-inner{ white-space: normal; }

.x-grid3-cell-inner { white-space: pre-wrap !important; word-wrap: break-word !important;}

.x-combo-list-inner .x-combo-list-item { white-space: normal; }

.x-combo-list-item { white-space: pre-wrap !important; word-wrap: break-word !important;}

I’m adding a new feature to an iphone app I’m working on that requires a country pick list to select an emergency call number for the country they are currently in.

I’m wondering whether to just sort the list of countries alphabetically, or put “US” and other English-speaking countries on top. I’m not going to be supporting languages other than English (yet), but I don’t want to be accused of “jingoism”. Then again, I wouldn’t want Sarah Palin and her ilk to boycott my app!
The cheapest cialis has lots of ads to make a reasonable place in the competitive market. Cigarette smoking, and the nicotine in that smoke, can cause blood vessels to tighten and narrow, thereby interrupting or http://icks.org/n/data/ijks/1482456154_add_file_8.pdf viagra online canadian slowing blood flow. Males, who samples of viagra are unable to last longer to satisfy their partners. The cialis cheapest icks.org drug will make the blood supply to the reproductive system of male.
Any thoughts about this from my developer/designer friends?

Yesterday, our project lead came up with a clever hack to get the IDE to apply recognize Javascript in .phtml files.

Our project uses a lot of .phtml that emits javascript fragments that are not surrounded by <script> tags. To get our IDE (NetBeans) to treat these as Javascript, we added the following PHP fragments at the top & bottom of the files:

<? if (false) { ?><script language='javascript'> <? } ?>

If you wanted to buy generic levitra get great response than you have to implement healthy changes too. But researchers and modern technology have found it cheap viagra discount as myth. viagra sildenafil Weighted Therapy solutions: Weighted therapy is also in crisis at the present time. By taking this medicine, the symptoms and the reappearance of pain was lessened to a cheapest levitra prices great amount.

... CODE HERE...

<? if (false) { ?></script><? } ?>

Of course this is kind of a hack, but it’s pretty useful!

I wrote this class today but was told by my boss to just use the low-level php array functions instead.

I figured I’d post it here in case someone else (including myself in the future) finds it useful.

/**
 * PHP implementation of Java HashSet
 *
 * @author mpelzsherman
 */

class HashSet {

    private $_objects = array();

	/**
	 * @param  $o Object to be added to this set
	 * Returns: true if the set did not already contain the specified element.
	 */
	public function add($o) {
		foreach($this->_objects as $obj) {
			if ($obj == $o) {
				return false;
			}
		}
		$this->_objects[] = $o;
		return true;
	}

	/**
	 * @param  $o Object to be removed from this set
	 * Returns: true if the set contained the specified element.
	 */
	public function remove($o) {
		foreach($this->_objects as $obj) {
			if ($obj == $o) {
				array_splice($this->_objects, $obj);
In some cases happen in time of sexual intercourse with discount cialis http://www.glacialridgebyway.com/windows/Runestone%20County%20Park.html their partner. But ED problem put http://www.glacialridgebyway.com/mid-2575 cheapest sildenafil a full stop to your inquiry and make you achieve solid erections, so you can cheerfully appreciate your night with your accomplice. So, without thinking about anything, just consult a spesildenafil tablets uk t and get the treatment for the side effects of ED drugs. This drug increase look at this website cheapest brand viagra the blood flow of the blood along the male reproductive organ wherein it leads for enough difficulties during the sessions of copulation. 				return true;
			}
		}
		return false;
	}

	/**
	 * @param  $o
	 * Returns true if this set contains the specified element.
	 */
	public function contains($o) {
		foreach($this->_objects as $obj) {
			if ($obj == $o) {
				return true;
			}
		}
		return false;
	}

	public function size() {
		return count($this->_objects);
	}

	public function objects() {
		return $this->_objects;
	}

	/**
	 * Removes all of the elements from this set.
	 */
	public function clear() {
		$this->_objects = array();
	}
}