BestHub
Sign in
Tagged articles
124 articles
Page 1 of 2
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 SearchRedis 8.0caching
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.

AIExtensionsFull‑Text Search
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.

Comment SystemElasticsearchFull‑Text Search
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
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 ModeFull‑Text Searchdatabase
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.

Cost OptimizationDatabase ConsolidationFull‑Text Search
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 SearchMeilisearch
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 SearchInnoDBinverted index
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.

BackendDockerFull‑Text Search
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.

BackendFull‑Text SearchPHP
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.

Full‑Text Searchdatabaseinverted index
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.

APIElasticsearchFull‑Text Search
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
php Courses
php Courses
Apr 7, 2025 · Backend Development

Integrating Xunsearch Full-Text Search Engine with PHP for a Music Website

This tutorial explains how to install Xunsearch, integrate it with PHP, create search objects, execute queries, and index music data to improve song search performance on a music website, providing complete code examples and step‑by‑step instructions.

Full‑Text SearchMusic SitePHP
0 likes · 5 min read
Integrating Xunsearch Full-Text Search Engine with PHP for a Music Website
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 SearchRediSearch
0 likes · 13 min read
RediSearch Overview: Features, Benchmarks, Installation, and Command‑Line Operations
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 SearchJedis
0 likes · 11 min read
Why RediSearch Beats Elasticsearch on Low‑End Servers: A Hands‑On Comparison
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.

Full‑Text SearchGraphQLbackend-development
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 Database
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 SearchPHPXunSearch
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
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 SearchLaravel
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.

Full‑Text SearchSearchdatabase
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 Searchinverted index
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 SearchSpring Bootjava
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 SearchNGram
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.

Full‑Text SearchPHPRedisSearch
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 SearchPHPcaching
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
Tencent Cloud Developer
Tencent Cloud Developer
Feb 20, 2023 · Mobile Development

iOS WeChat Full-Text Search Technology Upgrade: Selection and Optimization

iOS WeChat’s full‑text search was upgraded by selecting SQLite FTS5, creating a VerbatimTokenizer with multi‑level delimiter support, optimizing table formats to cut index size by 30 %, improving batch index updates and parallel search logic, resulting in 40‑60 % faster query latency.

Database OptimizationFull‑Text SearchIndex Optimization
0 likes · 26 min read
iOS WeChat Full-Text Search Technology Upgrade: Selection and Optimization
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.

Distributed SystemsFull‑Text Searchinverted 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 Searchexampleindexing
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 SearchIK Analyzer
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.

Full‑Text SearchORMRedisOM
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 ModeFull‑Text Searchdatabase
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.

Full‑Text Searchdatabaseinverted index
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 Searchinverted index
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 Indexaddress keyword search
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 SearchIK Analyzer
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 ModeFull‑Text Searchdatabase
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 SearchIK Analyzer
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
Efficient Ops
Efficient Ops
Jun 23, 2021 · Backend Development

Why Can’t Elasticsearch Find My Logs? Uncovering Full‑Text Search Pitfalls and Tokenizer Tweaks

This article explains why large‑scale Elasticsearch clusters may miss log entries during keyword searches, dives into the fundamentals of inverted indexes and tokenization, and demonstrates practical index‑time and query‑time tokenizer optimizations—including custom analyzers for English and Chinese—to dramatically improve search recall and precision.

ElasticsearchFull‑Text SearchTokenizer
0 likes · 13 min read
Why Can’t Elasticsearch Find My Logs? Uncovering Full‑Text Search Pitfalls and Tokenizer Tweaks
Wukong Talks Architecture
Wukong Talks Architecture
Apr 8, 2021 · Backend Development

Integrating Elasticsearch with Spring Boot for Full‑Text Search in a Microservice Architecture

This tutorial demonstrates how to integrate Elasticsearch into a Spring Boot microservice, covering component selection, Maven configuration, client setup, index creation, data insertion, complex query execution, synchronization of question data, and front‑end search handling, all illustrated with complete Java code examples.

ElasticsearchFull‑Text SearchMicroservices
0 likes · 21 min read
Integrating Elasticsearch with Spring Boot for Full‑Text Search in a Microservice Architecture
Laravel Tech Community
Laravel Tech Community
Feb 25, 2021 · Backend Development

Apache Lucene 8.8.1 Released – New Features and Fixes

Apache Lucene 8.8.1, a high‑performance Java full‑text search engine library, has been released, fixing bugs from 8.8.0 and including optimizations, while the previous 8.8.0 version introduced features such as LatLonPoint spatial queries, configurable Doc value compression, and FeatureField’s newLinearQuery scoring.

Apache LuceneBackendFull‑Text Search
0 likes · 2 min read
Apache Lucene 8.8.1 Released – New Features and Fixes
Tencent Cloud Developer
Tencent Cloud Developer
Oct 30, 2020 · Backend Development

Rebuilding QQ Mail Full-Text Search with Elasticsearch: Architecture, Implementation, and Optimization

To overcome aging hardware and code limitations, QQ Mail rebuilt its full‑text search using Tencent Cloud Elasticsearch, adding an esproxy layer, MQ‑driven updates, HTML‑to‑text extraction, protobuf‑JSON conversion, index sorting, two‑stage precise/fuzzy queries, and custom tokenizers, delivering scalable, low‑latency email search.

Backend ArchitectureCloud ServicesElasticsearch
0 likes · 17 min read
Rebuilding QQ Mail Full-Text Search with Elasticsearch: Architecture, Implementation, and Optimization
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Oct 18, 2020 · Backend Development

Spring Boot 2.0.5 Integration with Elasticsearch: Installation, Configuration, Entity Mapping, CRUD, and Full‑Text Search

This guide demonstrates how to integrate Spring Boot 2.0.5 with Elasticsearch 5.6.11 by installing Elasticsearch and Kibana, adding the required Maven dependencies, configuring the client via application.yml or Java code, defining @Document‑annotated entities, implementing repository, service and controller layers for CRUD and full‑text search, handling Netty conflicts at startup, and verifying the setup with health, list and search endpoints.

ElasticsearchFull‑Text SearchKotlin
0 likes · 8 min read
Spring Boot 2.0.5 Integration with Elasticsearch: Installation, Configuration, Entity Mapping, CRUD, and Full‑Text Search
Programmer DD
Programmer DD
Apr 12, 2020 · Big Data

Master Elasticsearch: From Basics to SpringBoot Integration and Advanced Queries

This comprehensive guide introduces Elasticsearch fundamentals, its features and use cases, then walks through integrating it with SpringBoot, configuring Maven dependencies, performing index and document operations, and demonstrates a variety of query types and aggregations using both RESTful APIs and Java code examples.

Big DataElasticsearchFull‑Text Search
0 likes · 46 min read
Master Elasticsearch: From Basics to SpringBoot Integration and Advanced Queries