Show HN: Beekeeper Studio – open-source, cross-platform SQL client • Hacker News Board

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

#71

Post by isuckatcoding » Thu, May 07, 2020, 11:59 AM UTC

zenexer wrote: post #41

Very cool! I’ve been looking for a decent cross-platform SQL client for a while, so I can’t wait to try this out tomorrow. In case anyone is curious, here’s what I’ve tried so far: - DataGrip: bulky, slow, bugs never get fixed, non-FOSS - Azure Data Studio: great interface, but no MySQL or SQLite support - phpMyAdmin: clumsy, lacking in features, requires a web server—I’m really not the target demographic for this on…

So basically Datagrip?

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

#72

Post by peteforde » Thu, May 07, 2020, 12:01 PM UTC

peteforde wrote: post #50

I can't be the only person who was disappointed that this isn't Trello for Beekeepers.

I'm actually really interested in beekeeping, but thanks for the encouragement.

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

#73

Post by capableweb » Thu, May 07, 2020, 12:06 PM UTC

rathboma wrote: post #25

arkits wrote: post #15

This is pretty cool! Better SQL clients are always welcome. I tried with Postgres 12 and ran into 2 issues - - jsonb columns don't seem to render properly... just get a "[object Object]". - One specific table refused to get list anything, and there was a red "Error" in the center of the listing UI.

Good catches! Can you file a GitHub issue so I don't forget?

Not that it's a big thing, but seems weird to put the responsibility about you not forgetting something, on the person leaving the feedback, rather than just filing the issue yourself.

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

#74

Post by hugofloss » Thu, May 07, 2020, 12:14 PM UTC

This is cool! Bug: I run Postgres locally that works without a username and password. Trying to connect to the database results in the error that I didn't provide a username. Can you remove the validation?

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

#75

Post by agustif » Thu, May 07, 2020, 12:15 PM UTC

markdown wrote: post #53

And here I am working on a Beekeeping app that I was going to call that. I guess I'll call it SQL Studio instead.

Hive.app is taken too?

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

#76

Post by fullstackchris » Thu, May 07, 2020, 12:15 PM UTC

dewey wrote: post #66

nicoburns wrote: post #57

Earlier quoted context omitted.

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…

Just in case you are not aware of it, DataGrip can do all these things: https://www.jetbrains.com/datagrip/

hopping on the train here - does anyone know an editor that can do editing of postgres enums? (i know you can't 'edit' an enum in postgres, but i would love a GUI that would 'allow' this. (i.e. in the background DROP CASCADE the enum, create a new one with the same name and new value, as well as restoring to previous dependencies that the old enum had)

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

#77

Post by BitterAmethyst » Thu, May 07, 2020, 12:23 PM UTC

Looks slick, does it support the SQLCipher variants of Sqlite?

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

#78

Post by abc03 » Thu, May 07, 2020, 12:25 PM UTC

capableweb wrote: post #73

rathboma wrote: post #25

Earlier quoted context omitted.

Good catches! Can you file a GitHub issue so I don't forget?

Not that it's a big thing, but seems weird to put the responsibility about you not forgetting something, on the person leaving the feedback, rather than just filing the issue yourself.

Well, it's open source, so he volunteers his time. Maybe the feedback should have been filled to Github in the first place? Certainly he is not lazy if asking to do a favor but probably busy with something else.

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

#79

Post by rathboma » Thu, May 07, 2020, 12:39 PM UTC

davedx wrote: post #69

dewey wrote: post #66

Earlier quoted context omitted.

Just in case you are not aware of it, DataGrip can do all these things: https://www.jetbrains.com/datagrip/

I use Rider daily and pay for it, but I found the price tag for DataGrip to be pretty steep considering what I typically use a SQL client for (running ad hoc queries mostly). The competition is not great on MacOS either so I've been using Azure Data Studio and dbBeaver mostly and not really happy with this state of affairs either. Excited to see a fresh new attempt in this space.

I like a lot of the paid tools, but I just feel like open databases deserve open tools. DBeaver is great for DBAs.

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

#80

Post by rathboma » Thu, May 07, 2020, 12:40 PM UTC

arjunbajaj wrote: post #35

rathboma wrote: post #23

Earlier quoted context omitted.

Hoping to! It's built with electron-builder and there's no plugin for aur yet, so will have to manually figure it out. I'm very pro Linux.

I tried out your app, and it's awesome! Simple and solves my need. Can you add a setting to zoom?

Working on it!