Beekeeper Studio is a free and open source SQL editor and database manager

https://github.com/beekeeper-studio/beekeeper-studio

by gilad • 6 years ago

83 22 6 years ago

softinio• 6 years ago

Seems this keeps being posted every week. Guess it can be considered spam now?

The submitter doesn't seem to be in any way connected to the project, so this seems to just organically be interesting and still new for enough people––I hadn't seen the earlier posts, for example, and I check HN quite obsessively.

Also: "assume good faith..."

devin• 6 years ago

I wouldn't call it spam, but it does seem odd for a really immature product to keep hitting the front page.

Bootvis• 6 years ago

I think it indicates demand for a good open source SQL editor. (I myself am reasonably happy with DBeaver which also has a paid version I believe)

tomhoward• 6 years ago

When this happens you can just comment with a link to the older submissions (which others have done) and email the mods.

saberworks• 6 years ago

Filed minor bug report about tiny/disappearing scroll bars last time this showed up here. Authors took it seriously and pushed a change very quickly. Thanks!

stormdennis• 6 years ago

What I'd love is a tool I could paste horrible SQL into that would return it rewritten cleanly.

effloresce• 6 years ago

https://poorsql.com/

monkeymonkey• 6 years ago

Prettier has got a plug-in - https://github.com/benjie/prettier-plugin-pg

And there’s also https://sqlfum.pt/

ar-jan• 6 years ago

Looks nice. Does it support update and insert operations on views (using INSTEAD OF triggers)? That's a feature that led me to DBeaver, which I'm liking a lot.

Hamuko2• 6 years ago

I like the idea, but the execution seems rather bad. If I try to connect to my Postgres server, it can't find a single table in any database, even though I know there are tables and I know that other clients can fetch them. It also seems to say "undefined rows affected" on all SELECTs.

tgv• 6 years ago

Can confirm (macOS).

I'm not sure if I like the idea. What does it offer that DBeaver doesn't? DBeaver's auto-complete is a bit eager, and it looks like the Java application that it is, but it works, and the features Beekeeper touts are provided by DBeaver with the same ease. But DBeaver does seem to offer a lot more.

Aeolun2• 6 years ago

DBeaver looks and feels like something that was cobbled together over the past 15 years. I just cannot make myself use it without constantly feeling icky.

mekster2• 6 years ago

Or TablePlus.

cordaciu• 6 years ago

Looks good. They thing I missing is edit in place feature!

xellisx• 6 years ago

I looked at this the other day, and put in a feature request.

I have a personal copy of SQLYog ultimate, which for the most part I love. Of course I want something (open source) has a similar UX with quickly accessing rows, and being able to switch between query results and table row view. And being able to do import and exports with options. This would be to help people at work. The OSS and free packages out there are not very friendly IMHO.

sam_goody• 6 years ago

Beekeeper Studio made it to the top of HN a few weeks ago - here is the thread (still relevant):

https://news.ycombinator.com/item?id=23091384

merricksb• 6 years ago

Also a version update last week:

https://news.ycombinator.com/item?id=23279299

ryukafalz• 6 years ago

Here's the thing that bugs me about the JavaScript ecosystem. This is a database manager, so it's presumably going to be connecting to pretty sensitive systems, with pretty sensitive credentials. Do you think the developers have audited all of these dependencies? Do you think they can have possibly audited all of these dependencies?

https://github.com/beekeeper-studio/beekeeper-studio/blob/ma...

Aeolun2• 6 years ago

I’m not sure if that’s really relevant. I’m building those sensitive systems with Javascript, and just trust Snyk to notify me if anything untowards happens.

It is literally impossible to audit all these libraries. But that’s the case for almost all languages with a package manager.

Beekeeper Studio is a free and open source SQL editor and database manager

Related Stories