Live data from Hacker News

Show HN: Beekeeper Studio – open-source, cross-platform SQL client

beekeeperstudio.io

51–60 of 135 posts

Re: Show HN: Beekeeper Studio – open-source, cross-platform SQL client

#57
post #2

Hey folks, This is a passion project from myself and a friend. Been looking for a slick and easy to use SQL client on Linux for a while (I wanted basically Sequel Pro, on Linux, for PSQL). Couldn't find what I wanted, so we made one ourselves. It's built on Electron using Vue.js - I know HN opinions on electron apps, but I've been surprised on how snappy the app is. It's fully open source (MIT), cross-platform (Linux…

I have a couple of feature requests that nothing else seems to be able to do:

1. Parameterised queries (ideally with an ability to customise the syntax for the placeholders - we use :param for named parameters). All of our production queries are parameterised, and it would be awesome to be able to copy and paste them into this kind of tool, and run them unmodified. Especially as they sometimes use the same parameter in multiple places, so updating them.

2. A full editor control (e.g. Code Mirror, Monaco, or Ace) for editing SQL queries. Specifically I really want multiple cursors for editing queries quickly and efficiently.

Re: Show HN: Beekeeper Studio – open-source, cross-platform SQL client

#58
post #17
post #16

I got pretty excited about trying this out, since I've been using a no longer maintained (and pretty buggy) app called Sequel Pro. But, Beekeeper kind of seems slow/clunky? I ran a simple query in our prod DB that returned 906 rows x 60 columns – the app completely froze up and I couldn't even scroll down to the next few rows...

Switch to Sequel Pro nightly build. You can install it with homebrew. It’s very stable despite the nightly moniker. I haven’t had a single issue with it and it resolved several issues I was having with the regular release.

The nightlies have a lot of UI bugs, Filtering options disappear randomly, the left column is kinda weird etc.

But still with all those UI bugs I prefer it over any other client.

Re: Show HN: Beekeeper Studio – open-source, cross-platform SQL client

#60
Nice, congrats on the launch.

One thing I've been wanting for a while is a pluggable database client. I find being able to "see" a database helps me understand structure and concepts more.

With FoundationDB one of the things that I've really struggled with is visualising the layers of the schema. I doubt there's a market for a FoundationDB GUI client, but being able to write a plugin for an existing client (I don't have good GUI skills) would be a great option.

Post reply on HN