sql-studio icon indicating copy to clipboard operation
sql-studio copied to clipboard

Wrap it with docker

Open vitonsky opened this issue 1 year ago • 3 comments

Hi, it is good idea to wrap your code with docker container, to let world to try your solution.

The instructions for a docker is a modern standard of distribution for a web software.

It's pretty hard to build all the thing on my PC to just see every solution on the github, so me and lot of another people will just skip a repo with instructions "how to build" and with no instructions "how to run right here right now with docker".

vitonsky avatar Jun 16 '24 23:06 vitonsky

We do have pre built binaries available on the releases page.

We also have a version on Docker Hub but that docker image only allows you to view a sample database. It doesn't allow you to configure your own sqlite database. We will add that feature soon.

frectonz avatar Jun 16 '24 23:06 frectonz

Maybe, what you can do is that, you check the if there is a sqlite in a specific folder. Example you have /database folder in the project. if the the rust code find a .db file inside it will load it. It allows anyone to create a volume to this folder.

eznix86 avatar Jun 21 '24 16:06 eznix86

It is really useful to debug things sometimes for sure. I am running this on my node alongside Tailscale, works great

services:
  sqlite-studio:
    image: frectonz/sqlite-studio:0.1.8
    command: /nix/store/84b16i4lzii52bzbdggf5b17qsarp00p-sqlite-studio-0.1.8/bin/sqlite-studio --address=0.0.0.0:3030 sqlite /mounted/${DATABASE_NAME}
    volumes:
      - ${DATABASE_PATH}:/mounted

It would be nice to have a cleaner way to do it tho, and a latest tag :D

Cufee avatar Jun 23 '24 22:06 Cufee

A docker image for SQL Studio is available on the Docker Hub.

https://hub.docker.com/r/frectonz/sql-studio

The sql-studio binary can be found at the path /bin/sql-studio in the docker image. This binary can be used to run SQL Studio with any of its supported drivers by passing in the appropriate CLI arguments.

frectonz avatar Oct 31 '24 11:10 frectonz