[Taginfo-dev] [taginfo/taginfo] 9602c0: Use external content option for full text search i...

[Jochen Topf]

  Branch: refs/heads/master
  Home:   https://github.com/taginfo/taginfo
  Commit: 9602c03af8e7cf183575e68777ddad3be9d56bc1
      https://github.com/taginfo/taginfo/commit/9602c03af8e7cf183575e68777ddad3be9d56bc1
  Author: Jochen Topf <jochen at topf.org>
  Date:   2020-09-26 (Sat, 26 Sep 2020)

  Changed paths:
    M sources/db/add_extra_indexes.sql
    M sources/db/pre.sql
    R sources/master/search.sql
    M sources/master/update.sh
    M web/lib/sql.rb

  Log Message:
  -----------
  Use external content option for full text search index

Use the external content table option for the fts5 full text search
index. This way we need several GB less for the databases. To use
this we need to move the ftsearch table from the taginfo-search.db
into taginfo-db.db and don't need the taginfo-search.db at all
any more.

https://sqlite.org/fts5.html#external_content_and_contentless_tables


  Commit: 257257c4e15290609bbdb2d92ca81d5178b4d30a
      https://github.com/taginfo/taginfo/commit/257257c4e15290609bbdb2d92ca81d5178b4d30a
  Author: Jochen Topf <jochen at topf.org>
  Date:   2020-09-26 (Sat, 26 Sep 2020)

  Changed paths:
    M web/lib/api/v4/search.rb

  Log Message:
  -----------
  Recover from breaking fulltext search

Fulltext search is prone to errors when the sqlite engine doesn't
understand the search syntax. Recover from exceptions because of this
and return an empty result.


  Commit: 16dc3d16038048bb609723cde13d39c26e43a090
      https://github.com/taginfo/taginfo/commit/16dc3d16038048bb609723cde13d39c26e43a090
  Author: Jochen Topf <jochen at topf.org>
  Date:   2020-09-26 (Sat, 26 Sep 2020)

  Changed paths:
    M web/lib/api/v4/search.rb

  Log Message:
  -----------
  Speed up full text search of the form key=value


Compare: https://github.com/taginfo/taginfo/compare/3773cf3d7231...16dc3d160380