Skip to content
Tagged articles

full-text search

148 articles · Page 1 of 2
Alibaba Cloud Big Data AI Platform
Alibaba Cloud Big Data AI Platform
Nov 6, 2026 · Big Data

EMR Serverless StarRocks + DLF Paimon: Multimodal Data Lake Retrieval for Autonomous Driving

This article details Alibaba Cloud's architecture for multimodal data lake retrieval using EMR Serverless StarRocks and DLF Paimon, covering design principles like early filtering and on-demand reading, Global Index mechanics, format selection between Paimon and Lance, real-world deployments in Alibaba's A Lake and AI Data platforms, and a complete autonomous driving loop from bad case detection to model validation.

Autonomous DrivingDLF PaimonData Lake Architecture
0 likes · 28 min read
EMR Serverless StarRocks + DLF Paimon: Multimodal Data Lake Retrieval for Autonomous Driving
Alibaba Cloud Big Data AI Platform
Alibaba Cloud Big Data AI Platform
Nov 4, 2026 · Big Data

EMR Serverless StarRocks Supports Paimon 2.0 for Multimodal Analytics & Retrieval

Alibaba Cloud's EMR Serverless StarRocks now fully supports Apache Paimon 2.0, enabling unified multimodal analytics and retrieval by integrating vector search, full-text search, scalar filtering, and BLOB handling within a single lakehouse architecture, with best practices for data management and query optimization.

Data EvolutionEMR ServerlessGlobal Index
0 likes · 29 min read
EMR Serverless StarRocks Supports Paimon 2.0 for Multimodal Analytics & Retrieval
macrozheng
macrozheng
Oct 28, 2026 · Backend Development

Why Developers Choose Meilisearch: Lightweight Instant Search Engine Guide

This article introduces Meilisearch as a lightweight, fast alternative to Elasticsearch, detailing its features, Docker installation, and RESTful API usage for index management, settings configuration, document CRUD operations, and advanced search with pagination, sorting, and filtering.

DockerElasticsearchMeilisearch
0 likes · 10 min read
Why Developers Choose Meilisearch: Lightweight Instant Search Engine Guide
Java Tech Enthusiast
Java Tech Enthusiast
Oct 27, 2026 · Databases

Why WeChat Chooses SQLite for 1.3 Billion Users' Chat Records

WeChat stores 1.3 billion users' chat records locally on devices using SQLite via its WCDB framework, avoiding EB-scale server costs while enabling instant search via FTS5 full-text indexing, with SQLCipher encryption and automatic sharding at 240MB per database file.

ACIDFTS5SQLCipher
0 likes · 16 min read
Why WeChat Chooses SQLite for 1.3 Billion Users' Chat Records
IT Services Circle
IT Services Circle
Oct 18, 2026 · Databases

Why WeChat Uses SQLite for 1.3 Billion Users' Chat Records

This article explains why WeChat stores chat records locally using SQLite instead of cloud databases, detailing the cost savings, privacy benefits, and performance advantages of embedded databases, along with WeChat's custom WCDB framework, FTS5 full-text search, encryption, and the trade-offs of local-only storage.

ACIDFTS5SQLCipher
0 likes · 16 min read
Why WeChat Uses SQLite for 1.3 Billion Users' Chat Records
Architect's Guide
Architect's Guide
Oct 10, 2026 · Databases

MySQL Full-Text Search: Beyond LIKE % for Fuzzy Queries

This article explains MySQL full-text search using inverted indexes as an alternative to LIKE % queries, covering index creation, natural language, boolean, and query expansion modes with syntax examples and performance considerations.

InnoDBInverted IndexMySQL
0 likes · 14 min read
MySQL Full-Text Search: Beyond LIKE % for Fuzzy Queries
Mingyi World Elasticsearch
Mingyi World Elasticsearch
Sep 28, 2026 · Databases

Dameng DM8 + Easysearch Full-Text Search Validation: 12x Speedup on 1M Chinese Docs

This report validates a read-write separation architecture using Dameng DM8 for transactions and Easysearch for full-text search, syncing 1 million Chinese documents via Logstash; full sync completes in 5.5 minutes, incremental changes propagate within 30 seconds, and search latency drops 12x compared to SQL LIKE while maintaining identical recall.

CDCChinese tokenizationDameng DM8
0 likes · 20 min read
Dameng DM8 + Easysearch Full-Text Search Validation: 12x Speedup on 1M Chinese Docs
Mingyi World Elasticsearch
Mingyi World Elasticsearch
Sep 28, 2026 · Databases

Dameng DM8 + Easysearch: 17x Faster Full-Text Search via Logstash Sync

This article details integrating Dameng DM8 database with Easysearch 2.4.0 via Logstash 9.0 for full-text search, covering version compatibility fixes, JDBC driver configuration, logical deletion handling, timestamp boundary issues, IK analyzer alignment for Chinese text, and benchmark results showing 17x faster queries with consistent recall versus LIKE.

Chinese tokenizationDM8Dameng
0 likes · 16 min read
Dameng DM8 + Easysearch: 17x Faster Full-Text Search via Logstash Sync
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.

ACIDElasticsearchHorizontal Scaling
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 ModeInnoDBInverted Index
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.

JSONBJavaMVCC
0 likes · 24 min read
Why PostgreSQL Beats MySQL for AI‑Driven Applications
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.

LeaderboardRedisRedis 8.0
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.

AIPostgreSQLVector 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 AGEJSONBPostGIS
0 likes · 39 min read
Unlock PostgreSQL’s Multi‑Model Power: Graph, Vector, Full‑Text, JSONB & GIS in Practice
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 tokenizationDatabase Indexing
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.

ElasticsearchIK AnalyzerRepository
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 retrievalHologresRAG
0 likes · 12 min read
How Hologres Powers Fast Vector & Full‑Text Search for AI‑Driven Customer Service
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 ModeInverted IndexMySQL
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 ConsolidationMessage 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.

BM25PostgreSQLRanking
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 ExtensionsJSONBPostgreSQL
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.

DockerMeilisearchREST API
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.

InnoDBInverted IndexMySQL
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.

BackendDockerMeilisearch
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.

InnoDBMyISAMMySQL
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.

Backend DevelopmentMusic 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.

BackendPHPSearch Optimization
0 likes · 5 min read
Boost Music Site Search with PHP and Xunsearch: A Step‑by‑Step Guide
Lakehouse Research Base
Lakehouse Research Base
Sep 16, 2025 · Databases

StarRocks 3.3 Indexes: When to Use Bitmap, Bloom Filter, N-Gram & Full-Text Search

This guide details the four index types in StarRocks 3.3—Bitmap, Bloom Filter, N-Gram Bloom Filter, and Full-Text Inverted Index—covering their core principles, supported data types, creation syntax, ideal use cases (low/high cardinality, fuzzy/long-text queries), anti-patterns, and real-world optimization examples with performance metrics.

Bitmap IndexBloom filterDatabase Indexing
0 likes · 27 min read
StarRocks 3.3 Indexes: When to Use Bitmap, Bloom Filter, N-Gram & Full-Text Search
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.

AnalysisElasticsearchInverted Index
0 likes · 7 min read
Master ElasticSearch: Core Concepts, Architecture, and Search Process Explained
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.

APIElasticsearchaggregation
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.

RediSearchRedisbenchmark
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 searchgeo-searchsearch engine
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.

DockerElasticsearch ComparisonRediSearch
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.

Backend DevelopmentDockerManticore 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.

RediSearchRediscli
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.

ElasticsearchRedisSearchfull-text search
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.

Backend DevelopmentElasticsearchPrice 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.

ElasticsearchJavaJedis
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.

AnalyzersElasticsearchLucene
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.

Music SiteXunSearchfull-text search
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.

Backend DevelopmentGraphQLPostgreSQL
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.

Backend DevelopmentElasticsearchPHP
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.CREATERediSearchRedis
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.

CypherGraph AlgorithmsGraph Queries
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.

Backend DevelopmentPHPXunSearch
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.

RediSearchbenchmarkcli
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 ModeInverted IndexMySQL
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.

RediSearchRedisbenchmark
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 IndexDatabase Indexing
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.

EloquentLaravelPHP
0 likes · 8 min read
Using Laravel Scout for Full-Text Search in Laravel Applications
NetEase Cloud Music Tech Team
NetEase Cloud Music Tech Team
Apr 15, 2024 · Mobile Development

Implementation and Optimization of Local Private Domain Search in Cloud Music

The Cloud Music team integrated a lightweight on‑device full‑text engine using SQLite FTS5 with a simple tokenizer, replaced JavaScript matching with SQLite’s bm25(), parallelized queries, and cut search latency by 75%, boosting CTR 13% and average playback by 17 seconds while preserving user privacy.

FTS5Performance OptimizationSQLite
0 likes · 15 min read
Implementation and Optimization of Local Private Domain Search in Cloud Music
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.

Inverted IndexMySQLSQL
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 ModeInverted IndexMySQL
0 likes · 12 min read
Master MySQL InnoDB Full-Text Search: Indexes, Queries, and Advanced Techniques
政采云技术
政采云技术
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 ModeDatabase IndexingMySQL
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.

PHPRedisRedisSearch
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.

DockerElasticsearchJava
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.

MySQLSQLfull-text search
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.

PHPSQLcaching
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.

DjangoElasticsearchPostgreSQL
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.

Distributed SystemsInverted Indexfull-text search
0 likes · 8 min read
Understanding ElasticSearch: Distributed Search, Full‑Text Retrieval, and Inverted Index