I wonder if someone has some tips on joining a ferret search with a
database.
I have a rails project using a postgresql backend and I would like to
utilize the superb performance of ferret for fulltext searching.
The problem is that I have to joined the result with the database as
I have some user access rights to different documents to take into
account.
Does anyone have any ideas how to do this easily?
MAybe a cool stored procedure in PGSQL that can utilize the ferret
index
Were you able to figure this out?
Would you share your approach or code?
send me an email to aboxfortheotherstuff at gmail dot com
Thanks
Henrik Z. wrote:
I haven’t had the time to look at all the details yet. I’ve done some
testing on single tables and it works really good.
The problem is that I have a really really BIG sql query at the
moment which I run through find_by_sql so it will take me some time
to get that one working with find_by_contents.
I’ll post any progress to this list.
Cheers,
henrik
27 feb 2007 kl. 05:50 skrev caman:
This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.