On Sep 5, 7:12 pm, mdipierro <[email protected]> wrote: > You use a relational database an you do not have too much data > (~10000) records you can do > > db(db.mytable.myfield.contains('text')).select()
This just does a basic search using the SQL "LIKE" operator, right? So no real search engine features like word stemming, relevance ranking, keyword highlighting, etc.? Since real search functionality is an important feature for many websites, it would be great if web2py could offer some easy to use options. I think MySQL and PostgreSQL both have some decent built-in full text search functionality, and then there are options like Sphinx, Lucene/Solr, etc. If web2py could provide some plugins, or at least some recipes in the book or on web2pyslices.com, that would be a big help. Perhaps it would be easiest to start with Postgres, since that seems to be a popular RDBMS for web2py and wouldn't require any additional software. Anthony
