e-learning

Galaxy Database schema

Abstract

For the hands-on examples you need access to a Galaxy server and access to its PostgreSQL database. You can set-up this yourself, or use the Galaxy Docker Image provided by Björn Grüning (https://github.com/bgruening/docker-galaxy-stable). During this tutorial, we will work with the Galaxy Docker Image.

About This Material

This is a Hands-on Tutorial from the GTN which is usable either for individual self-study, or as a teaching material in a classroom.

Questions this will address

  • Running a production Galaxy server, you some times end up in with a situation, where you manually need to interact with the Galaxy database: how do you do that
  • How to extract usage information, which can not be gathered using the given report tools
  • How to move from MySQL to PostgreSQL
  • Is there ever a need to manually change the contents of a table

Learning Objectives

  • Learn some of the design concepts of the Galaxy database
  • Extract information from the Galaxy database
  • Get to know SchemaSpy

Licence: Creative Commons Attribution 4.0 International

Keywords: Galaxy Server administration

Target audience: Galaxy Administrators

Resource type: e-learning

Version: 22

Status: Active

Learning objectives:

  • Learn some of the design concepts of the Galaxy database
  • Extract information from the Galaxy database
  • Get to know SchemaSpy

Date modified: 2023-11-09

Date published: 2016-07-20

Authors: Björn Grüning, Hans-Rudolf Hotz

Contributors: Björn Grüning, Hans-Rudolf Hotz


Activity log