how to include Adminer into docker-compose for easy database access

[aisbergde]

The feature

https://immich.app/docs/guides/database-queries lists some queries.
it looks like, that it is very easy to add Adminer to the docker-compose, and this way administrators get very easy GUI access to the database. See idea posted by @jurekl in #6093 (reply in thread)_

Could we include this into the documentation as a hint?
my configuration:

  adminer:
    container_name: immich_adminer
    image: adminer
    ports:
      - 8080:8080
    environment:
      ADMINER_DEFAULT_SERVER: immich_postgres
    depends_on:
      - database

maybe the port mapping is not the best, if it is already used

Can users just contribute to the docs?

Platform

• Server
• Web
• Mobile

[zackpollard]

There is plenty of documentation on the web on how to setup this kind of thing, imo this is out of scope of the documentation we should give for Immich itself.

[aisbergde]

I don't agree. For example, this hint of possible automation was very helpful:
https://immich.app/docs/guides/template-backup-script

This part was not so helpful for me on https://immich.app/docs/guides/database-queries, because it's only about command line access. But many users prefer a GUI. I prefer GUI

Run docker exec -it immich_postgres psql immich <DB_USERNAME> to connect to the database via the container directly.
(Replace <DB_USERNAME> wit the value from your .env file).

Regarding Adminer, I would be happy, if I would found such an easy solution in the docs. Instead of, I tried to implement external access to my posgreSQL database, installed pgAdmin 4, just to get access to the immich database. Because I even didn't know about the existence of Adminer. Knowing this before, it would have saved me hours.

Why not make life easier for other immich administrators, if it would be so easy to add this kind of hint into the docs? Why all immich admins should be nerds, knowing, how to work in linux, with docker, databases, using CLI and so on?

And it is not complicated to add a small hint into the docs. I even would do this, if I am allowed. But reading your commet, I am afraid, this change could be rejected. CLI is fine, but GUI also.

[bo0tzz]

If we're going to document any add-on tools like this that people might want to use with Immich, the docs will become huge and unmaintainable. There's plenty of information about these topics in other places around the internet.

Why all immich admins should be nerds, knowing, how to work in linux, with docker, databases, using CLI and so on?

Because administering Immich takes that sort of knowledge. It's not just about running the Immich containers and installing the mobile app, running Immich also involves broader system administration knowledge to ensure that your data is safe and durable.