9 ms·

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

83 points by gilad 6y ago

softinio 6y ago
Seems this keeps being posted every week. Guess it can be considered spam now?
- IAmEveryone 6y ago
  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 6y ago
  I wouldn't call it spam, but it does seem odd for a really immature product to keep hitting the front page.
  - Bootvis 6y 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 6y ago
  When this happens you can just comment with a link to the older submissions (which others have done) and email the mods.
saberworks 6y 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 6y ago
What I'd love is a tool I could paste horrible SQL into that would return it rewritten cleanly.
- effloresce 6y ago
  https://poorsql.com/ https://poorsql.com/
- monkeymonkey 6y ago
  Prettier has got a plug-in - https://github.com/benjie/prettier-plugin-pg https://github.com/benjie/prettier-plugin-pg And there’s also https://sqlfum.pt/ https://sqlfum.pt/
ar-jan 6y 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.
Hamuko 6y 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 6y 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.
  - Aeolun 6y 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.
  - mekster 6y ago
    Or TablePlus.
    - Hamuko 6y ago
      TablePlus is a paid, proprietary software. And not only that, it's licensed per device, not per user, one year at a time. So if you work on two computers, that's $120 per year.
      - mekster 6y ago
        I was responding to the parent about feature comparison.
cordaciu 6y ago
Looks good. They thing I missing is edit in place feature!
xellisx 6y 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 6y 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 https://news.ycombinator.com/item?id=23091384
- merricksb 6y ago
  Also a version update last week: https://news.ycombinator.com/item?id=23279299 https://news.ycombinator.com/item?id=23279299
ryukafalz 6y 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/master/yarn.lock https://github.com/beekeeper-studio/beekeeper-studio/blob/ma...
- Aeolun 6y 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.

83 points by gilad 6y ago

softinio 6y ago

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

IAmEveryone 6y ago
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 6y ago
I wouldn't call it spam, but it does seem odd for a really immature product to keep hitting the front page.
- Bootvis 6y 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 6y ago
When this happens you can just comment with a link to the older submissions (which others have done) and email the mods.

saberworks 6y 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 6y ago

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

effloresce 6y ago
https://poorsql.com/ https://poorsql.com/
monkeymonkey 6y ago
Prettier has got a plug-in - https://github.com/benjie/prettier-plugin-pg https://github.com/benjie/prettier-plugin-pg And there’s also https://sqlfum.pt/ https://sqlfum.pt/

ar-jan 6y 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.

Hamuko 6y 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 6y 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.
- Aeolun 6y 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.
- mekster 6y ago
  Or TablePlus.
  - Hamuko 6y ago
    TablePlus is a paid, proprietary software. And not only that, it's licensed per device, not per user, one year at a time. So if you work on two computers, that's $120 per year.
    - mekster 6y ago
      I was responding to the parent about feature comparison.

cordaciu 6y ago

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

xellisx 6y 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 6y 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 https://news.ycombinator.com/item?id=23091384

merricksb 6y ago
Also a version update last week: https://news.ycombinator.com/item?id=23279299 https://news.ycombinator.com/item?id=23279299

ryukafalz 6y 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/master/yarn.lock https://github.com/beekeeper-studio/beekeeper-studio/blob/ma...

Aeolun 6y 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.