You are here

README.txt in Search API 8

Database Search
---------------

This module provides a database-based implementation of the Search API. The
database and target to use for storing and accessing the indexes can be selected
when creating a new server.

All Search API data types are supported by using appropriate SQL data types for
their respective columns.

The "direct" parse mode for queries will result in a simple splitting of the
query string into keys. Additionally, search keys containing whitespace will be
split for all parse modes, as searching for phrases is currently not supported.

Supported optional features
---------------------------

- search_api_autocomplete
  Introduced by module: search_api_autocomplete
  Lets you add autocompletion capabilities to search forms on the site. (See
  also "Hidden variables" below for backend-specific customization.)
  NOTE: Due to internal database restrictions, this will perform significantly
  better if only a single field is used for autocompletion.
- search_api_facets
  Introduced by module: facets
  Allows you to create faceted searches for dynamically filtering search
  results.
- search_api_facets_operator_or
  Introduced by module: facets
  Allows the use of the "OR" operator for facets.

If you feel some backend option is missing, or have other ideas for improving
this implementation, please file a feature request in the project's issue queue,
at [1], using the "Database search" component.

[1] http://drupal.org/project/issues/search_api

Known problems
--------------

Using facets and autocomplete suggestions with a database server will only work
if the database user Drupal is using has the "CREATE TEMPORARY TABLES"
permission (or similar, in DBMSs other than MySQL).

Developer information
---------------------

Database queries for searches with this module are tagged with
"search_api_db_search" to allow easy altering. As metadata, such database
queries will have the Search API query object set as "search_api_query", and the
field settings of the server for the corresponding search index as
"search_api_db_fields".

Hidden configuration
--------------------

- search_api_db.settings.autocomplete_max_occurrences (default: 0.9)
  By default, keywords that occur in more than 90% of results are ignored for
  autocomplete suggestions. This setting lets you modify that behavior by
  providing your own ratio. Use 1 or greater to use all suggestions.

File

modules/search_api_db/README.txt
View source
  1. Database Search
  2. ---------------
  3. This module provides a database-based implementation of the Search API. The
  4. database and target to use for storing and accessing the indexes can be selected
  5. when creating a new server.
  6. All Search API data types are supported by using appropriate SQL data types for
  7. their respective columns.
  8. The "direct" parse mode for queries will result in a simple splitting of the
  9. query string into keys. Additionally, search keys containing whitespace will be
  10. split for all parse modes, as searching for phrases is currently not supported.
  11. Supported optional features
  12. ---------------------------
  13. - search_api_autocomplete
  14. Introduced by module: search_api_autocomplete
  15. Lets you add autocompletion capabilities to search forms on the site. (See
  16. also "Hidden variables" below for backend-specific customization.)
  17. NOTE: Due to internal database restrictions, this will perform significantly
  18. better if only a single field is used for autocompletion.
  19. - search_api_facets
  20. Introduced by module: facets
  21. Allows you to create faceted searches for dynamically filtering search
  22. results.
  23. - search_api_facets_operator_or
  24. Introduced by module: facets
  25. Allows the use of the "OR" operator for facets.
  26. If you feel some backend option is missing, or have other ideas for improving
  27. this implementation, please file a feature request in the project's issue queue,
  28. at [1], using the "Database search" component.
  29. [1] http://drupal.org/project/issues/search_api
  30. Known problems
  31. --------------
  32. Using facets and autocomplete suggestions with a database server will only work
  33. if the database user Drupal is using has the "CREATE TEMPORARY TABLES"
  34. permission (or similar, in DBMSs other than MySQL).
  35. Developer information
  36. ---------------------
  37. Database queries for searches with this module are tagged with
  38. "search_api_db_search" to allow easy altering. As metadata, such database
  39. queries will have the Search API query object set as "search_api_query", and the
  40. field settings of the server for the corresponding search index as
  41. "search_api_db_fields".
  42. Hidden configuration
  43. --------------------
  44. - search_api_db.settings.autocomplete_max_occurrences (default: 0.9)
  45. By default, keywords that occur in more than 90% of results are ignored for
  46. autocomplete suggestions. This setting lets you modify that behavior by
  47. providing your own ratio. Use 1 or greater to use all suggestions.