Don't Use HttpUtility.UrlEncode for Anything But Wiping your Butt


Like written so many times before, HttpUtility.UrlEncode is extremely outdated and buggy. It doesn’t encode the single quote (’), there’s an open bug marked “Closed (Won’t Fix)”. So don’t wait for a patch. It doesn’t encode the plus sign (+) either. So please use the AntiXss library whenever it’s remotely important to get it right. Needless to say, same goes for the other encoding methods of HttpUtility, like HtmlEncode.…
Read more ⟶

Pasha Answers Questions from Troubled Amazon.com Users


I’m starting to think they should have licenses for owning a keyboard. Because people have too much time lately. And fast internet. Amazon now has a “Customer Discussions (beta)” section on the product page. Here’s a snapshot of something I stumbled upon just now: Lets try to help the lost souls, shall we: Q: I’m a lesbian but I believe in God what should I do? Don’t tell Him. And don’t tell your girlfriend.…
Read more ⟶

Nine Facebook Realizations


1. People without a picture are lazy or ugly or both. Trust me, no one looks like a question mark. 2. I don’t want your fucking slayers invitations. Nobody wants them. So pretty please, stop this crap. 3. Girls look much better on facebook than “on” uniform. 4. What’s up with girls that don’t list relationship status? Or “interested in”. Or birth year. It’s hard enough to pick your signals anyway, so what am I supposed to think when all you say is “Born: May 15th”?…
Read more ⟶

Announcing khjgf.com


I’m proud to announce the newest addition to the bitz family of quality web products - khjgf. Frequently Asked Questions Q: Is this a result of a “weekend-experiment”? A: Somewhat. Q: Is this a result of mind-altering substances? A: Likely. Q: Is this a part of some secret-society-taking-over-the-world kind of thing? A: Maybe. Q: Are you mad, mate? A: I’m affraid so. More on Madness at pashabitz.com: Scrum Lovers…
Read more ⟶

MySQL: Slow Query When Joining with a Union


The MySQL query optimizer has trouble with queries that contain a join to a union. Lets take a look at the following example: select u.f1, u.f2 from (select t1.f1, t2.f2 from t1 join t2 on t1.f3 = t2.f3 union select t3.f1, t2.f2, from t3 join t2 on t3.f3 = t2.f3) u where u.f2 = ?val Now, suppose we have an index on column f2 in t2. If you look at the explain plan, you will see that MySQL does not use it.…
Read more ⟶

8 Reasons to Join Semingo Now


1. Work on something really big. I mean so big, it’s a hubris to even think about it. 2. Our product is related to social networks, so if your boss catches you staring at good-looking girls (or boys) in Facebook, you can say “It’s for work” and he will beleive it. 3. Pool table at work. (May be taken away from us any day now, so hurry up!!) 4. Work with really smart people.…
Read more ⟶

"Access Denied" Error When Trying to Configure IIS 7 on Vista


Problem: I get an “access denied” error message when trying to save some change done to a web application in the IIS manager on Vista. Possible solution: Windows Vista comes with a new version of IIS. One of the new things in IIS 7 is that it saves it’s configuration in the .net web.config files (previous versions used the “IIS metabase”, which is a bunch of files internal to the IIS configuration tool).…
Read more ⟶

Radiohead New Album "In Rainbows" - Selling Music The Right Way


This is so cool. I just bought the new Radiohead album, “In Rainbows”. What’s so special? The album is available only by direct download from a website set up by the band (http://www.inrainbows.com/). Everybody wins: 1. The buyer - finally, I can legally download music from the internet (iTunes and the like do not allow downloads with a credit card that is issued in Israel). 2. The seller - Radiohead bypass the record label, and probably profit more for each album sold.…
Read more ⟶

MySQL .Net Connector Bug


I’ve stumbled upon (what appears to be) a bug in MySQL .Net Connector (version 5.1.3). I opened the bug in the MySQL bugs database, you can read the details here - bug #31617. Basically, when calling MySqlCommand.ExecuteReader with an sql statement that times out - you get back a closed MySqlDataReader and the underlying MySqlConnection becomes corrupted, meaning you cannot use it for new operations and you cannot close it either.…
Read more ⟶

Scrum Lovers


There is a strange, underground, free-mason, rappers-delight, a-tribe-called-quest, thank-you-chuck-norris, scrum-lover-association-kind-of-thing taking shape as we speak. For some reason, Moti and Oren simultaneously posted some seriously weird posts with some scrum mambo jambo in them. Moti even added some scary Egyptian-writing-stlye codewords in the end. And then, of all things, they tagged me to be a “scrum clan member”. Well well. And I thought this blog doesn’t take itself seriously. If this is some sort of scheme to make me write something I don’t stand behind, well, you got another thing coming, boys.…
Read more ⟶