PostgreSQL database server running locally in a Renku docker container

#1

Hello,

On the Renku Best Practices Gitlab group, it is shown how to connect to a remote PostgreSQL database server, which is useful.

  • Would it be possible to have a PostgreSQL database server running locally in a Renku docker container ?
  • If yes, what would be the best way to implement this in a Renku project ?

Thanks !

#2

Hi @champost - do you need a full postgres server or would something simpler like sqlite be sufficient given that it’s just running locally? In any case, you could certainly install a server and run it inside the container if you wanted. You would need to install it in the image and then start it, either in the image directly or via a post-init.sh script (which runs after the session starts so it has all the local state if you need it for e.g. environment variables).

#3

Hi @rrrrrok,

Thanks for the input.

sqlite does seem be a good option for our use-case and the sqlite3 python package seems to be available “out of the box” in Renku !

1 Like
#4

great, let me know how it goes!