We are implementing a product review site using Ruby on Rails. Search is a core component of the user experience. We need to make searches fast and relevant. Should we use Lucene or another open source search layer? Should we use Google's search API and index against only our site? Or should we develop proprietary search functionali...
I've created a blog and I wish to search through certain tables in my MySQL databases and then return results for the user on a separate search page. I do not wish to use Google CSE. How would I go about creating this for my site. I found a post on StackOverflow.com from a friend of mine in which he wished to make his more efficient. How...
Possible Duplicate: Creating a Full Text Index search. I've created a blog and I wish to search through certain tables in my MySQL databases and then return results for the user on a separate search page. I do not wish to use Google CSE. How would I go about creating this for my site. I found a post on StackOverflow.com from a...
This may sound a dumb question, can someone confirm that within a Free Text search that the query Word1 NEAR Word2 IS identical to Word2 NEAR Word1 ?? So that Word order is not relevant. I am trying to hit highlight the results and if this is the case I need to look for occurrences of the reversal of the original search term words. ...
I wuld like to do som automatic tagging of incoming text in our system and I was wondering if a full-text index is capable of providing a a ranked list of words given an indexed row. If not, do you have any suggestions on how to do this? We already have a system in place for auto tagging but its fairly brute-force (aka. slow) in its met...
I am developing Ruby on Rails application which uses Thinking Sphinx. Unfortunately, from time to time (few times per month) search tends to return bad results (many documents missing). Reindexing helps, but this is not a solution for production. I am experiencing bad results even when I am typing simple queries into rails console (like...
I need some tool which would allow me to run Sphinx queries. Sphinx provides search, a command line program which does the thing. However, search is reading Sphinx files and I need something what would connect to searchd instead. Do you know any tools I could use? ...
I have 3 tables Person, Names, and Notes. Each person has multiple name and has optional notes. I have full text search on some columns on names and notes (see below), they are working perfectly if the word i search with is in the result set or is in the db, this is for custom function,php, and psql. The problem now is that when the word...
I am using SOLR's ExtractingRequestHandler to ingest the text of documents. The examples in the documentation all use curl to stream documents, like so: curl 'http://.../extract?literal.id=doc1&commit=true' -F "[email protected]" That works just fine, but there is this note: using "curl" or other command line tools to p...
I am indexing posts in SOLR with "name", "title", and "description" fields. I'd like to later be able to add a file (like a Word doc or a PDF) using Tika / the ExtractingRequestHandler. I know I can add documents like so: (or through other interfaces) curl 'http://localhost:8983/solr/update/extract?literal.id=post1&commit=true...
I have a table Books in my MySQL database which has the columns Title (varchar(255)) and Edition (varchar(20)). Example values for these are "Introduction to Microeconomics" and "4". I want to let users search for Books based on Title and Edition. So, for example they could enter "Microeconomics 4" and it would get the proper result. My...
How can I implement full text search on app engine? I have read http://www.billkatz.com/2009/6/Simple-Full-Text-Search-for-App-Engine but this does not see to work anymore. ...
in the match - against am getting the correct results, there is no problem but the thing i want is the result combination. Like for "computer graphics" i am getting results for "+computer +graphics" as "computer" alone results and "computer graphics" results and "graphics" results and etc. Here i want "computer graphics" results first...
Hi, I am trying to search against a Database with MS Word Documents as BLOBS, full-text indexed (neutral language) an exact word or phrase contains dashes (for example : "-c-erb-B2"). The problem is that FTS works in a different way and break it, at "erb" and "B2" and results include additional records that documents include erb or B2....
Is there somewhere one can get the xml for the english thesaurus from the web (for mssql that is)? I'd really hate to populate it by hand... ...
Does anyone know of any prebuilt SQL Server (Ideally) Thesaurus for handling English (and maybe eastern european) name expansions ? Have a lookup thats runs as a full text query and it would be nice to be able to handle Chris --> Christopher Chris --> Christine Bill --> William Will --> William If you don't know of such a list; is t...
Hello, I have a database of song titles. Each song title has an assigned integer score. The higher the score the higher it ranks on my website. So if "Lady Gaga - Poker Face" has a score of 23039, and "Eminem - Not Afraid" has a score of 13400, Lady Gaga will be above Eminem. This is of course accomplished by a simple ORDER BY score D...
Hi, I have a mysql query as follows: SELECT *, MATCH(songtitle) AGAINST('{keyword}') as Relevance FROM links WHERE approved = "true" AND MATCH(songtitle) AGAINST('{keyword}' IN BOOLEAN MODE) ORDER BY Relevance DESC, score DESC LIMIT 5 This works generally as expected, but for certain queries it will not return the right results. It wo...
Hello all, I would like to implement a search function for my website as the functions listed here http://stackoverflow.com/search What should I do in order to do this? Based on my understanding, two methods can be used to provide search function for my website. 1> MySQL full text search 2> Use search lucene package. My guess is th...
I want to use the Full Text Search feature of Microsoft SQL Server. If I have a table Client which refers other tables like City, Country, Department, etc. is it better to create a separate table that would hold de-normalized data, which would then be full text indexed, or is it better to create a dummy value in every foreign table (for...