Can I specify a database to automatically open?

[halfer]

Is this a new feature request?

• I have searched the existing issues

Wanted change

Hi folks

I'm logging this as a "feature request", but I expect it is already possible. I have scoured the docs fairly thoroughly, and cannot find anything.

I have set up this image in my Docker Compose like so:

  db-browser:
    image: lscr.io/linuxserver/sqlitebrowser:latest
    ports:
      - 3000:3000
    environment:
      - FM_HOME=/database
    volumes:
      - ../database:/database
      - ../storage/sqlitebrowser:/config

This seems to work great; the database volume lets the system read from my SQLite folder. However I'd love to be able to load a database automatically, as for my current project I'll always be working on just one database.

I wonder if it could be this file?

https://github.com/linuxserver/docker-sqlitebrowser/blob/master/root/defaults/autostart

Could I just amend this to have a fully-qualified database pathname, and it would auto-open? I'd need my own Dockerfile so as to make this change, but that is not much bother. (I may yet try this, but it is rather guesswork at this stage).

Thanks for your work - this is going to be very useful!

Reason for change

I suspect this is not a code change, maybe a documentation change. I think it would be a generally useful feature.

Proposed code change

Probably a code change is not necessary.

[github-actions]

Thanks for opening your first issue here! Be sure to follow the relevant issue templates, or risk having this issue marked as invalid.

[halfer]

Right, well I tried modifying the /root/autostart file, and the browser app still starts up, but there does not seem to be any autoloading.

Might there be an env var for this that I've simply overlooked?

[aptalca]

Check if the sqlitebrowser accepts such arguments or env vars. That's not under our control.

[halfer]

Thanks for the note @aptalca.

I notice in the VNC windowing environment, I can close the "DB Browser for SQLite" window, right-click to get a GUI context menu, choose "xterm", then type sqlitebrowser /database/database-dev.sqlite and that has the effect that I want.

I note also that without my writing the /root/autostart file with a custom Dockerfile, there is no file in this location at all. So I think I have misunderstood where the default command of sqlitebrowser is stored so that it is invoked on GUI start-up.

Thus I don't think this is a downstream issue per se; I just need to find where this command is stored. Is it started by the S6 supervisor system?

[halfer]

Ha, well I found a yucky solution. I worked out where the executable was, and hacked it in a downstream image. I'd be happy if there is an easier way to do this, but it'll do for now...

FROM lscr.io/linuxserver/sqlitebrowser:latest

# Ooh, a bit hacky!
RUN mv /usr/bin/sqlitebrowser /usr/bin/sqlitebrowser-exec
RUN echo '#!/bin/bash' > /usr/bin/sqlitebrowser
RUN echo '/usr/bin/sqlitebrowser-exec /database/database-dev.sqlite' >> /usr/bin/sqlitebrowser
RUN chmod +x /usr/bin/sqlitebrowser

[aptalca]

If the cli argument works, you can just set it in autostart in the config folder. That's persistent

[LinuxServer-CI]

This issue has been automatically marked as stale because it has not had recent activity. This might be due to missing feedback from OP. It will be closed if no further activity occurs. Thank you for your contributions.

[github-actions]

This issue is locked due to inactivity