Interesting Question :) - Well, since I am using both MySQL and
Postgres, I have implemented Full-text searching for both paradigms,
this is really more in the database side and it really relies on the
indexing of the available data. This can indeed be an issue with non-
RDBS and the fact that my experience is limited to traditional
database model systems, Full text searching in PostgreSQL is based on
the match operator @@ and in MySQL in the FULLTEXT() index function
allowing me to do things like "SELECT * FROM questions WHERE MATCH
(title,body) AGAINST ('search string');" for search, and as you may
already realized, I am not using the DAL for this, unfortunately.
For the above I have a small "temporary" wrapper class to mimic
web2py's SQLRows objects and try to not deviate too much from the
"standard", but search indeed has became a bit of a headache, I am
definitely open for ideas, though,
Thanks!
Julio
On Sep 6, 4:45 pm, mdipierro <[email protected]> wrote:
> really nice. Can you tell us how you implement search?
>
> On Sep 6, 5:40 pm, Julio Schwarzbeck <[email protected]> wrote:
>
> > Pleased to inform the community that I finally had some time to
> > heavily work on one of my web2py pets, pyStack is coming along quite
> > nicely and it is being developed as we speak, pyStack is a SO
> > "inspired" system developed in the best web framework available for
> > Python nowadays :)
>
> > pyStack aims to be a very SIMPLE version of SO, with all the fat
> > trimmed down to the basic functionality, yet it'll contain all the
> > expected features such as subscriptions, voting (including voting on
> > comments), role-based and heavy administration regarding Q&A postings,
> > the code will be open source of course and currently is at 60%-65%
> > completed, I have a couple of screenshots on my blog (done in web2py
> > also :) if you want to see something visual
>
> >http://www.techfuel.net/zblog/blog/view/27
>
> > Cheers,
>
> > Julio
