Sphinx Search Beginner's Guide. Implement full-text search with lightning speed and accuracy using Sphinx - Ebook - Abbas Ali - Modern learning platform

E-book details

Log in, If you're interested in the contents of the item.

Sphinx Search Beginner's Guide. Implement full-text search with lightning speed and accuracy using Sphinx

Abbas Ali

Ebook

Sphinx Search
- Table of Contents
- Sphinx Search
- Credits
- About the Author
- Acknowledgement
- About the Reviewers
- www.PacktPub.com
  - Support files, eBooks, discount offers, and more
    - Why Subscribe?
    - Free Access for Packt account holders
- Preface
  - What this book covers
  - Who this book is for
  - Conventions
  - Time for action - heading
    - What just happened?
    - Pop quiz - heading
    - Have a go hero - heading
  - Reader feedback
  - Customer support
    - Errata
    - Piracy
    - Questions
- 1. Setting Up Sphinx
  - What you need to know
  - Different ways of performing a search
    - Searching on a live database
    - Searching an index
  - Sphinxa full-text search engine
    - Features
    - A brief history
    - License
  - Installation
    - System requirements
    - Sphinx on a Unix-based system
  - Time for action - installation on Linux
    - What just happened?
    - Options to the configure command
    - Known issues during installation
    - Sphinx on Windows
  - Time for action - installation on Windows
    - What just happened?
    - Sphinx on Mac OS X
  - Time for action - installation on a Mac
    - What just happened?
    - Other supported systems
  - Summary
- 2. Getting Started
  - Checking the installation
  - Full-text search
    - What is full-text search?
    - Traditional search
  - Time for action - normal search in MySQL
    - What just happened?
    - MySQL full-text search
    - Advantages of full-text search
    - When to use a full-text search?
  - Overview of Sphinx
    - Primary programs
  - Time for action - Sphinx in action
    - What just happened?
    - Data to be indexed
    - Creating the Sphinx configuration file
    - Searching the index
    - Have a go hero -
  - Why use Sphinx for full-text searching?
  - Summary
- 3. Indexing
  - What are indexes?
    - Indexes in Sphinx
  - Index attributes
    - Types of attributes
      - Multi-value attributes (MVA)
  - Data sources
    - How to define the data source?
    - SQL data sources
      - Creating Index using SQL data source (Blog)
        
        Creating a simple index without any attributes
  - Time for action - creating database tables for a blog
    - What just happened?
  - Time for action - populate the database tables
    - What just happened?
  - Time for action - creating the Sphinx configuration file
    - What just happened?
      - The indexing workflow
      - Adding attributes to the index
  - Time for action - adding attributes to the index
    - What just happened?
      - Adding an MVA to the index
  - Time for action - Adding an MVA to the index
    - What just happened?
      - Filtering without searching for a specific phrase
    - xmlpipe data source
    - xmlpipe2 data source
      - Indexing with schema defined in XML stream
  - Time for action - creating index (without attributes)
    - What just happened?
  - Time for action - add attributes to schema
    - What just happened?
      - Indexing with schema defined in configuration file
  - Time for action - create index with schema defined in configuration file
    - What just happened?
  - Summary
- 4. Searching
  - Client API implementations for Sphinx
  - Search using client API
  - Time for action - creating a basic search script
    - What just happened?
    - Matching modes
  - Time for action - searching with different matching modes
    - What just happened?
    - Boolean query syntax
  - Time for action - searching using Boolean query syntax
    - What just happened?
    - Extended query syntax
  - Time for action - searching with extended query syntax
    - What just happened?
  - Filtering full-text search results
  - Time for action - filtering the result set
    - What just happened?
  - Weighting search results
  - Time for action - weighting search results
    - What just happened?
  - Sorting modes
  - Grouping search results
  - Summary
- 5. Feed Search
  - The application
    - Tools and software used while creating this application
    - Database structure
  - Time for action - creating the MySQL database and tables
    - What just happened?
    - Basic setup
  - Time for action - setting up the feeds application
    - What just happened?
    - Add feed
  - Time for action - creating a form to add feeds
    - What just happened?
    - Saving the feed data
  - Time for action - adding code to save feed
    - What just happened?
    - Indexing the feeds
  - Time for action - create the index
    - What just happened?
    - Check for duplicate items
  - Time for action - adding code to avoid duplicate items
    - What just happened?
    - Index merging
  - Time for action - adding the delta index
    - What just happened?
    - Search form
  - Time for action - creating the search form
    - What just happened?
    - Perform the search query
  - Time for action - adding code to perform a search query
    - What just happened?
    - Applying filters
  - Time for action - adding code to filter the results
    - What just happened?
  - Time for action - showing search form prefilled with last submitted data
    - What just happened?
    - Re-indexing
    - Have a go hero - trying different search queries
  - Summary
- 6. Property Search
  - The application
    - Tools and software used while creating this application
    - Database structure
  - Time for action - creating the MySQL database and structure
    - What just happened?
    - Initial data
  - Time for action - populating the database
    - What just happened?
    - Basic setup
  - Time for action - setting up the application
    - What just happened?
    - Adding a property
  - Time for action - creating the form to add property
    - What just happened?
    - Indexing the properties
  - Time for action - creating the index
    - What just happened?
    - Simple search form
  - Time for action - creating the simple search form
    - What just happened?
    - Full-text search
  - Time for action - adding code to perform full-text search
    - What just happened?
    - Have a go hero - try setting different field weights
    - Advanced search
  - Time for action - creating the Advanced search form
    - What just happened?
    - Ranged filters
  - Time for action - adding ranged filters
    - What just happened?
    - Have a go hero - adding filter for amenities
    - Geo distance search
  - Time for action - creating the search form
    - What just happened?
    - Add geo anchor
  - Time for action - adding code to perform geo distance search
    - What just happened?
    - Have a go hero - adding the delta index using the index merging technique
  - Summary
- 7. Sphinx Configuration
  - Sphinx configuration file
    - Rules for creating the configuration file
  - Data source configuration
    - SQL related options
      - Connection options
        
        sql_port
        
        sql_sock
        
        odbc_dsn
      - Options to fetch data (SQL data source)
        
        sql_query_pre
        
        sql_query_post
        
        sql_query_post_index
        
        sql_ranged_throttle
    - Configuration file using advanced options
  - Time for action - creating a configuration with advanced source options
    - What just happened?
    - MS SQL specific options
      - mssql_winauth
      - mssql_unicode
  - Index configuration
    - Distributed searching
      - Set up an index on multiple servers
  - Time for action - creating indexes for distributed searching
    - What just happened?
      - Set up the distributed index on the primary server
  - Time for action - adding distributed index configuration
    - What just happened?
      - agent_blackhole
      - agent_connect_timeout
      - agent_query_timeout
      - Distributed searching on single server
    - charset configuration
      - charset_type
      - charset_table
    - Data related options
      - stopwords
      - min_word_len
      - ignore_chars
      - html_strip
      - html_index_attrs
      - html_remove_elements
    - Word processing options
      - Morphology
  - Time for action - using morphology for stemming
    - What just happened?
      - morphology
      - min_stemming_len
      - Wordforms
  - Search daemon configuration
    - listen
    - log
    - query_log
    - read_timeout
    - client_timeout
    - max_children
    - pid_file
    - max_matches
    - seamless_rotate
  - Indexer configuration
    - mem_limit
    - max_iops
    - max_iosize
    - max_xmlpipe2_field
  - Summary
- 8. What Next?
  - SphinxQL
    - SphinxQL in action
  - Time for action - querying Sphinx using MySQL CLI
    - What just happened?
    - SELECT
      - Column list clause
        
        FROM clause
        
        WHERE clause
        
        GROUP BY clause
        
        ORDER BY clause
        
        LIMIT clause
        
        OPTION clause
      - SHOW WARNINGS
      - SHOW STATUS
      - SHOW META
  - Use case scenarios
  - Popular websites using Sphinx
  - Summary
- Index

Title: Sphinx Search Beginner's Guide. Implement full-text search with lightning speed and accuracy using Sphinx
Author: Abbas Ali
Original title: Sphinx Search Beginner's Guide. Implement full-text search with lightning speed and accuracy using Sphinx
ISBN: 9781849512558, 9781849512558
Date of issue: 2011-03-16
Format: Ebook
Item ID: e_3as1
Publisher: Packt Publishing

select a language

Categories

E-book details