Database access

[iRoboton]

Good morning,

First of all, thanks for the awesome looking board. I like it simplicity yet sleek design. I have a question however. I installed via the automated install script (on a RPi4), all good. Up and running.

Now the question I have, can I access the PostgreSQL database? I am new to the Docker mechanism and can't get my finger around it. Main goal is to be able to add a lot of (or edit in the future) cards at once, via SQL scripting.

Client-side I will manage, just not sure where to look for the DB, credentials etc. Any hint is welcome :)
Next step will be for me to discover how this Docker stuff actually works with overwrites and cloning and all so I can start making Dutch translations and all to the board.

Thanks in advance.

[meltyshev]

Hi! Sorry for the late reply.
You can execute database queries by docker exec --user postgres -t planka-postgres-1 psql -d planka -c "SELECT * FROM migration" (just need to change the query itself in quotes).
It would be very nice to have a Dutch translation, it's really missing 🙏