Hi folks! I'm deploying a self-hosted Galaxy instance & trying to connect to CockroachDB, which is similar to Postgres but can automatically scale & backup data. But since CockroachDB is relatively new, the Galaxy data definitions require some SQL features not yet implemented in that dialect.
sqlalchemy.exc.NotSupportedError: (psycopg2.errors.FeatureNotSupported) at or near "if": syntax error: unimplemented: this syntax DETAIL: source SQL: DROP TRIGGER IF EXISTS trigger_history_dataset_association_bir ^ HINT: You have attempted to use a feature that is not yet implemented. See: https://go.crdb.dev/issue-v/28296/v21.2
Does anyone know where the data definitions for Galaxy are? I can't find a clear reference in documentation or within the galaxy-docker repo. I'll try to workaround these SQL triggers (and any other SQL that may not be implemented) if possible.
sqlite_install; guess you need to work out a
<param name="bcldir" type="directory" />where the user can browse to a path on the network and select a folder as as a parameter?