Category "full-text-search"

suggestions on fulltext search or already existing search algorithms

Can someone suggest how to solve the below search problem easily, I mean is there any algorithm, or full text search will be suffice for this? There is below cl

MongoDB Atlas Search Stage for newsfeed with GoogleRating, CurrentDate, LikeCount & CommentCount

I'm working on social media platform and I need to fetch posts for newsfeed with mongodb search query. currently I'm using dynamic index on my post collection,

Get mySQL full text match score for strings not in the table (optimally in a mixed result set with matches from the table)?

This must be a niche scenario since I have not been able to find a similar question around and in my brief testing in my SQL workbench just using the string in

How to make an accent insensitive `MATCH() AGAINST()` sentence?

I have a table called products which has a varchar column called name encoded in latin1_swedish_ci. I'm trying to make a search query in order to filter product

How to use like query on FullText Index Column

I have this user table structure. `users` ( `id` bigint(20), `balance` bigint(20), `current_parent` bigint(20), `parents` varchar(45

How to prevent PyCharm's "Find in Files" to search the Python interpreter libraries?

I am trying to find some pattern within files like my project's setup.py / setup.cfg', rio.yaml. Our code .. So within the Find in Files dialog I selected th

mongoDB search query taking long when I use regular expression and case-insensitive

I am using MongoDB\Driver\Manager my query is shown below. $globalSearchValue = 'Test'; $mongo = new MongoDB\Driver\Manager("mongodb://localhost:27017"); $b

Full text search failure on PostgreSQL

I have a PostgreSQL used to index text content. The SearchVector column is created successfully using the following code UPDATE public."DocumentFiles" SET "Sear

Laravel Scout (Meilisearch) - Says imported data, but doesn't

I've installed and configured meilisearch + Laravel Scout package. My Model: class Post extends Model { use Searchable; } When I run php artisan scout:impo

PHP - Check if string contains words longer than 4 characters, then include "+ *", and for those shorter than 4 characters include only "*"

I manage to do partially just one part, but cannot make the second part work. If a word has < 4 characters, only * should be included at the end of that wo

AWS Neptune FTS returns IOException on every federated queries to OpenSearch

I am trying to implement full text search on AWS Neptune (engine 1.0.4.2) with AWS OpenSearch. A GET amazon_neptune/_search on OpenSearch returns: { "took": 5

Setting ft_stopword_file back to default (built-in) without restarting MySQL

I need to test something by changing the ft_stopword_file without restarting the server. I know that SET GLOBAL works to change global variables until the next

Mongodb: Text Indexes vs Atlas Search

These two features look pretty simmilar, but Atlas Search is fresh and maybe more powerfull. Is Atlas Search a replacement for Text Indexes in MongoDb? Will Tex

Fulltext index match string with period (.) mysql

I have a few column fulltext indexed and i'm testing some string to search. My db contains cars components so my researches could be for example "Engine 1.6". T

Designing tags system with nosql/elastic search

I have to design a system with this schema. { "documentId" : 123 "documentType" : "paper" "tags" :["abc","xyz"] //other meta data of document } The queries

Can't join FREETEXTTABLE with typeORM functions

I'm working on a graphQL backend with TypeORM I found FREETEXT, CONTAiNS, FREETEXTTABLE and CONTAINSTABLE options for fulltext searching in my SQL database. As

SQL Server \ CONTAINS FORMSOF INFLECTIONAL Phrase \ Not Working as Expected

I am trying to use the contains operator with FORMOF INFLECTIONAL, but I'm not getting what I think is the expected result. Here is the query. This query is no

Most matching words in search query

I have user table (e.g. UserMst) is MySQL like UserID FirstName LastName FullName (expression column) ------ --------- -------- -----------------------

Most matching words in search query

I have user table (e.g. UserMst) is MySQL like UserID FirstName LastName FullName (expression column) ------ --------- -------- -----------------------

How do you full text search in an amazon s3 bucket?

What are options to create solution based on the AWS native platform to be able to full text search in an amazon s3 bucket/s. We have process that will be stori