Hacker News new | ask | show | jobs
Flickr-like ticket server in ~100 lines of Perl (~8k tickets/s) (github.com)
19 points by cosimo 5384 days ago
3 comments

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...

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 ;)
You could've cloned the repo and started hacking on it in the time it took you to write that.
Damn you for undermining my snarky comment. Cheers.
Merged too.
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!