3mo ago

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

Open Source @lemmy.ml

Zerush @lemmy.ml

7mo ago

github.com /outerbase/studio

42 comments

DBeaver is a bit clunky, but just too god to replace
- Yeah, DBeaver used to be unusable, but it is quite decent these days. I was really unhappy with Datagrip, so I decided to give it another try and I am glad I did.
  As far as this tool goes, I don't love the idea of having my tools in the browser, so this won't work for me, but it is a cool project nonetheless.
https://www.homereview.in/cloudflare-acquires-outerbase-to-expand-database-and-agent-developer-experience-capabilities/
- we are very excited about being part of the Claudflair team
  Guess they're so excited (and thrilled) that they forgot how to spell
  
  in this way that makes you feel natural
  The whole post needs a proofreader since it's full of errors.
- Here’s an official announcement: https://www.outerbase.com/blog/were-joining-cloudflare/
I'm getting flashbacks to phpmyadmin.
How does it compare to Adminer?
- It looks like outerbase studio is primarily written in typescript where adminer is php.
  
  Was that an answer from ChatGPT?
- or to chartDB

If anyone got this running in docker for example, I like to hear from you ;)

Looks like it is provided here.

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

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)

~~An electron app still needs to be served by a web server, even if the actual business logic is all client-side~~
EDIT: Electron, not React...

Cool!
Do you plan to support adbc?
Sick. I've tried a few times in the past to find a frontend for postgres that I liked, and was never able to. Will have to give this a try.
- Same.
  Only thing is, when I run it the postgresql driver is 'invalid'. But I'm trying with an older version, like this:
  docker run --rm -it --name outerbase --network host -h outerbase.local chewcw/outerbase-studio:v0.9.2

42 comments