Autocomplete with Python, Pylons, SQLAlchemy and jQuery

Recently I needed to implement my own autocomplete for a project on snagmachine.com. We had a large database of products and wanted to ease data entry by hinting to the user via autocomplete when possible.

In future, we can probably just use Freebase Suggest but right now we needed our own solution.
The Pieces
Autocomplete is not [...]