Skip to content
Snippets Groups Projects
Select Git revision
  • master default protected
  • greenkeeper/webpack-4.10.1
  • greenkeeper/webpack-4.10.0
  • greenkeeper/webpack-4.9.2
  • greenkeeper/promise-polyfill-8.0.0
  • greenkeeper/webpack-4.9.1
  • greenkeeper/webpack-4.9.0
  • greenkeeper/webpack-manifest-plugin-2.0.3
  • greenkeeper/update-to-node-10
  • gh-pages
  • greenkeeper/webpack-4.8.3
  • greenkeeper/webpack-4.8.2
  • greenkeeper/webpack-4.7.0
  • greenkeeper/webpack-manifest-plugin-2.0.2
  • greenkeeper/webpack-manifest-plugin-2.0.1
  • greenkeeper/style-loader-0.21.0
  • greenkeeper/webpack-4.6.0
  • greenkeeper/sass-loader-7.0.1
  • greenkeeper/sass-loader-7.0.0
  • greenkeeper/webpack-manifest-plugin-2.0.0
  • 2.7.3
  • 2.7.2
  • 2.7.1
  • 2.7.0
  • 2.6.6
  • 2.6.5
  • 2.6.4
  • 2.6.3
  • 2.6.2
  • 2.6.1
  • 2.6.0
  • 2.5.5
  • 2.5.4
  • 2.5.3
  • 2.5.2
  • 2.5.1
  • 2.5.0
  • 2.4.0
  • 2.3.0
  • 2.2.6
40 results

docs

  • Clone with SSH
  • Clone with HTTPS
  • Quassel RESTSearch

    This is a websearch frontend for a quassel database.

    It offers both a simple HTTP API for search, and a normal website for the same purpose.

    Setting up search backends

    ####pgsql-smart

    First, add a new column to the backlog table:

    ALTER TABLE public.backlog ADD COLUMN tsv tsvector;

    Second, add the two new indices:

    CREATE INDEX backlog_tsv_idx
      ON public.backlog
      USING gin(tsv);
    CREATE INDEX backlog_tsv_filtered_idx
      ON public.backlog
      USING gin(tsv)
      WHERE (type & 23559) > 0;

    Third, set up a trigger to populate the tsv column:

    CREATE TRIGGER tsvectorupdate
      BEFORE INSERT OR UPDATE
      ON public.backlog
      FOR EACH ROW
      EXECUTE PROCEDURE tsvector_update_trigger('tsv', 'pg_catalog.english', 'message');

    Fourth, populate the tsv column:

    UPDATE public.backlog SET public.backlog.messageid = public.backlog.messageid;

    Setting up the search

    First, rename the file qrs_config.default.php to qrs_config.php.

    Then configure the database access, backend (currently only pgsql-smart is available), and the prefix of the path.

    License and Credits

    The error image is from xiprox/ErrorView and under Apache2.

    This project uses the "Material Icons" font from Google, available under Apache2.

    The rest of this project is available under LGPLv2.1 or later.