TICTAC Disease Target Database (PostgreSQL)

Repo for building the docker image of the TICTAC PostgreSQL database. https://hub.docker.com/repository/docker/unmtransinfo/tictac_db/general

Relevant publication:

TICTAC: target illumination clinical trial analytics with cheminformatics
Front. Bioinform., 08 June 2025

https://www.frontiersin.org/journals/bioinformatics/articles/10.3389/fbinf.2025.1579865/full`

Quick start

Modify and run the pull_db.sh script to load the DB into docker container tictac-db.

You can monitor progress like so:

docker logs tictac-db
# wait until message: "Restore complete."

It will take a few minutes to build the database (should be <5 minutes). After this is done you can access the DB like so (modify according to what you used for your env vars used in pull_db.sh):

psql -d tictac_db -h localhost -U tictac_user -p 5532

How the Docker Hub image was built

Manual steps

1. Download the DB dump file: link

   • The dump file was created from:

     pg_dump -h localhost -d tictac_db   --format=custom   --no-owner   --file=tictac_db.dump
     

2. Move the dump file to this directory:

   mv ~/Downloads/tictac_db.dump tictac_db.dump
   

3. Build image:

   docker build -t unmtransinfo/tictac_db:pg18 .
   

4. Add tags to image:

   docker tag unmtransinfo/tictac_db:pg18 unmtransinfo/tictac_db:v2.1
   docker tag unmtransinfo/tictac_db:pg18 unmtransinfo/tictac_db:latest
   

5. Login: docker login

6. Push: docker push unmtransinfo/tictac_db --all-tags

Github actions

See .github/workflows/docker-publish.yml for the github actions workflow used to update the DB image.