diff options
author | Yorhel <git@yorhel.nl> | 2021-11-18 10:51:58 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2021-11-18 10:52:04 +0100 |
commit | 5b4bd7befcc80cbaf43c07a356acbd45dfdd5dfa (patch) | |
tree | 1fece90a062eb79de5a3060d989225ace66137cb /Dockerfile | |
parent | 4a167aaad01fae953ecd72ecccff78ee6248d1fb (diff) |
Releases: Experiment with new SQL search implementation
Goal is to use the improved search normalisation mechanism that VN
search has had for ages on other database types as well (releases with
this commit; producers, staff and characters to come later).
Another goal is to do the search cache updates within SQL, removing the
Perl search normalization and the round-trip through Multi every time an
entry needs to be updated.
Requires the 'unaccent' Postgres extension. I considered writing my own
unaccent rules file, but decided against it for now. Current approach
works pretty well.
Diffstat (limited to 'Dockerfile')
-rw-r--r-- | Dockerfile | 3 |
1 files changed, 2 insertions, 1 deletions
@@ -1,7 +1,7 @@ FROM alpine:3.13 MAINTAINER Yorhel <contact@vndb.org> -ENV VNDB_DOCKER_VERSION=7 +ENV VNDB_DOCKER_VERSION=8 CMD /var/www/util/docker-init.sh RUN apk add --no-cache \ @@ -18,6 +18,7 @@ RUN apk add --no-cache \ perl-json-xs \ perl-module-build \ postgresql \ + postgresql-contrib \ postgresql-dev \ sassc \ wget \ |