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 ?
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).
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 !
great, let me know how it goes!