Comment on GitHub - outerbase/studio: A lightweight Database GUI in your browser. It supports connecting to Postgres, MySQL, and SQLite.

jogai_san@lemmy.world ⁨1⁩ ⁨week⁩ ago

• just_another_person@lemmy.world ⁨1⁩ ⁨week⁩ ago

  It’s an electron app that runs from the browser. Why would need it to run via docker?

  source

  • jogai_san@lemmy.world ⁨1⁩ ⁨week⁩ ago

    Ok, I updated my drawing, so the arrows are correct:

    ┌─────────────────────────────────────────────────────────────────┐
    │ Browser                                                         │
    └─────────────────────────────────────────────────────────────────┘
                                    ▲                                  
                                    │ :443                             
                                    │ :80                              
                                    ▼                                  
    ┌────────────────────────────────────────────────────────────────┐ 
    │ Proxy (traefik)                                                │ 
    └────────────────────────────────────────────────────────────────┘ 
         ▲                               ▲                  ▲          
         │                               │                  │          
         │ :3000                         │ :8085            │  :5001   
         │                               │                  │          
         ▼                               ▼                  ▼          
    ┌───────────────────────┐   ┌────────────────┐  ┌────────────────┐ 
    │ DBgate (in docker)    │   │ pgBackupWeb    │  │ My custom app  │ 
    └───────────────────────┘   └────────────────┘  └────────────────┘ 
         ▲                               ▲               ▲             
         │ :5432                         │ :5432         │ :5432       
         │                               │               │             
         ▼                               ▼               ▼             
    ┌────────────────────────────────────────────────────────────────┐ 
    │ Database                                                       │ 
    └────────────────────────────────────────────────────────────────┘ 
    

    DbGate is connecting to my postgresql db. If I kill the container the communication is cut off. The ports 3000, 8089, 5001, 5432 are not open. How does DbGate load my postgres data then, if no backend? Sometimes I use it when my client messes up something thats only repairable in the db. Thats the exact scenario where its useful to run it in docker.

    It’s right in their docs

    Where? The app runs in the browser, but the data is still remote (from the pov of the browser)

    source

    • just_another_person@lemmy.world ⁨1⁩ ⁨week⁩ ago

      Again, no.

      DBGate is an application running in your browser. Just like any other desktop application, except it’s code is executed in the browser, and not a standalone window. DBGate uses the runtime platform of your browser to execute code and create connections to the database you’re using. That’s where you’re getting confused. There is nothing running in the docker container except a dumb HTTP server that allows your browser to load the code to executed, just as if you had visited their website.

      This same exact code can also be packaged to run in Electron as a standalone window in your desktop so it seems like its own app. Same exact code that runs in your browser, but using Electron to host and execute its code.

      source

      • jogai_san@lemmy.world ⁨1⁩ ⁨week⁩ ago

        Show me the docs. It really sounds like you’re confidentially incorrect :-)

        The app part is indeed just running in the browser. But it needs the data over an external connection. Explain how it can read/write the data to me.

        source

        • -> View More Comments
  • 8osm3rka@lemmy.world ⁨1⁩ ⁨week⁩ ago

    An electron app still needs to be served by a web server

    source

    • just_another_person@lemmy.world ⁨1⁩ ⁨week⁩ ago

      No? This is a client-side electron app. You’d need something to load the initial files, but that’s it. There are no server-side running parts. Even still, there’s links in the project here to load up the app right there. Each Major browser has ways to “install” such apps from there.

      source

      • jogai_san@lemmy.world ⁨1⁩ ⁨week⁩ ago

        Well, I assume there is a backend which takes care of securely connecting to the databases. That way I can connect the backend to the internal network where I can connect to the database, and without exposing the database port still use this from the browser.

        source

        • -> View More Comments
      • 8osm3rka@lemmy.world ⁨1⁩ ⁨week⁩ ago

        I had a brain fart and confused React with Electron…

        source
• Botzo@lemmy.world ⁨1⁩ ⁨week⁩ ago

  Looks like it is provided here.

  source