Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

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

beekeeperstudio.io

Post reply on HN
Print view View original

61–70 of 135 posts

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

#61

Post by Lapland »

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…

TablePlus is my favorite one after trying most of those https://tableplus.com/

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

#63

Post by Lapland »

CaveTech wrote: post #5

Nice work! I primarily use TablePlus, but it's lack of support for saved queries is a big downside, this could be great for that use case. A couple of UX things I've noticed, do with them what you will ;) - When clicking on a table, the more common expectation for me is for it to open that table in a new tab, or switch to an open tab already using that table. The dropdown with columns is nice, but feels secondary. -…

It has a "favorite" feature which I assume is similar to what you're looking for? It's super intuitive imo but does the job

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

#66

Post by dewey »

nicoburns wrote: post #57
rathboma wrote: 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…

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

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

#68

Post by absove »

nicoburns wrote: post #57
rathboma wrote: 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…

As far as I can tell IntelliJ Ultimate (and therefore most likely DataGrip too) supports both. For parameterized queries you get a prompt that let you fill in values for each parameter when executing them. They're commercial products though.

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

#69

Post by davedx »

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/

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.

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

#70

Post by davedx »

Looks nice and I've been looking for a client that works with SQL Server and Postgres for a while now. Giving it a try for sure.

Feedback:

1) When I first setup a connection and save it, the modal stays there, should probably be dismissed at that point

2) It wasn't clear how to connect, so I double clicked which worked. Maybe an explicit 'connect' button next to each connection would be nice.

3) I really like how after connecting I'm straightaway in an ad hoc query window (a frustration with dbBeaver). It would be awesome if the MacOS version had TouchBar support at least for running (the currently selected) query - Azure Data Studio has this and I use it all the time. (Probably windows should use equivalent F-key here).

4) I think the default date formatting should more closely reflect the column type - so a datetime column should display in an ISO format, not human readable.

5) I like how Azure Data Studio displays nulls explicitly in the results (italicised "NULL"). This lets you easily distinguish between an empty string in your data and a null value.

6) I really like how it's just one click to expand a table to see its types, but I miss the other table metadata here (foreign keys, indices, etc).

7) I like how it's dark mode by default. :)

Awesome job so far, will continue to use it. If it's interesting I would pay for this product (though less than DataGrip which I consider overpriced).

Post reply on HN