Skip to content

README.md

Latest commit

 

History

History
64 lines (40 loc) · 1.79 KB

README.md

File metadata and controls

64 lines (40 loc) · 1.79 KB

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.