8,615 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
1
answer
46
views
Efficient Search Across Elasticsearch and Neo4j Without Pulling Large Result Sets
here i got :
Elasticsearch stores most of the searchable / document-like data (text fields, city, etc.)
Neo4j stores relationships and some entity attributes (e.g., gender, graph connections)
Each ...
-1
votes
0
answers
40
views
Meilisearch fails to find alphanumeric SKU unless combined with another term in quotes
I'm trying to configure Meilisearch for a very strict, 100% exact match search for product SKUs and brand names from a collection of text files. My goal is to completely disable all of Meilisearch's &...
2
votes
1
answer
95
views
How to combine diacritics-insensitive, case-insensitive and partial search in MongoDB?
I'm trying to implement a robust search function in my NestJS/Mongoose application that can handle partial matches while being case-insensitive and diacritics-insensitive (ignoring accents).
My ...
2
votes
1
answer
97
views
Way to simply list the Forms of a word by the full-text parser?
We're using fulltext indexes in current builds of SQL Server and/or Azure SQL - compatibility levels well over SQL Server 2016 or higher, preferably SQL Server 2022 on Azure.
While the searching in a ...
0
votes
1
answer
115
views
MongoDB Atlas Search Index Too Slow
I need to search crypto tokens by name (text search), symbol (exact match) or address (prefix match, i.e. return all tokens the address of which starts with the user query). Instead of relying on a ...
0
votes
0
answers
55
views
Google Places SDK: How to prevent iOS text search from sorting results by distance?
I'm using the Google Places SDK for iOS and Android, along with the new Places API (New), to implement text-based place search (e.g., "pizza" near the current location).
I'm passing the same ...
0
votes
0
answers
57
views
Why does LanceDB's full-text-search fail to find matches where the exact text is present?
I am trying to use lancedb to perform FTS, but getting spurious results.
Here is a minimal example:
# Data generation
import lancedb
import polars as pl
from string import ascii_lowercase
words = [...
3
votes
0
answers
86
views
The word "again" is not getting indexed when using MySQL InnoDB FullText index with ngram parser with token size 2
We noticed that full-text index searches were not returning results for the "again" search param.
We excluded the possibility that the word "again" is part of the MySQL FullText ...
0
votes
0
answers
42
views
Oracle 19c Text Option: Behaviour of CONTAINS with NEAR and MAX_SPAN
We found a strange behaviour of Oracle full text search when using contains(text, 'NEAR((A,B,C,D), 2, true)') where 2 is the max_span parameter. The documentation says:
max_span Optionally specify ...
0
votes
0
answers
90
views
MySQL Full-Text Search with ngram parser not prioritizing exact word matches
I have enabled a full-text index on my MySQL table with the ngram parser as shown below:
SHOW VARIABLES LIKE 'ngram_token_size'; -- Default set to 2
ALTER TABLE MyTable ADD FULLTEXT INDEX FT_MyTable (...
0
votes
0
answers
117
views
Why doesn't VS Code pop up context menu on top level folder / project folder provide Search option?
When I right-click on the top most / top level / project folder / root folder to get the context pop-up menu, I don't get a Search option in that menu:
In my case, in the picture, the top most folder ...
2
votes
1
answer
66
views
Why am I getting a return of false instead of true on the ts_query for this string
I'm learning about full-text search in postgres using ts_vector & ts_query, by analyzing texts in strings.
But I'm getting a false return but instead I should be getting a true output. Here is my ...
0
votes
0
answers
174
views
Correct design for SQL table in SQLite3: how to optimize substring search?
I am using SQLite3 in C++ where I need to store text data. There are 7 columns in the table. I need to filter data by 7 columns. I need to check for equality of 6 columns to a specific value, and I ...
0
votes
1
answer
68
views
MySQL fulltext index search with multiple columns
MySQL fulltext index search with multiple columns
MySQL Table - sample_table:
col1
col2
col3
col4
Fulltext index:
Keyname: some_keyname
Columns: col1, col2, col3, col4
Question:
To search for a string ...
0
votes
0
answers
40
views
Chinese chapter lookup shows too many nodes because of variant characters – how can I keep it fully local and still match precisely?
I'm building an offline-only CLI tool that searches our company rulebook, stored as hierarchical JSON:
Levels like 3, 3.2, 3.2.1 ...
router(query) chooses the node by comparing the query with each ...