Live data from Hacker News

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

beekeeperstudio.io

81–90 of 135 posts

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

#81
post #42
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…

I would also recommend DBeaver[1]. Cross-platform with really nice features. [1] https://dbeaver.io/

I've used DBeaver in the past, but still felt compelled to make Beekeeper Studio. DBeaver is great for a DBA, but can you imagine giving it to someone learning SQL for the first time?

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

#82

Looks cool. I haven't taken an in-depth look yet, but what I noticed is that when I press CMD+W it closes the whole window, rather than the tab I am in. This will land me in some trouble if I ever decide to use it as my main tool.

Yes that is a problem. The app should be capturing that event to close tabs, but MacOS takes it over for some reason. I'll be doing keyboard shortcuts differently soon, so that will be fixed.

Can you file an issue so I don't forget?

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

#84

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.

Oh you just caught me trying to encourage community involvement :-). I don't just want users, I want contributors! At a minimum some issue engagement is very useful.

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

#85

I couldn't find any way to change schema in Postgres, and it seems like it only lists tables in the public schema by default. That does unfortunately break it entirely if you use schemas at all.

Yep. This was a compromise I made in order to launch (it took us a year to build it part time even then). Coming soon I promise!

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

#86
post #56

Looks nice! Running on Ubuntu 18.04. I see a lot of promise, but I've found 2 big issues right away: 1. I can't see how to manually edit data in the tables 2. The pagination (bottom right) doesn't work at all

1. We'll be working on this soon.

2. This should work just fine -- what db are you using? Can you file an issue with db information?

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

#87
post #38

Kudos for the effort, however for SQL server it faces the same issues as most other clients. connecting using an domain\user and password doesn't work which means i can't jump ship. Is there a reason it works flawlessly on datagrip and other tools like sqlprostudio but apps like tableplus and beekepper can't?

We'll get there with it. It requires some specific AD code to implement it. I just haven't had time to do it yet.

These were compromises I needed in order to ship it (it already took us a year to build).

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

#88

Nice. Excited to try it out. Been using Postico for a while and having to hit a keybind for auto complete suggestions has been a drag.

Got a chance to play with it. * Look into your JSON/JSONB column support. Right now it just returns [object Object]. * I dig the tab interface. * I REALLY like the summary view when you expand the table on the left. * Select auto complete wasn't working very well for me even with the table defined and ctrl+space was offering completely problemsome options. Excited to keep playing with it. Going to test it as a daily…

Thanks!

Yeah JSON / JSONB support coming soon (tm).

Auto-complete is a pet peeve. I'm using code-mirror for the editor and it has limitations. Can you screenshot what was not auto-completing?

I find it helps if I first define a table, then the selects auto-complete well:

select foo.

from foo

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

#89
post #39

Looks like some nice, I'm a frequent Tableplus user, so nice to have a sleek multiplatform alternative. Quick Suggestions: * Snowflake, Bigquery, Azure support * A SQL linter (not easy!) Thanks for sharing!

- Yes yes yes, coming soon I hope :-) - For sure, on the radar, wanna help make one? :-P

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

#90

Only the obnoxious "dark theme" -> removed

It would be friendlier to phrase this as a suggestion: > Looks promising! Have you thought about supporting a light theme as well? I generally don't like dark themes

We have a light theme, but no settings menu :-). So that is coming soon
Post reply on HN