Hacker News Reader

I'm not a DBA and, without bothering to RTFA, I'm going to guess the answer is along the lines of "use unique indexes"?

That's not nearly as much fun as reimplementing the functionality yourself.

Not really :)