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