yvanzo

WITH RECURSIVE area_descendants AS (
    SELECT entity0 AS parent, entity1 AS descendant, 1 AS depth
      FROM l_area_area laa
      JOIN link ON laa.link = link.id
     WHERE link.link_type = 356
       AND entity1 IN (5099, 8127)
     UNION
    SELECT entity0 AS parent, descendant, (depth + 1) AS depth
      FROM l_area_area laa
      JOIN link ON laa.link = link.id

yvanzo

FROM postgres:12

ARG DEBIAN_FRONTEND=noninteractive

# install_extensions.sh removes certain build dependencies that we need, so we
# can't install everything here.
# Note: curl is also a dependency of carton.
RUN apt-get update && ( \
    apt-get install --no-install-suggests --no-install-recommends -y ca-certificates curl sudo || ( \
        apt-key adv --keyserver keyserver.ubuntu.com --refresh-keys && \

yvanzo

ARG PYTHON_VERSION=2.7
FROM metabrainz/python:${PYTHON_VERSION}

ARG PYTHON_VERSION

LABEL org.label-schema.schema-version="1.0.0-rc1" \
      org.label-schema.vendor="MetaBrainz Foundation" \
      org.metabrainz.based-on-image="metabrainz/python:${PYTHON_VERSION}"

#######################

yvanzo

React conversion

Current status (minor many opened PRs, minor converted code not removed yet)

• Template Toolkit 200 files mostly about editing, very similar

Expected time of arrival

• When it is ready!
• 2020 Q4 seems too optimistic
• 2021 Q2 looks more realistic

yvanzo

Steps to bring changes to MB WS/2 (browse/lookup/search) when it affects search:

1. Update and release mmd-schema (Mb metaData Schema) (including Relax NG schema + Java bindings)

2. Update and release mb-solr (search server) (including unit tests) (do not deploy yet)

3. Update sir (search indexer)

yvanzo

Ongoing stuff

• Improve queuing for SIR, thanks to mglubb’s PR - yvanzo
• Update to Java 11 for MB Solr - lucifer
• Fix inconsistencies with MB WS browse/lookup in MB Solr JSON output - lucifer
• Investigate SIR’s usage of SQLAlchemy - alastairp/bitmap

## Major short-term issues

• SIR indexing performances for mirrors (using musicbrainz-docker)

yvanzo

diff --git a/docker-compose.yml b/docker-compose.yml
index ec558603..8e0a0393 100644
--- a/docker-compose.yml
+++ b/docker-compose.yml
@@ -81,24 +81,18 @@ services:
       - search
 
   search:
-    build:
-      context: build/solr

yvanzo

version: '3.1'

# Description: Run local version of MusicBrainz Server Perl code

services:
  musicbrainz:
    volumes:
      - ${MUSICBRAINZ_SERVER_LOCAL_LIB_PATH}:/musicbrainz-server/lib

yvanzo

version: '3.1'

# Description: Use remote search server

services:
  musicbrainz:
    environment:
      - MUSICBRAINZ_SEARCH_SERVER=search.musicbrainz.org

yvanzo

secrets:
  metabrainz_access_token:
    file: local/secrets/metabrainz_access_token
services:
  db:
    build:
      args:
        POSTGRES_VERSION: '12'
      context: build/postgres
    command: postgres -c "shared_buffers=4GB" -c "shared_preload_libraries=pg_amqp.so"