Given these models: class Listing(models.Model): features = models.ManyToManyField('Feature', related_name='listing_details') comments = models.TextField() class Feature(models.Model): feature...

Im using the gem pg_search to perform fulltext search on my postgres db. I've a scope like this: pg_search_scope :fulltext, against: [:firstname, :lastname, :middlename], using: { tsearch: { pre...

I have installed UnaccentExtension in Django but I'm having problems using it with this search: vector = SearchVector('title__unaccent', 'abstract__unaccent') query = SearchQuery(word) | SearchQue...

When using the LIKE/ILIKE operator in PostgreSQL 9 is it possible to match word boundaries without having to use full blown ~ operator regular expressions? For example SELECT 'Super fast training...

I am trying to figure out the concept of elastic search index and quite don't understand it. I want to make a couple of points in advance. I understand how inverse document index works (mapping ter...

Can it be possible to configure Elasticsearch in such a way, that it will keep all data in RAM (like Redis in-memory cache)? What I need is additional speed while querying data. If anybody has expe...

I have installed the latest version of scylladb and cassandra in my centos os. i have tried allow filtering in select query but i don't need it, I want advance search or full text search in it, i h...

Let's say we have an Employees table with a full text index on a Note field. We can search that table using a query like this: SELECT ID FROM Employees WHERE CONTAINS(Note, 'scout') However, if ...

Has anyone here have any experience deploying a real online system that had a full text search in any of the NoSQL databases? For example, how does the full-text search compare in MongoDB, ...

When I use ts_rank with a ts_query that contains multiple terms with an & operator proximity of terms affects the ranking and creates results I wasn't expecting. An example: select ts_rank(to_...

Is it possible to persist a joined field with Djangos SearchVectorField for full text search? For example: class P(models.Model): brand = models.ForeignKey(Brand, on_delete=models.CASCADE) sear...

I try to implement a search-mechanism with "CONTAINS()" on a SQL Server 2014. I've read here https://technet.microsoft.com/en-us/library/ms142538%28v=sql.105%29.aspx and in the book "Pro Full-Text...

Read Query In Posgres, Full text indexing allows documents to be preprocessed and an index saved for later rapid searching. Preprocessing includes: Parsing documents into tokens. Converting toke...

I need a pure Java program to search on a given string to "find words near each other" - each-other distance need to be specified. More specifically said :- finds word1 and word2 in any order, as l...

I am facing an issue when doing full text search with PostgreSQL on text that contains de Spanish character 'Ñ' When I try to tokenize the Spanish word 'AÑO' (year) I get the following results dep...

I want to create a Full Text Search that accepts emojis on the query, or another type of index to search on text. For example, I have this text: Playa 🌊🌞🌴 @CobolIquique h' and PostgreSQL parse i...

I'm sorry to ask such a noob question, but the postgres documentation on views is sparse, and I had trouble finding a good answer. I'm trying to implement Full-Text-Search on Postgres for three ta...

I want to use MySQL's full text search features using JPA, without having to use a native query. I am using EclipseLink, which has a function to support native SQL commands: FUNC. However, the he...

Suppose I have two columns, keywords and content. I have a fulltext index across both. I want a row with foo in the keywords to have more relevance than a row with foo in the content. What do I nee...

I would like to be able to search every word so I have cleared the stop word list. Than I have rebuilt the index. But unfortunately if I type in a search expression with stop word in it it still re...

I have a problem in Arabic Full Text Search in SQL-Server, this link says that we can use Arabic in full text search. To describe more, I've enabled full text search on one of my columns which con...

I have a search page which contains two search result types: summary result and concrete result. Summary result page contains top 3 result per category (top hits) Concrete result page contains al...

Django's documentation for the PostgreSQL full text search uses the following example: >>> Entry.objects.filter(body_text__search='Cheese') [<Entry: Cheese on Toast recipes>, <En...

I would like to create text index on mongo collection. I write db.test1.ensureIndex({'text':'text'}) and then i saw in mongod process Sun Jan 5 10:08:47.289 [conn1] build index library.test1 {...

I've reindexed my Sphinx search with /usr/local/sphinx/bin/indexer --all --rotate and renamed my original index output files to something else. Simply changing the index argument passed to $sphinx-...