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

  It seems there is a misunderstanding. To be clear, this is what I mean:

  ┌───────────────────────┐    
  │ Browser               │    
  └───────────────────────┘    
       ▲                       
       │ port 443 open         
       │                       
       │                       
  ┌────┼──────────────────┐    
  │ Proxy (traefik)       │    
  └───────────────────────┘    
       ▲                       
       │                       
       │ web port open to proxy
       │                       
       │                       
  ┌────┼──────────────────┐    
  │ DBgate (in docker)    │    
  └───────────────────────┘    
       ▲                       
       │                       
       │                       
       │                       
  ┌────┼──────────────────┐    
  │ Database              │    
  └───────────────────────┘    
  

  source

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

    That’s not how it works, or maybe the arrows are pointing the wrong direction in your ASCII. DBgate is an in-browser application in the same way that the other posted is, just with different features. They both run completely in the browser, BUT the files need to get loaded there first right? So the docker version of DBgate is simply starting a tiny web server that bootstraps the client application into your browser when you visit the local port. It’s right in their docs.

    No server-side code at all, and in fact, you can kill the docker container after you get it loaded in your browser if you want to double check 😉

    source