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