Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Show HN: Outerbase Studio – Open-Source Database GUI

github.com

Post reply on HN
Print view View original

101–110 of 153 posts

Re: Show HN: Outerbase Studio – Open-Source Database GUI

#101

Post by RyanHamilton »

KronisLV wrote: post #97
j1mmie wrote: post #29

For years I've wondered why a general purpose, high quality, good UX, browser based DB browser has not existed. I've implemented 3 such (not general-purpose) browsers in my career. But I'd be really happy to stop doing that and use this instead. I would love to see a Firestore driver implemented (maybe I'll take a crack at it some day), as I'm stuck in GCP land for the time being.

> browser based For whatever reason, this is the main limiting factor, local software can already be really good, for example: • DBeaver - pretty nice and lightweight local tool for a plethora of databases https://dbeaver.io/ • DataGrip - commercial product, but you'll feel right at home if you use other JetBrains products https://www.jetbrains.com/datagrip/ • HeidiSQL - haven't really used this myself but the versio…

QStudio. Editor and notebook in one, works on all os with 30+ databases and is Free: https://www.timestored.com/qstudio/ disclaimer: I'm the author

Re: Show HN: Outerbase Studio – Open-Source Database GUI

#102

Post by RyanHamilton »

mritchie712 wrote: post #56
j1mmie wrote: post #29

For years I've wondered why a general purpose, high quality, good UX, browser based DB browser has not existed. I've implemented 3 such (not general-purpose) browsers in my career. But I'd be really happy to stop doing that and use this instead. I would love to see a Firestore driver implemented (maybe I'll take a crack at it some day), as I'm stuck in GCP land for the time being.

I think it's because there's no business model in the pure "DB browser" product. People don't seem willing to pay enough for it to build a good business around it. Everyone I've seen either pivots to a Retool competitor or a BI tool. Source: I've tried it twice.

For 12 years I got banks to pay for an editor I created. But yeah to grow the audience I made the database client free as others wouldn't pay. I have also created a separate BI tool so you're totally correct.

Re: Show HN: Outerbase Studio – Open-Source Database GUI

#103

Post by jgrpf »

j1mmie wrote: post #29

For years I've wondered why a general purpose, high quality, good UX, browser based DB browser has not existed. I've implemented 3 such (not general-purpose) browsers in my career. But I'd be really happy to stop doing that and use this instead. I would love to see a Firestore driver implemented (maybe I'll take a crack at it some day), as I'm stuck in GCP land for the time being.

DbGate might fit your needs: https://dbgate.org/

It even has a demo: https://demo.dbgate.org/

Re: Show HN: Outerbase Studio – Open-Source Database GUI

#104

Post by tronikel »

burcs wrote: post #41
shreddit wrote: post #40

Can i put it inside a docker container alongside my pg container and serve it under a path like “/dbadmin” with password protection? That’s my current workflow with pgadmin.

Definitely! We actually embed studio as part of another one of our offerings. It's actually iframed in, but you could achieve similar results if you wanted to dockerize it. https://github.com/Brayden/starbasedb/blob/main/src/studio/i...

Any plans to add a dockerfile or push images so we could easily launch a container with 0 config?

Re: Show HN: Outerbase Studio – Open-Source Database GUI

#105

Post by Dachande663 »

We currently use Metabase for SQL reporting, so I've been looking for something to allow actually changing values for a while. That being said, I don't think I would want to touch this. Reading through the code, it looks like a) it doesn't actually use transactions which I just find mind blowing and b) the first two files I looked at (api/database) has the schema for a database defined twice so already I worry about the data model of the app, let alone managing my own.

Re: Show HN: Outerbase Studio – Open-Source Database GUI

#106

Post by kennethh »

KronisLV wrote: post #97
j1mmie wrote: post #29

For years I've wondered why a general purpose, high quality, good UX, browser based DB browser has not existed. I've implemented 3 such (not general-purpose) browsers in my career. But I'd be really happy to stop doing that and use this instead. I would love to see a Firestore driver implemented (maybe I'll take a crack at it some day), as I'm stuck in GCP land for the time being.

> browser based For whatever reason, this is the main limiting factor, local software can already be really good, for example: • DBeaver - pretty nice and lightweight local tool for a plethora of databases https://dbeaver.io/ • DataGrip - commercial product, but you'll feel right at home if you use other JetBrains products https://www.jetbrains.com/datagrip/ • HeidiSQL - haven't really used this myself but the versio…

Great list.

Azure Data Studio is pretty good and free to use. https://learn.microsoft.com/en-us/azure-data-studio

Supports of course most MS products but also: PostgreSQL MySQL MongoDB Apache Spark Apache Cassandra

Re: Show HN: Outerbase Studio – Open-Source Database GUI

#107

Post by wazoox »

RyanHamilton wrote: post #101
KronisLV wrote: post #97

Earlier quoted context omitted.

> browser based For whatever reason, this is the main limiting factor, local software can already be really good, for example: • DBeaver - pretty nice and lightweight local tool for a plethora of databases https://dbeaver.io/ • DataGrip - commercial product, but you'll feel right at home if you use other JetBrains products https://www.jetbrains.com/datagrip/ • HeidiSQL - haven't really used this myself but the versio…

QStudio. Editor and notebook in one, works on all os with 30+ databases and is Free: https://www.timestored.com/qstudio/ disclaimer: I'm the author

Looks great, how come I didn't know it? :)

Re: Show HN: Outerbase Studio – Open-Source Database GUI

#108

Post by RyanHamilton »

wazoox wrote: post #107
RyanHamilton wrote: post #101

Earlier quoted context omitted.

QStudio. Editor and notebook in one, works on all os with 30+ databases and is Free: https://www.timestored.com/qstudio/ disclaimer: I'm the author

Looks great, how come I didn't know it? :)

I'm bad at marketing and poor at product decisions. For 10 years it only worked with one database. It took 30 lines of code to work on many more databases but I waited 10 years to do it. Don't make my mistake! I am trying to get better.

Re: Show HN: Outerbase Studio – Open-Source Database GUI

#109

Post by avinassh »

johtso wrote: post #7
drewp wrote: post #4

Earlier quoted context omitted.

Are there comparisons to related projects somewhere? E.g. I've use DBeaver before. Is there some reason I should try Outerbase next time?

Don't think DBeaver supports libsql databases? I think the goal here is to be able to working with Turso / Cloudflare D1 databases etc.

it does now: https://github.com/dbeaver/dbeaver-jdbc-libsql
Post reply on HN