Beekeeper Studio SQL editor 4.0 – Import. backup, restore, and bigquery | Hacker News Reader

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

beekeeperstudio.io

91 pointsrathboma45 comments

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

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) :)

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.

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)

Thank you for using my app :-).

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.

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.

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.

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.

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 :-).

“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.”

Did you have anything to add to that?

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.

Ah, much appreciated.

+1 for descriptive titles (which are far from a universal norm here)

Oh, yeah sorry for the terrible title :-/.

Anyone care to say what the pros & cons vs JetBrain’s DataGrip are?

it's opensource https://github.com/beekeeper-studio/beekeeper-studio

The community edition, which lacks some features.

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.

DataGrip isn't Electron

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.

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 :-)

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.

I love how someone downvoted this two days after the fact.

Thanks so much for using my app! <3

It looks a lot like Tableplus [1] Who copied whom?

[1] https://tableplus.com/

See also: DBeaver, pgadmin, MySQL workbench, Navicat, MS Access, ...

These graphical database clients mostly end up looking the same in the end.

Not sure how you can say they're similar.

Simplicity and ease of use vary a lot between them.

Please use DBeaver, MySQL Workbench, or Navicat side by side with Beekeeper Studio and I think you'll understand how my UX philosophy differs.

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/

As someone who uses both of them (One for Scylla, one for PG) on a daily basis...I don't think they look "almost identical" at all.

It'd been several years, but taking another look now I can spot the differences.

I suppose the tooling for databases (or the expectation from users) means they all end up sharing a similar UI and where and how various features are implemented. Not too unlike word processors or spreadsheet software!

Yet I still don't think nothing beats the good old SequelPro's elegant interface.

Somehow not really liking the fork.

YES! That's why I built Beekeeper Studio. Still have fond feelings for that app, especially the pancakes logo.

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.

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.

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.

It does! If it doesn't thats a bug, please file a ticket :-)

I'll take a second look at it :) Thanks for pointing that out

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

Does anyone know how this compares to DBeaver?

Looks nicer but I guess not 7usd/month nicer if it is not your main tool.

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.

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.

Less features, but that can be a good thing. Interface is nice, but its electron (but that's not really a bad thing).

Reply on news.ycombinator.com