Flickr-like ticket server in ~100 lines of Perl (~8k tickets/s)

Hmm. I see "ENGINE=MyISAM" in the code. Nowadays I can't stomach using MyISAM for anything I care about not having some sort of corruption. Given sufficient time and scale, I've seen far too many issues with MyISAM.

It'd be great to be able to specify that in the code so the user can opt for InnoDB (or engine of their choice). Perhaps a pull request is in my future...

You could've cloned the repo and started hacking on it in the time it took you to write that.

Agreed.

https://github.com/cosimo/TicketServer/pulls

Damn you for undermining my snarky comment. Cheers.

Merged too.

I seem to remember that the MySQL behavior this is based on will only work with the MyISAM engine. In fact, Flickr is using MyISAM for this, IIRC. Anyway, your changes make perfect sense, so I merged them.

Will try what happens to the test suite with InnoDB.

Actually it works just fine ;)

I wasn't familiar with what 'Flickr tickets' were so I did a little Google-fu and found this excellent explanation:

http://code.flickr.com/blog/2010/02/08/ticket-servers-distri...

I had included a link to this post in the README file.

Very nice!