BestHub
Sign in
Tagged articles

Full-text Search

133 articles · Page 1 of 2
Subtle Storm
Subtle Storm
Jun 30, 2026 · Databases

Elasticsearch vs Traditional Relational Databases: Core Differences and When to Use Each

The article contrasts Elasticsearch’s search‑oriented design—using inverted indexes, near‑real‑time BASE consistency, schema‑free JSON documents, and horizontal scaling—with relational databases’ precise row‑based storage, ACID guarantees, strict schemas, B+‑tree indexes, and vertical scaling, showing how they complement rather than compete.

ACIDElasticsearchFull-text Search
0 likes · 5 min read
Elasticsearch vs Traditional Relational Databases: Core Differences and When to Use Each
Top Architect
Top Architect
Jun 5, 2026 · Databases

Eliminate LIKE% in MySQL: Use Full‑Text Search for Efficient Fuzzy Queries

This article explains why using LIKE% for fuzzy searches in MySQL is inefficient, introduces InnoDB full‑text search (available since MySQL 5.6), describes inverted indexes, shows how to create and query full‑text indexes with natural language, boolean, and query‑expansion modes, discusses relevance calculation, stopwords, token‑size parameters, and provides the syntax for dropping full‑text indexes.

Boolean ModeFull-text SearchInnoDB
0 likes · 12 min read
Eliminate LIKE% in MySQL: Use Full‑Text Search for Efficient Fuzzy Queries
Su San Talks Tech
Su San Talks Tech
May 30, 2026 · Databases

Why PostgreSQL Beats MySQL for AI‑Driven Applications

The article explains why many developers stuck with MySQL should consider PostgreSQL, highlighting its superior SQL standards support, MVCC concurrency, rich indexing, JSONB performance, full‑text search, extensive extensions, and practical installation and Java integration steps, while also comparing pros, cons, and ideal use cases.

DatabaseFull-text SearchIndexing
0 likes · 24 min read
Why PostgreSQL Beats MySQL for AI‑Driven Applications
James' Growth Diary
James' Growth Diary
May 23, 2026 · Artificial Intelligence

Choosing the Right Retrieval Strategy: Full‑Text vs Vector vs Graph Search

This article breaks down the underlying logic, ideal scenarios, benchmark data, decision trees, and real‑world case studies for full‑text (BM25), vector, and graph retrieval, showing why hybrid approaches dominate production while each technique has distinct strengths and trade‑offs.

Full-text SearchHybrid SearchRAG
0 likes · 25 min read
Choosing the Right Retrieval Strategy: Full‑Text vs Vector vs Graph Search
Architect's Tech Stack
Architect's Tech Stack
Apr 29, 2026 · Databases

Redis 8.0 Beyond Simple Caching: 16 Powerful Use Cases You Must Try

Redis 8.0 consolidates many previously external modules—JSON, time‑series, vector search, probabilistic data structures, and more—into a single package, and this article walks through 16 concrete scenarios ranging from field‑level cache expiration to AI‑ready vector similarity search, showing exact commands and when to prefer each feature.

Full-text SearchLeaderboardRedis
0 likes · 19 min read
Redis 8.0 Beyond Simple Caching: 16 Powerful Use Cases You Must Try
dbaplus Community
dbaplus Community
Apr 26, 2026 · Databases

Why PostgreSQL Is the Better Choice in 99% of Scenarios

The article argues that relying on many specialized databases creates operational complexity, higher costs, and maintenance overhead, while PostgreSQL’s extensible ecosystem—offering full‑text search, vector, time‑series, JSONB, and more—delivers comparable or superior algorithms, proven performance, and a simpler, more reliable stack for the vast majority of use cases, especially in AI applications.

AIDatabaseExtensions
0 likes · 19 min read
Why PostgreSQL Is the Better Choice in 99% of Scenarios
360 Zhihui Cloud Developer
360 Zhihui Cloud Developer
Apr 22, 2026 · Databases

Unlock PostgreSQL’s Multi‑Model Power: Graph, Vector, Full‑Text, JSONB & GIS in Practice

PostgreSQL’s extensible architecture lets it evolve from a relational DB into a true multi‑model system supporting graphs, vectors, full‑text, time‑series, GIS and key‑value data, with detailed architecture explanations, practical code demos, cross‑model queries, extension selection, and production‑grade best‑practice tips.

Apache AGEFull-text SearchJSONB
0 likes · 39 min read
Unlock PostgreSQL’s Multi‑Model Power: Graph, Vector, Full‑Text, JSONB & GIS in Practice
Coder Trainee
Coder Trainee
Apr 18, 2026 · Backend Development

Building a Tech Blog from Scratch: Implementing a Comment System and Full‑Text Search

This article walks through the design and implementation of a nested comment system with likes, @‑mentions, and sensitive‑word filtering, plus full‑text search using Elasticsearch, covering database schema changes, backend services, Vue components, and recommendation logic for a technical blog platform.

ElasticsearchFull-text SearchSpring
0 likes · 23 min read
Building a Tech Blog from Scratch: Implementing a Comment System and Full‑Text Search
360 Zhihui Cloud Developer
360 Zhihui Cloud Developer
Apr 9, 2026 · Databases

Master PostgreSQL Full-Text Search: From Basics to Advanced Chinese Tokenization

This article explains PostgreSQL's native full‑text search, its core concepts of tsvector and tsquery, demonstrates how to use built‑in functions and operators, compares built‑in, zhparser, and pg_search extensions for Chinese tokenization, and provides best‑practice tips for indexing, triggers, and performance optimization.

BM25Chinese TokenizationFull-text Search
0 likes · 14 min read
Master PostgreSQL Full-Text Search: From Basics to Advanced Chinese Tokenization
Java Tech Workshop
Java Tech Workshop
Apr 5, 2026 · Backend Development

Spring Boot + Elasticsearch: Full‑Text Search Integration Guide

This article walks through integrating Spring Boot with Elasticsearch to enable fuzzy search, keyword highlighting, tokenized queries, and real‑time data sync, covering environment setup, Maven dependencies, application.yml configuration, entity annotations, CRUD via Repository, advanced queries with RestTemplate, IK analyzer usage, common pitfalls, and synchronization strategies.

ElasticsearchFull-text SearchRepository
0 likes · 10 min read
Spring Boot + Elasticsearch: Full‑Text Search Integration Guide
Alibaba Cloud Big Data AI Platform
Alibaba Cloud Big Data AI Platform
Feb 25, 2026 · Artificial Intelligence

How Hologres Powers Fast Vector & Full‑Text Search for AI‑Driven Customer Service

The Taobao‑Tmall customer operations team built an integrated vector‑plus‑full‑text retrieval solution on Hologres, achieving millisecond‑level recall for massive unstructured knowledge bases, boosting intelligent客服, rule comparison, and sentiment analysis across multiple business scenarios.

AI RetrievalFull-text SearchHologres
0 likes · 12 min read
How Hologres Powers Fast Vector & Full‑Text Search for AI‑Driven Customer Service
Java Architecture Diary
Java Architecture Diary
Feb 10, 2026 · Artificial Intelligence

Boost RAG Accuracy with LangChain4j 1.11.0 Hybrid Search on PgVector

This guide explains why pure vector retrieval often fails for version‑specific queries, introduces hybrid search that combines semantic and keyword matching, and provides step‑by‑step code and SQL examples for enabling PgVector hybrid search in LangChain4j 1.11.0.

Full-text SearchHybrid SearchLangChain4j
0 likes · 11 min read
Boost RAG Accuracy with LangChain4j 1.11.0 Hybrid Search on PgVector
macrozheng
macrozheng
Jan 15, 2026 · Databases

Master MySQL Full-Text Search: Inverted Index, Queries, and Best Practices

This guide explains why InnoDB fuzzy queries lose indexes, introduces MySQL full‑text search with inverted indexes, shows how to create and use full‑text indexes via CREATE TABLE and ALTER statements, and demonstrates natural language, boolean, and query‑expansion modes with practical SQL examples.

Boolean ModeDatabaseFull-text Search
0 likes · 12 min read
Master MySQL Full-Text Search: Inverted Index, Queries, and Best Practices
dbaplus Community
dbaplus Community
Jan 11, 2026 · Databases

Why Using Only Postgres Can Replace Redis, RabbitMQ, and Elasticsearch

The article argues that a single PostgreSQL instance can handle caching, queuing, full‑text search, and real‑time notifications, eliminating the need for separate services like Redis, RabbitMQ, and Elasticsearch, while reducing cost and complexity.

Database ConsolidationFull-text SearchMessage Queue
0 likes · 12 min read
Why Using Only Postgres Can Replace Redis, RabbitMQ, and Elasticsearch
ITPUB
ITPUB
Dec 29, 2025 · Databases

Boost PostgreSQL Full‑Text Search 3× Faster with VectorChord‑BM25

VectorChord‑BM25 is a PostgreSQL extension that adds native BM25 ranking and tokenization, delivering up to three‑fold query‑per‑second improvements over ElasticSearch while maintaining comparable relevance scores, and includes detailed installation, usage examples, and performance analysis.

BM25Database ExtensionFull-text Search
0 likes · 17 min read
Boost PostgreSQL Full‑Text Search 3× Faster with VectorChord‑BM25
DevOps Coach
DevOps Coach
Dec 15, 2025 · Databases

Why PostgreSQL Is Becoming the Backend OS: From Search to Event Streaming

The article explains how PostgreSQL has evolved from a simple relational store into a versatile platform that supports full‑text search, vector similarity, geospatial queries, JSONB, message queues, and analytical workloads, allowing developers to replace multiple specialized tools with a single unified system.

Database ExtensionsEvent StreamingFull-text Search
0 likes · 6 min read
Why PostgreSQL Is Becoming the Backend OS: From Search to Event Streaming
Java Tech Enthusiast
Java Tech Enthusiast
Dec 5, 2025 · Backend Development

Deploy and Master Meilisearch for Lightning‑Fast Full‑Text Search

This guide explains why Meilisearch is a lightweight alternative to Elasticsearch, walks through Docker‑based installation, demonstrates index creation, settings configuration, document CRUD operations, and various search queries, all with concrete curl commands and code examples.

DockerFull-text SearchIndexing
0 likes · 8 min read
Deploy and Master Meilisearch for Lightning‑Fast Full‑Text Search
Java Tech Enthusiast
Java Tech Enthusiast
Dec 1, 2025 · Databases

Master MySQL Full‑Text Search: Inverted Index, Query Modes, and Practical Examples

This guide explains how InnoDB implements full‑text search with inverted indexes, shows how to create and drop full‑text indexes, demonstrates MATCH() AGAINST() syntax across natural language, boolean, and query‑expansion modes, and covers relevance scoring, stopwords, token size limits, and real‑world query examples.

Full-text SearchInnoDBMySQL
0 likes · 14 min read
Master MySQL Full‑Text Search: Inverted Index, Query Modes, and Practical Examples
Su San Talks Tech
Su San Talks Tech
Nov 20, 2025 · Backend Development

Deploy and Use Meilisearch for Lightning‑Fast Full‑Text Search

This guide walks through installing Meilisearch via Docker, creating indexes, configuring settings, managing documents, and performing instant, sortable, and filtered searches using its RESTful API, while highlighting its speed, low hardware requirements, and multilingual support.

DockerFull-text SearchMeilisearch
0 likes · 8 min read
Deploy and Use Meilisearch for Lightning‑Fast Full‑Text Search
Senior Brother's Insights
Senior Brother's Insights
Oct 23, 2025 · Databases

InnoDB vs MyISAM: Which MySQL Storage Engine Fits Your Needs?

This article compares MySQL's InnoDB and MyISAM storage engines across dimensions such as transaction support, locking, file structure, indexing, full‑text search, and COUNT(*) performance, helping developers choose the appropriate engine based on workload and consistency requirements.

Full-text SearchInnoDBMyISAM
0 likes · 13 min read
InnoDB vs MyISAM: Which MySQL Storage Engine Fits Your Needs?
php Courses
php Courses
Oct 15, 2025 · Backend Development

Boost Music Site Search with PHP and Xunsearch: A Step‑by‑Step Guide

This tutorial explains how to install Xunsearch, integrate it with PHP, and index song data to dramatically improve search performance on a music website, providing step‑by‑step code examples and best practices for building an efficient full‑text search solution.

Full-text SearchMusic SitePHP
0 likes · 5 min read
Boost Music Site Search with PHP and Xunsearch: A Step‑by‑Step Guide
php Courses
php Courses
Sep 23, 2025 · Backend Development

Boost Music Site Search with PHP and Xunsearch: A Step‑by‑Step Guide

This tutorial explains how to install Xunsearch, integrate it with PHP, index music data, and execute fast, accurate full‑text searches for songs on a music website, providing code examples and best practices for improving user search experience.

Full-text SearchPHPSearch Optimization
0 likes · 5 min read
Boost Music Site Search with PHP and Xunsearch: A Step‑by‑Step Guide
Mike Chen's Internet Architecture
Mike Chen's Internet Architecture
Jul 10, 2025 · Big Data

Master ElasticSearch: Core Concepts, Architecture, and Search Process Explained

This article provides a comprehensive overview of ElasticSearch, covering its role as a distributed full‑text search engine built on Lucene, key concepts such as index, type, document, field, shard and replica, the analysis pipeline, inverted index mechanics, and the two‑phase query‑fetch search workflow.

AnalysisElasticsearchFull-text Search
0 likes · 7 min read
Master ElasticSearch: Core Concepts, Architecture, and Search Process Explained
Architect's Tech Stack
Architect's Tech Stack
Jul 8, 2025 · Databases

Master MySQL Full-Text Search: Indexes, Queries, and Advanced Techniques

This article explains MySQL's InnoDB full‑text search, covering the theory of inverted indexes, how to create and use full‑text indexes with various MATCH…AGAINST modes, Boolean operators, query expansion, relevance calculation, and index removal, illustrated with practical SQL examples and diagrams.

DatabaseFull-text SearchMySQL
0 likes · 12 min read
Master MySQL Full-Text Search: Indexes, Queries, and Advanced Techniques
DevOps Operations Practice
DevOps Operations Practice
Jun 30, 2025 · Big Data

Master Elasticsearch: Core Features, Basic Operations, and Advanced Search Techniques

Elasticsearch, built on Lucene, is a distributed search and analytics engine offering full-text search, log and metric analysis, real-time data processing, and recommendation capabilities; the guide explains its core functions, basic index and document management, and advanced query and aggregation features with practical API examples.

APIAggregationDistributed Architecture
0 likes · 5 min read
Master Elasticsearch: Core Features, Basic Operations, and Advanced Search Techniques
Java Captain
Java Captain
Apr 20, 2025 · Databases

RediSearch: Introduction, Features, Benchmarks, Installation, and CLI Operations

This article introduces RediSearch, a Redis module for full‑text search, outlines its many features, compares its indexing and query performance with Elasticsearch, provides installation methods (source and Docker), and demonstrates command‑line operations for creating indexes, adding documents, searching, and managing indexes.

CLIFull-text SearchInstallation
0 likes · 13 min read
RediSearch: Introduction, Features, Benchmarks, Installation, and CLI Operations
Open Source Tech Hub
Open Source Tech Hub
Mar 31, 2025 · Backend Development

How to Implement Powerful Full‑Text Search in PHP with TNTSearch

This guide explains how to install, configure, and use the PHP‑based TNTSearch engine, covering its key features, required dependencies, index creation, various search modes, dynamic updates, custom tokenizers, geo‑search, and text classification with practical code examples.

Full-text SearchTokenizergeo-search
0 likes · 9 min read
How to Implement Powerful Full‑Text Search in PHP with TNTSearch
Architecture Digest
Architecture Digest
Mar 24, 2025 · Backend Development

Comprehensive Guide to RediSearch: Features, Installation, and Query Operations

RediSearch is a Redis module that provides full‑text search, secondary indexing, and query capabilities; this guide introduces its features, compares performance with Elasticsearch, details installation via source and Docker, and demonstrates index creation, document management, and advanced search queries with code examples.

CLIDockerElasticsearch Comparison
0 likes · 14 min read
Comprehensive Guide to RediSearch: Features, Installation, and Query Operations
Selected Java Interview Questions
Selected Java Interview Questions
Mar 9, 2025 · Backend Development

Introduction to Manticore Search: Features, Performance, and Usage

Manticore Search is a high‑performance, open‑source C++ search engine that builds on Sphinx, offering real‑time indexing, SQL support, distributed search, and significant speed advantages over Elasticsearch, with simple installation via Linux packages or Docker and extensive plugin ecosystems for various applications.

DockerFull-text SearchManticore Search
0 likes · 6 min read
Introduction to Manticore Search: Features, Performance, and Usage
Selected Java Interview Questions
Selected Java Interview Questions
Nov 18, 2024 · Databases

RediSearch Overview: Features, Benchmarks, Installation, and Command‑Line Operations

This article introduces RediSearch—a Redis module for full‑text search—detailing its features, performance comparison with Elasticsearch, index‑building and query benchmarks, installation methods (source and Docker), and comprehensive command‑line examples for creating, querying, updating, and managing indexes.

CLIFull-text SearchIndexing
0 likes · 13 min read
RediSearch Overview: Features, Benchmarks, Installation, and Command‑Line Operations
Programmer1970
Programmer1970
Nov 5, 2024 · Backend Development

RedisSearch vs Elasticsearch: Which Full‑Text Search Engine Fits Your Needs?

The article compares RedisSearch and Elasticsearch across definition, storage model, performance, query capabilities, scalability, ease of integration, and operational considerations, helping readers decide which solution best matches requirements such as real‑time response, data volume, query complexity, and existing tech stacks.

ElasticsearchFull-text SearchRedisSearch
0 likes · 7 min read
RedisSearch vs Elasticsearch: Which Full‑Text Search Engine Fits Your Needs?
Java Architecture Stack
Java Architecture Stack
Oct 15, 2024 · Backend Development

How to Build Powerful Search, Log, and Recommendation Solutions with Elasticsearch

This guide walks through five real‑world Elasticsearch use cases—including full‑text product search with highlighting, centralized log collection and analysis, personalized video recommendation, price‑range aggregation for e‑commerce, and geo‑location restaurant search—detailing index design, query syntax, Docker setup, and front‑end integration.

ElasticsearchFull-text SearchPrice Aggregation
0 likes · 35 min read
How to Build Powerful Search, Log, and Recommendation Solutions with Elasticsearch
macrozheng
macrozheng
Oct 8, 2024 · Databases

Why RediSearch Beats Elasticsearch on Low‑End Servers: A Hands‑On Comparison

This article introduces RediSearch, compares its memory usage and query performance with Elasticsearch on modest hardware, shows installation steps, demonstrates core index commands and Java integration, and concludes with practical advice on using RediSearch as a lightweight full‑text search engine.

ElasticsearchFull-text SearchRediSearch
0 likes · 11 min read
Why RediSearch Beats Elasticsearch on Low‑End Servers: A Hands‑On Comparison
Code Farming
Code Farming
Sep 15, 2024 · Backend Development

Understanding Elasticsearch: Core Principles and Architecture

This article explains Elasticsearch’s overall structure, the underlying Lucene index layout, the indexing and search processing flow, and how built‑in analyzers work, illustrating each concept with diagrams, token examples, and query scenarios.

AnalyzersElasticsearchFull-text Search
0 likes · 10 min read
Understanding Elasticsearch: Core Principles and Architecture
php Courses
php Courses
Aug 27, 2024 · Backend Development

Integrating Xunsearch with PHP for Music Site Song Search

This tutorial explains how to install Xunsearch, integrate it with PHP, index song data, and perform full‑text searches to improve the search experience on a music website, providing code examples and best practices for efficient backend search implementation.

Full-text SearchMusic SiteXunSearch
0 likes · 5 min read
Integrating Xunsearch with PHP for Music Site Song Search
21CTO
21CTO
Aug 13, 2024 · Databases

How PostgreSQL Can Replace Kafka, Redis, MongoDB and More in Your Stack

This article explores how PostgreSQL’s advanced features—UNLOGGED tables, JSONB, SKIP LOCKED, TimescaleDB, pg_cron, PostGIS, full‑text search, JSON generation, pgaudit, and GraphQL adapters—can replace specialized tools like Kafka, Redis, MongoDB, and others, simplifying the tech stack while boosting performance and maintainability.

Data WarehouseFull-text SearchGraphQL
0 likes · 23 min read
How PostgreSQL Can Replace Kafka, Redis, MongoDB and More in Your Stack
Open Source Tech Hub
Open Source Tech Hub
Jul 27, 2024 · Backend Development

Master Elasticsearch with PHP: From Basics to Real‑World Search Implementation

This guide explains why e‑commerce platforms need a high‑performance search engine, introduces Elasticsearch fundamentals, compares it with traditional engines, and provides step‑by‑step PHP code for installing, configuring, indexing, and querying data, complete with practical examples and best‑practice tips.

ElasticsearchFull-text SearchPHP
0 likes · 9 min read
Master Elasticsearch with PHP: From Basics to Real‑World Search Implementation
System Architect Go
System Architect Go
Jul 16, 2024 · Backend Development

Using Redis Stack for Full‑Text Search with RediSearch and JSON

This tutorial explains how to leverage Redis Stack modules—especially RediSearch and RedisJSON—to store movie data, build a searchable JSON index, and perform advanced full‑text queries, highlighting, sorting, pagination, custom tokenization, scoring, and index aliasing, with Go code examples.

FT.CREATEFull-text SearchRediSearch
0 likes · 12 min read
Using Redis Stack for Full‑Text Search with RediSearch and JSON
JavaEdge
JavaEdge
Jul 13, 2024 · Databases

Mastering Neo4j: From Basics to Advanced Graph Queries and Performance Tuning

This article introduces Neo4j, explains its property‑graph model, demonstrates how to write and optimize Cypher queries, explores advanced features like full‑text search and built‑in graph algorithms, and showcases real‑world use cases and integration options for modern applications.

CypherFull-text SearchGraph Algorithms
0 likes · 10 min read
Mastering Neo4j: From Basics to Advanced Graph Queries and Performance Tuning
php Courses
php Courses
Jul 1, 2024 · Backend Development

Implement Real-Time Search and Automatic Index Updating with PHP and Xunsearch

This article demonstrates how to set up Xunsearch, a C++-based full-text search engine, and integrate it with PHP to achieve real-time search capabilities and automatically update the index, covering environment preparation, installation, sample code for searching, and index maintenance.

Full-text SearchIndexingPHP
0 likes · 4 min read
Implement Real-Time Search and Automatic Index Updating with PHP and Xunsearch
Architect
Architect
May 27, 2024 · Databases

RediSearch: Features, Benchmarks, Installation, and Usage Guide

RediSearch is a Redis module that adds full‑text search, secondary indexing and powerful query capabilities, offering detailed feature lists, performance benchmarks against Elasticsearch, step‑by‑step installation methods, and comprehensive command‑line examples for creating, querying, and managing indexes.

CLIFull-text SearchInstallation
0 likes · 12 min read
RediSearch: Features, Benchmarks, Installation, and Usage Guide
Programmer XiaoFu
Programmer XiaoFu
May 16, 2024 · Databases

MySQL Fuzzy Search Without LIKE%: Using Full‑Text Indexes

This article explains how InnoDB full‑text search can replace LIKE% fuzzy queries by using inverted indexes, covering index structures, creation syntax, MATCH() AGAINST() modes, practical demos, query expansion, and index removal, while noting when to prefer external search engines.

Boolean ModeFull-text SearchMySQL
0 likes · 12 min read
MySQL Fuzzy Search Without LIKE%: Using Full‑Text Indexes
Java Architect Essentials
Java Architect Essentials
May 14, 2024 · Databases

Comprehensive Guide to RediSearch: Features, Benchmarks, Installation, and Command Usage

RediSearch, a Redis module providing full-text search and secondary indexing, is introduced with its features, performance comparisons against Elasticsearch, benchmark results for index building and query throughput, detailed installation methods, and extensive command examples for creating, querying, updating, and managing indexes.

CLIFull-text SearchInstallation
0 likes · 13 min read
Comprehensive Guide to RediSearch: Features, Benchmarks, Installation, and Command Usage
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 28, 2024 · Databases

Database Indexing Algorithms: B‑Tree vs Hash Indexing

This article explains the purpose and inner workings of various database indexing algorithms—including B‑Tree, Hash, Bitmap, and Full‑Text indexes—illustrates their strengths and weaknesses with SQL examples, and provides guidance on when to choose each type for optimal query performance.

B+TreeBitmap IndexFull-text Search
0 likes · 12 min read
Database Indexing Algorithms: B‑Tree vs Hash Indexing
php Courses
php Courses
Apr 28, 2024 · Backend Development

Using Laravel Scout for Full-Text Search in Laravel Applications

This guide explains how to install, configure, and use Laravel Scout to add powerful full-text search capabilities to Laravel models, covering driver setup, searchable traits, indexing, custom queries, conditional searching, pagination, and result display.

EloquentFull-text SearchPHP
0 likes · 8 min read
Using Laravel Scout for Full-Text Search in Laravel Applications
Code Ape Tech Column
Code Ape Tech Column
Apr 12, 2024 · Databases

Understanding Full-Text Search and Inverted Indexes in MySQL InnoDB

This article explains MySQL InnoDB full-text search, covering inverted index structures, creation and usage of full-text indexes, query modes such as natural language, boolean, and query expansion, and provides practical SQL examples and considerations for effective text searching.

DatabaseFull-text SearchMySQL
0 likes · 11 min read
Understanding Full-Text Search and Inverted Indexes in MySQL InnoDB
Liangxu Linux
Liangxu Linux
Feb 28, 2024 · Databases

Master MySQL InnoDB Full-Text Search: Indexes, Queries, and Advanced Techniques

This article explains how MySQL InnoDB implements full‑text search, covering the underlying inverted index structures, how to create and drop full‑text indexes, the MATCH…AGAINST syntax, and detailed examples of natural language, boolean, and query‑expansion search modes with practical SQL demos.

Boolean ModeFull-text SearchMySQL
0 likes · 12 min read
Master MySQL InnoDB Full-Text Search: Indexes, Queries, and Advanced Techniques
Programmer DD
Programmer DD
Feb 19, 2024 · Backend Development

How to Build a Full‑Text Search API with Spring Boot and PostgreSQL

This guide explains how to implement a searchable user‑story interface using PostgreSQL tables with btree and gin indexes, Java record models, Spring Boot data access, and REST controllers to support range and full‑text queries efficiently.

Full-text SearchPostgreSQLSQL
0 likes · 9 min read
How to Build a Full‑Text Search API with Spring Boot and PostgreSQL
政采云技术
政采云技术
Jan 17, 2024 · Databases

Using MySQL 5.7 ngram Full-Text Search for Simple Text Retrieval

This article explains how to leverage MySQL 5.7's built‑in ngram full‑text parser to implement lightweight Chinese full‑text search, covering configuration, index creation, query modes, operator usage, and performance considerations.

Boolean ModeFull-text SearchMySQL
0 likes · 12 min read
Using MySQL 5.7 ngram Full-Text Search for Simple Text Retrieval
Open Source Tech Hub
Open Source Tech Hub
Dec 22, 2023 · Databases

Mastering RedisSearch: Build Fast Full-Text Search on Redis with PHP

This guide introduces RedisSearch, walks through installation, explains its rich feature set, details core concepts like data models and indexing, shows command‑line operations for creating indexes and querying, and provides a complete PHP example for integrating RedisSearch into applications.

DatabasesFull-text SearchPHP
0 likes · 9 min read
Mastering RedisSearch: Build Fast Full-Text Search on Redis with PHP
macrozheng
macrozheng
Dec 12, 2023 · Backend Development

RediSearch vs Elasticsearch: Cheap Setup, Performance Benchmarks, Java Guide

RediSearch, a low‑memory Redis module, offers comparable full‑text search capabilities to Elasticsearch, with faster indexing and query performance on modest hardware; this article explains its features, compares benchmarks, shows Docker installation, and provides Java/Jedis code examples for creating, querying, and managing indexes.

DockerElasticsearchFull-text Search
0 likes · 11 min read
RediSearch vs Elasticsearch: Cheap Setup, Performance Benchmarks, Java Guide
Top Architecture Tech Stack
Top Architecture Tech Stack
Nov 9, 2023 · Big Data

Full-Text Search Overview and Elasticsearch Introduction with Installation Guide

This article explains the concept of full-text retrieval, introduces Elasticsearch as a popular open‑source search engine built on Apache Lucene, and provides detailed step‑by‑step installation instructions for both traditional setups and Docker containers, including required environment configuration and common troubleshooting.

ElasticsearchFull-text Searchsearch engine
0 likes · 6 min read
Full-Text Search Overview and Elasticsearch Introduction with Installation Guide
JD Cloud Developers
JD Cloud Developers
Sep 27, 2023 · Databases

How to Design Effective MySQL Indexes for Service Log Queries

This article explains how to create optimal MySQL indexes for a service_log table based on various search conditions, covering single‑column, composite, full‑text, prefix, and covering indexes, along with best practices, index size considerations, and practical SQL examples.

Full-text SearchMySQLSQL
0 likes · 19 min read
How to Design Effective MySQL Indexes for Service Log Queries
php Courses
php Courses
Sep 18, 2023 · Databases

How to Implement High‑Performance Database Search with PHP

This article explains how to achieve high‑performance database search in PHP by optimizing schema, writing efficient SQL, using mysqli/PDO functions, employing caching tools like Memcached or Redis, and integrating full‑text engines such as Elasticsearch, with complete code examples.

Full-text SearchPHPSQL
0 likes · 6 min read
How to Implement High‑Performance Database Search with PHP
Architects Research Society
Architects Research Society
Jul 2, 2023 · Databases

PostgreSQL Full-Text Search vs Elasticsearch: Performance Comparison and Findings

This article compares PostgreSQL and Elasticsearch for full‑text search in Django applications, presenting performance benchmarks on up to 1.5 million records, discussing setup complexity, features like stemming and fuzziness, and concluding that PostgreSQL is preferable for most projects without massive data scales.

DjangoElasticsearchFull-text Search
0 likes · 7 min read
PostgreSQL Full-Text Search vs Elasticsearch: Performance Comparison and Findings
Selected Java Interview Questions
Selected Java Interview Questions
Aug 24, 2022 · Backend Development

Understanding ElasticSearch: Distributed Search, Full‑Text Retrieval, and Inverted Index

This article explains what search is, why traditional databases struggle with full‑text queries, introduces the concepts of inverted indexes and Lucene, and shows how ElasticSearch combines distributed architecture, real‑time analytics, and powerful search features to solve these problems.

Full-text Searchdistributed systemsinverted index
0 likes · 8 min read
Understanding ElasticSearch: Distributed Search, Full‑Text Retrieval, and Inverted Index
21CTO
21CTO
Jul 20, 2022 · Backend Development

Boost Your Python Projects with Whoosh: A Lightweight Search Engine Tutorial

This article introduces the lightweight pure‑Python search library Whoosh, outlines its key features, demonstrates how to define a schema, build an index from a CSV of Chinese poems, and perform full‑text queries with example code, making it ideal for small search projects.

Full-text SearchIndexingexample
0 likes · 7 min read
Boost Your Python Projects with Whoosh: A Lightweight Search Engine Tutorial
Programmer DD
Programmer DD
Apr 27, 2022 · Backend Development

How to Implement Full-Text Search for Word, PDF, and TXT Files with Elasticsearch

This guide explains how to upload Word, PDF, and TXT files, preprocess them with Elasticsearch ingest pipelines, index their content using appropriate analyzers, and perform accurate keyword searches with highlighting, providing complete Java code examples and configuration steps.

ElasticsearchFull-text SearchIngest Pipeline
0 likes · 13 min read
How to Implement Full-Text Search for Word, PDF, and TXT Files with Elasticsearch
macrozheng
macrozheng
Mar 7, 2022 · Databases

Mastering RedisOM: Elegant ORM for Spring Boot with Full-Text Search

RedisOM, the official Redis ORM for Java, lets Spring Boot developers replace RedisTemplate with object‑oriented data handling and built‑in full‑text search, covering JDK 11 setup, Maven dependencies, configuration, entity annotations, repository interfaces, and REST controller examples for managing product data.

DatabaseFull-text SearchORM
0 likes · 11 min read
Mastering RedisOM: Elegant ORM for Spring Boot with Full-Text Search
Architect's Tech Stack
Architect's Tech Stack
Mar 3, 2022 · Databases

Understanding MySQL InnoDB Full-Text Search and Inverted Index

This article explains why traditional B‑Tree indexes fail for keyword searches, introduces the concept of inverted indexes, shows how to create and use MySQL InnoDB full‑text indexes with MATCH‑AGAINST in various modes, and covers index maintenance and query‑expansion techniques.

Boolean ModeDatabaseFull-text Search
0 likes · 12 min read
Understanding MySQL InnoDB Full-Text Search and Inverted Index
Top Architect
Top Architect
Feb 6, 2022 · Databases

Understanding MySQL InnoDB Full‑Text Search and Inverted Index

This article explains why InnoDB full‑text search is needed for keyword‑based queries, introduces inverted index structures, shows how to create, use, and delete full‑text indexes in MySQL, and demonstrates natural language, boolean, and query‑expansion search modes with practical SQL examples.

DatabaseFull-text SearchMySQL
0 likes · 15 min read
Understanding MySQL InnoDB Full‑Text Search and Inverted Index
Java Backend Technology
Java Backend Technology
Jan 18, 2022 · Databases

Master MySQL Full-Text Search: Inverted Indexes, Query Modes, and Optimization

This article explains how InnoDB implements full-text search using inverted indexes, shows how to create and use full-text indexes with various query modes—including natural language, boolean, and query expansion—covers relevance calculation, stopwords, token size limits, and demonstrates how to delete indexes, all illustrated with SQL examples and diagrams.

Boolean ModeFull-text SearchMySQL
0 likes · 13 min read
Master MySQL Full-Text Search: Inverted Indexes, Query Modes, and Optimization
JD Cloud Developers
JD Cloud Developers
Dec 24, 2021 · Databases

Boost Address Keyword Search with PostgreSQL: GIN, pg_trgm, and pg_bigm

This article explains how PostgreSQL's native full‑text search, GIN indexes, and extensions like pg_trgm, pg_bigm, and pg_jieba can dramatically improve the speed and accuracy of Chinese address keyword searches, offering a cost‑effective alternative to external search engines.

Full-text SearchGIN IndexPostgreSQL
0 likes · 6 min read
Boost Address Keyword Search with PostgreSQL: GIN, pg_trgm, and pg_bigm
Laravel Tech Community
Laravel Tech Community
Dec 9, 2021 · Backend Development

Apache Lucene 9.0 Released – New Features and Improvements

Apache Lucene 9.0, a high‑performance Java full‑text search library, introduces high‑dimensional vector indexing, new language analyzers, faster faceting and sorting, updated file formats, and several performance optimizations, providing developers with a richer, more efficient search toolkit.

Apache LuceneFull-text Searchjava
0 likes · 3 min read
Apache Lucene 9.0 Released – New Features and Improvements
Programmer DD
Programmer DD
Dec 3, 2021 · Backend Development

Build a File Upload & Search System with Elasticsearch and IK Analyzer

This guide walks through creating a file upload service that indexes Word, PDF, and TXT files in Elasticsearch, uses an ingest‑attachment pipeline to extract text, configures Chinese IK analyzers for precise keyword search, and demonstrates Java code for indexing, querying, and highlighting results.

ElasticsearchFull-text SearchIngest Pipeline
0 likes · 12 min read
Build a File Upload & Search System with Elasticsearch and IK Analyzer
21CTO
21CTO
Nov 3, 2021 · Databases

Master MySQL Full‑Text Search: Index Creation, Modes, and Internals

This tutorial explains how MySQL implements full‑text search, covering the creation of full‑text indexes (including Chinese ngram support), the three query modes (natural language, boolean, and query expansion), relevance ranking, underlying inverted‑index structures, cache handling, and common DML operations.

Boolean ModeDatabaseFull-text Search
0 likes · 14 min read
Master MySQL Full‑Text Search: Index Creation, Modes, and Internals
Top Architect
Top Architect
Sep 9, 2021 · Big Data

Building a Site Search Engine with Elasticsearch, Spring Boot, and IK Analyzer

This article demonstrates how to construct a full‑text site search solution by selecting Elasticsearch as the search engine, Spring Boot for the backend service, and the IK analyzer for Chinese tokenization, covering environment setup, project architecture, key code implementations, UI pages, and a concise conclusion on the effectiveness of the approach.

ElasticsearchFull-text SearchSpring Boot
0 likes · 18 min read
Building a Site Search Engine with Elasticsearch, Spring Boot, and IK Analyzer
vivo Internet Technology
vivo Internet Technology
Jul 14, 2021 · Databases

An Overview of Lucene: Architecture, Indexing Workflow, and Code Implementation

The article introduces Apache Lucene 7.3.1, explains its core architecture and index hierarchy, details the two‑phase indexing and search workflow with code examples for document addition, deletion, merging, and query execution, and highlights its suitability for small‑to‑medium projects versus distributed alternatives.

Code ExampleFull-text SearchIndexing
0 likes · 20 min read
An Overview of Lucene: Architecture, Indexing Workflow, and Code Implementation