9 ms·

Beekeeper Studio SQL editor 4.0 – Import. backup, restore, and bigquery

91 points by rathboma 3y ago

code_biologist 3y ago
“The SQL Editor and Database Manager Of Your Dreams A [cross platform] modern, easy to use, and good looking SQL client for MySQL, Postgres, SQLite, SQL Server, and more.”
- ShadowBanThis01 3y ago
  Did you have anything to add to that?
  - code_biologist 3y ago
    It wasn't obvious to me what this software was when posted. The original HN title was "Beekeeper Studio 4.0 - Import. backup, restore, and bigquery" which implies it's a backup solution for bigquery. The HN title was edited to include "SQL editor" after my comment. Do you see anywhere in the linked release notes where it explains what Beekeeper Studio is? I discovered it's more than a SQL backup and restore solution and I figured others would want to know instead of making everyone click a bunch.
    - ShadowBanThis01 3y ago
      Ah, much appreciated. +1 for descriptive titles (which are far from a universal norm here)
    - rathboma 3y ago
      Oh, yeah sorry for the terrible title :-/.
- Semaphor 3y ago
  Anyone care to say what the pros & cons vs JetBrain’s DataGrip are?
  - mekster 3y ago
    DataGrip is heavy. It takes seconds to launch and while it must be quite feature complete, the interface is cluttered. Currently using TablePlus and while I have a few problems with it, it's snappy and mostly fine. Tried Beekeeper some years ago but might as well try again.
  - rathboma 3y ago
    Hey! I'm the creator of Beekeeper Studio. It's a similar value proposition as VSCode/Sublime Text vs IntelliJ. If you are in a database all day and need a big beefy IDE, Beekeeper Studio isn't for you. I built Beekeeper Studio because I wanted an easy to use and intuitive GUI. I'm not a DBA, so using DBeaver or DataGrip required me to basically re-learn the whole app every time I used it, which I didn't have the patience for. Hope that helps add some context :-)
  - slim 3y ago
    it's opensource https://github.com/beekeeper-studio/beekeeper-studio https://github.com/beekeeper-studio/beekeeper-studio
    - Semaphor 3y ago
      The community edition, which lacks some features.
    - OJFord 3y ago
      DBeaver has the same open source 'community' version model. Beekeeper seems like a less clunky, but also much less featureful alternative. I mean that in a good way really, I quite like the idea of 'slightly more than psql' (but not too much), as long as it's fast/lightweight.
  - SPBS 3y ago
    DataGrip isn't Electron
ShadowBanThis01 3y ago
I've been using this on Macs as my DB manager on a new project (MariaDB at the moment) and have been pretty happy with it. I use SQL Editor to do the design and to generate DB-creation scripts, and once the DB is up and running I maintain it with Beekeeper while I code in my IDEs.
- ShadowBanThis01 3y ago
  I love how someone downvoted this two days after the fact.
- rathboma 3y ago
  Thanks so much for using my app! <3
yesbut 3y ago
Does anyone know how this compares to DBeaver?
- bar8uyr 3y ago
  Less features, but that can be a good thing. Interface is nice, but its electron (but that's not really a bad thing).
- sccxy 3y ago
  Looks nicer but I guess not 7usd/month nicer if it is not your main tool.
  - rathboma 3y ago
    I have a 40% off sale right now, which means its $51 for a year, if you cancel right away you still get lifetime access and 1 year of software updates. I think that's a pretty fair price, but always happy to get more pricing feedback.
- skeptrune 3y ago
  Smoother to use and simpler, but it's missing features when it comes to running long queries where you want to break it up into several so it does not timeout.
skeptrune 3y ago
Our team has migrated from DBeaver to Beekeeper recently and it has been a pleasure. My major ask would be that it saves my connection by default.
- rathboma 3y ago
  Can you ping me to explain 'not saving your connection by default'? That sounds like a bug or a bad UX decision as it does save in recent connections, even if you don't explicitly save it. matthew [at] beekeeperstudio [dot] io
- mooncakes_ooohh 3y ago
  Migrated to Pop OS and one of the first suggestions for a DB manager in the Pop Shop was Beekeeper. I tested it out since I'd only used DBeaver before. Upon finding out it didn't save my connection by default, I instantly went back to DBeaver.
  - rathboma 3y ago
    It does! If it doesn't thats a bug, please file a ticket :-)
    - mooncakes_ooohh 3y ago
      I'll take a second look at it :) Thanks for pointing that out
scorxn 3y ago
I use the free “community” edition daily: https://github.com/beekeeper-studio/beekeeper-studio/releases/latest https://github.com/beekeeper-studio/beekeeper-studio/release...
reinhardt1053 3y ago
It looks a lot like Tableplus [1] Who copied whom? [1] https://tableplus.com/ https://tableplus.com/
- rathboma 3y ago
  They came first, I wouldn't say I copied them, but we both value good UX and app design. I actually copied an old Mac app called SequelPro, which I missed greatly when moving to PSQL and a Linux desktop OS :-). When I started building Beekeeper there were 0 open source DB apps with good UX, especially on Linux. So that's why it exists. I now have a paid version to support development as it has grown super quickly over the last 3 years.
- Nullabillity 3y ago
  See also: DBeaver, pgadmin, MySQL workbench, Navicat, MS Access, ... These graphical database clients mostly end up looking the same in the end.
  - mekster 3y ago
    Not sure how you can say they're similar. Simplicity and ease of use vary a lot between them.
  - rathboma 3y ago
    Please use DBeaver, MySQL Workbench, or Navicat side by side with Beekeeper Studio and I think you'll understand how my UX philosophy differs.
- ctippett 3y ago
  Since you mentioned it, I was always curious if the team behind TablePlus were/are connected to the team behind Postico [1]. The UIs for both (at least before Postico 2) are almost identical. [1] https://eggerapps.at/postico2/ https://eggerapps.at/postico2/
  - mekster 3y ago
    Yet I still don't think nothing beats the good old SequelPro's elegant interface. Somehow not really liking the fork.
ndom91 3y ago
Been using this for a year or so as my daily basic DB client. Really like it for what it is and can definitely recommend it for quick and simple DB operations. I put it in the same category as tableplus - its a nice simple db client when all you need to do is browse some data, edit a row or two, etc. The community edition of beekeeper, however, has less annoyances than tableplus's free version imo. For more advanced use-cases, it doesn't come close to dbeaver or tools like that, but it also isn't designed to imo. Looking forward to an (admittedly big and clunky) PR of mine to beekeeper potentially being merged that adds support for connecting to aws rds instances via iam (cli) :)
- simonbarker87 3y ago
  I’ve literally just started using TablePlus as I get it as part of SetApp so this is a really handy comparison. I was tempted to give this a try but sounds like I’m getting something very similar with TablePlus for money I’m already spending each month. BeeKeeper looks very nice from what I can see though so might still try it.
  - rathboma 3y ago
    I made Beekeeper Studio because the lack of a good SQL editor on Linux drove me crazy. TablePlus is great on MacOS, but when I started it didn't even have a Linux version. I have full feature parity across all OSes, which I'm pretty proud of as a one-man team (although I do have some AMAZING part time help)
- rathboma 3y ago
  Thank you for using my app :-).
taffit 3y ago
Biggest issues for me: Subscription based payments and (biggest issue) missing option to adjust the keyboard shortuts. So I have to adjust my workflow and muscle memory to the tool instead of the other way around. For the rest it is a very nice looking client with a good amount of features (for my use case) and hats off to the developers.
- rathboma 3y ago
  Thank you! Some sort of keyboard shortcut settings screen is my todo list. Honestly it's a total PITA because different libraries handle shortcuts in different places, so I've been putting it off. My focus after 4.0 is tidying up this type of stuff :-).
- garganzol 3y ago
  Almost all Electron-based software has a guilt of shortcuts. By either not having them at all, or by using the scheme alien to a particular OS. Obsidian is my personal pit peeve - it still has a spotty support of F2 (rename) shortcut on Windows. Previously, it hadn't it at all.
- kamranjon 3y ago
  In case the developers are watching, I love beekeeper and use the free version daily. If you sold a one-time license, even if it was just for the current major version, I’d gladly pay $100 for that.
  - rathboma 3y ago
    Hey! Well I do, sort of. It's a subscription, but if you buy it for one year, then cancel you get to use the app forever. The downside is you only get 1 year of software updates, but that's the case with most 1 year purchases.
deleted 3y ago
[deleted]

91 points by rathboma 3y ago

“The SQL Editor and Database Manager Of Your Dreams A [cross platform] modern, easy to use, and good looking SQL client for MySQL, Postgres, SQLite, SQL Server, and more.”

ShadowBanThis01 3y ago
Did you have anything to add to that?
- code_biologist 3y ago
  It wasn't obvious to me what this software was when posted. The original HN title was "Beekeeper Studio 4.0 - Import. backup, restore, and bigquery" which implies it's a backup solution for bigquery. The HN title was edited to include "SQL editor" after my comment. Do you see anywhere in the linked release notes where it explains what Beekeeper Studio is? I discovered it's more than a SQL backup and restore solution and I figured others would want to know instead of making everyone click a bunch.
  - ShadowBanThis01 3y ago
    Ah, much appreciated. +1 for descriptive titles (which are far from a universal norm here)
  - rathboma 3y ago
    Oh, yeah sorry for the terrible title :-/.
Semaphor 3y ago
Anyone care to say what the pros & cons vs JetBrain’s DataGrip are?
- mekster 3y ago
  DataGrip is heavy. It takes seconds to launch and while it must be quite feature complete, the interface is cluttered. Currently using TablePlus and while I have a few problems with it, it's snappy and mostly fine. Tried Beekeeper some years ago but might as well try again.
- rathboma 3y ago
  Hey! I'm the creator of Beekeeper Studio. It's a similar value proposition as VSCode/Sublime Text vs IntelliJ. If you are in a database all day and need a big beefy IDE, Beekeeper Studio isn't for you. I built Beekeeper Studio because I wanted an easy to use and intuitive GUI. I'm not a DBA, so using DBeaver or DataGrip required me to basically re-learn the whole app every time I used it, which I didn't have the patience for. Hope that helps add some context :-)
- slim 3y ago
  it's opensource https://github.com/beekeeper-studio/beekeeper-studio https://github.com/beekeeper-studio/beekeeper-studio
  - Semaphor 3y ago
    The community edition, which lacks some features.
  - OJFord 3y ago
    DBeaver has the same open source 'community' version model. Beekeeper seems like a less clunky, but also much less featureful alternative. I mean that in a good way really, I quite like the idea of 'slightly more than psql' (but not too much), as long as it's fast/lightweight.
- SPBS 3y ago
  DataGrip isn't Electron

ShadowBanThis01 3y ago

I've been using this on Macs as my DB manager on a new project (MariaDB at the moment) and have been pretty happy with it. I use SQL Editor to do the design and to generate DB-creation scripts, and once the DB is up and running I maintain it with Beekeeper while I code in my IDEs.

ShadowBanThis01 3y ago
I love how someone downvoted this two days after the fact.
rathboma 3y ago
Thanks so much for using my app! <3

yesbut 3y ago

Does anyone know how this compares to DBeaver?

bar8uyr 3y ago
Less features, but that can be a good thing. Interface is nice, but its electron (but that's not really a bad thing).
sccxy 3y ago
Looks nicer but I guess not 7usd/month nicer if it is not your main tool.
- rathboma 3y ago
  I have a 40% off sale right now, which means its $51 for a year, if you cancel right away you still get lifetime access and 1 year of software updates. I think that's a pretty fair price, but always happy to get more pricing feedback.
skeptrune 3y ago
Smoother to use and simpler, but it's missing features when it comes to running long queries where you want to break it up into several so it does not timeout.

skeptrune 3y ago

Our team has migrated from DBeaver to Beekeeper recently and it has been a pleasure. My major ask would be that it saves my connection by default.

rathboma 3y ago
Can you ping me to explain 'not saving your connection by default'? That sounds like a bug or a bad UX decision as it does save in recent connections, even if you don't explicitly save it. matthew [at] beekeeperstudio [dot] io
mooncakes_ooohh 3y ago
Migrated to Pop OS and one of the first suggestions for a DB manager in the Pop Shop was Beekeeper. I tested it out since I'd only used DBeaver before. Upon finding out it didn't save my connection by default, I instantly went back to DBeaver.
- rathboma 3y ago
  It does! If it doesn't thats a bug, please file a ticket :-)
  - mooncakes_ooohh 3y ago
    I'll take a second look at it :) Thanks for pointing that out

scorxn 3y ago

I use the free “community” edition daily: https://github.com/beekeeper-studio/beekeeper-studio/releases/latest https://github.com/beekeeper-studio/beekeeper-studio/release...

reinhardt1053 3y ago

It looks a lot like Tableplus [1] Who copied whom? [1] https://tableplus.com/ https://tableplus.com/

rathboma 3y ago
They came first, I wouldn't say I copied them, but we both value good UX and app design. I actually copied an old Mac app called SequelPro, which I missed greatly when moving to PSQL and a Linux desktop OS :-). When I started building Beekeeper there were 0 open source DB apps with good UX, especially on Linux. So that's why it exists. I now have a paid version to support development as it has grown super quickly over the last 3 years.
Nullabillity 3y ago
See also: DBeaver, pgadmin, MySQL workbench, Navicat, MS Access, ... These graphical database clients mostly end up looking the same in the end.
- mekster 3y ago
  Not sure how you can say they're similar. Simplicity and ease of use vary a lot between them.
- rathboma 3y ago
  Please use DBeaver, MySQL Workbench, or Navicat side by side with Beekeeper Studio and I think you'll understand how my UX philosophy differs.
ctippett 3y ago
Since you mentioned it, I was always curious if the team behind TablePlus were/are connected to the team behind Postico [1]. The UIs for both (at least before Postico 2) are almost identical. [1] https://eggerapps.at/postico2/ https://eggerapps.at/postico2/
- mekster 3y ago
  Yet I still don't think nothing beats the good old SequelPro's elegant interface. Somehow not really liking the fork.

ndom91 3y ago

Been using this for a year or so as my daily basic DB client. Really like it for what it is and can definitely recommend it for quick and simple DB operations. I put it in the same category as tableplus - its a nice simple db client when all you need to do is browse some data, edit a row or two, etc. The community edition of beekeeper, however, has less annoyances than tableplus's free version imo. For more advanced use-cases, it doesn't come close to dbeaver or tools like that, but it also isn't designed to imo. Looking forward to an (admittedly big and clunky) PR of mine to beekeeper potentially being merged that adds support for connecting to aws rds instances via iam (cli) :)

simonbarker87 3y ago
I’ve literally just started using TablePlus as I get it as part of SetApp so this is a really handy comparison. I was tempted to give this a try but sounds like I’m getting something very similar with TablePlus for money I’m already spending each month. BeeKeeper looks very nice from what I can see though so might still try it.
- rathboma 3y ago
  I made Beekeeper Studio because the lack of a good SQL editor on Linux drove me crazy. TablePlus is great on MacOS, but when I started it didn't even have a Linux version. I have full feature parity across all OSes, which I'm pretty proud of as a one-man team (although I do have some AMAZING part time help)
rathboma 3y ago
Thank you for using my app :-).

taffit 3y ago

Biggest issues for me: Subscription based payments and (biggest issue) missing option to adjust the keyboard shortuts. So I have to adjust my workflow and muscle memory to the tool instead of the other way around. For the rest it is a very nice looking client with a good amount of features (for my use case) and hats off to the developers.

rathboma 3y ago
Thank you! Some sort of keyboard shortcut settings screen is my todo list. Honestly it's a total PITA because different libraries handle shortcuts in different places, so I've been putting it off. My focus after 4.0 is tidying up this type of stuff :-).
garganzol 3y ago
Almost all Electron-based software has a guilt of shortcuts. By either not having them at all, or by using the scheme alien to a particular OS. Obsidian is my personal pit peeve - it still has a spotty support of F2 (rename) shortcut on Windows. Previously, it hadn't it at all.
kamranjon 3y ago
In case the developers are watching, I love beekeeper and use the free version daily. If you sold a one-time license, even if it was just for the current major version, I’d gladly pay $100 for that.
- rathboma 3y ago
  Hey! Well I do, sort of. It's a subscription, but if you buy it for one year, then cancel you get to use the app forever. The downside is you only get 1 year of software updates, but that's the case with most 1 year purchases.

deleted 3y ago

[deleted]