Reputation: 11663
How to write a database driven auto-suggestion search using python, mysql and jquery? Are there any relevant tutorials. Because Googling just gave me several results for PHP but not anything relevant to Python.
Upvotes: 3
Views: 2926
Reputation: 35970
Auto complete is generally implemented in a similar manner to spell checkers. Here's an article from Nick's Blog about Levenshtein Autonoma. It's written in python so you can follow along. I said generally before because while this will do spell checking and suggest similar names, it fails at anticipating where the popular queries are being done. For that, a naive approach would be a binary search tree where you've weighed the nodes based on the popularity of their search.
Upvotes: 2
Reputation: 11200
There is a nice jQuery plugin for this, http://docs.jquery.com/Plugins/autocomplete. To use your data with it, you need to write a controller in python that returns the autocomplete data as a JSON structure.
You also need to pick a good framework for writing the actual controller in, check this question for some good suggestions: Recommendations of Python REST (web services) framework?
Upvotes: 2