Postgresql has powerful full text indexing and searching capabilities which you can use.
Here are a few links: http://es.scribd.com/doc/92440874/Schatten-SQL2012 http://www.espace.com.eg/blog/2009/03/15/postgresql-an-ultimate-strategy-for-full-text-search/ http://www.slideshare.net/billkarwin/full-text-search-in-postgresql http://linuxgazette.net/164/sephton.html Regards Johann On 27 July 2013 19:49, Alan Etkin <spame...@gmail.com> wrote: > https://github.com/mdipierro/**web2py-haystack<https://github.com/mdipierro/web2py-haystack> >> > > Works fine with sqlite and a trivial case > > ################## Haystack insert test ################## > Test time: 0:00:00.398590 > done > > ################## Simple haystack test ################## > Searching for "grape" keyword for both name and description ... > Records matching the query: 0 > Now searching for "grape" keyword in name and "grapefruit" in description > ... > Records matching the query: 1 > Thing table records: 4 > Average description length: 1596 > Average description words: 276 > Total index records: 560 > "grape" index records: 1 > "grapefruit" index records: 1 > > How about making this a gluon module? > About the name, given that haystack is one of the options, maybe the > module could be something like gluon.contrib.search > > -- > > --- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to web2py+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- Because experiencing your loyal love is better than life itself, my lips will praise you. (Psalm 63:3) -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.