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

121–130 of 153 posts

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

#121

Post by burcs »

Dachande663 wrote: post #105

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…

This is good feedback, we are working on adding in transaction support to the open source version. For what it's worth, our cloud product wraps everything in a transaction.

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

#122

Post by burcs »

dav43 wrote: post #91

Looks nice and make be helpful. Keep in mind I can’t and most people can’t install this in a corp environment. If you get a pip install or npm install I’d be able to use it through corporate mirrors internally. Make it as easy to run as something like datasette.

Would the browser version suffice? If not we support running commands like:

$ npx @outerbase/studio \ --port=5000 \ --user=admin --pass=123 \ mysql://root:123@localhost:3306/chinook

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

#123

Post by bbkane »

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…

Two more tools I really enjoy:

- https://www.beekeeperstudio.io/ - electron based and I find it really simple to use.

- https://github.com/k1LoW/tbls - generate markdown docs from databases (similar to DbVisualizer, but it's a static binary and you can just push the md files - see https://github.com/bbkane/envelope/tree/master/dbdoc for example)

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

#124

Post by [deleted] »

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…

[deleted]

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

#125

Post by asmith11 »

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…

Jailer is awesome and really not “niche”. Also, it's not something for exploring "datasets", but for tables and relational databases in an innovative way. I think it would be fantastic if more people knew about it. (https://wisser.github.io/Jailer/)

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

#126

Post by earthnail »

RyanHamilton wrote: post #108
wazoox wrote: post #107

Earlier quoted context omitted.

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.

The chart feature looks amazing. I’d try making a landing page just around charts and see if it sticks.

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

#127

Post by bko »

This looks great. I've built something similar. The important thing that I'm not sure if you support is permissioning.

Consider you have some email list that you need to maintain and ideally you want to let others maintain. Throw it in a table and give them permission to add rows.

There are a ton of things that I consider 'configs' like that and can't believe there aren't strong standards about how to do these sort of maintenance things (or maybe there are but I'm unaware)

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

#128

Post by anbotero »

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 interesting. Have you thought about providing it as a Homebrew Cask? Anyways, looking into it.

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

#130

Post by burcs »

Vinnl wrote: post #129
vollbrecht wrote: post #96

It seams that you currently only support Windows and MacOS via your electron wrapper. Are there plans to also release a Linux version?

Would love to be able to use it to inspect my local databases on my Linux machine, indeed!

Yes, I will add Linux support to the roadmap!
Post reply on HN