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

111–120 of 135 posts

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

#111

Post by joshstrange »

absove wrote: post #68
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…

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.

DataGrip does support multiple cursors, I've never done the parameterized queries but I will have to look into that. Buying the entire Jetbrains suite was one of the best decisions I made when I switched jobs and lost my old license. IDEA/Datagrip save me so much time, when I worked it out I couldn't pay for them fast enough.

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

#112

Post by joshstrange »

sam_goody wrote: post #108

For anyone chancing on this thread, here's my recap. Note that I have little experience with these, so am trying to summarize, not give my own verdict. Competition: - DataGrip (~$150/yr, Clunky, Powerful) - TablePlus ($50, Pretty, Useful) - DBeaver (Free version, Clunky, Powerful) - SQuirrel (Free, Clunky, Usable) - Heidi (Free, Clunky, Usable) - Postico ($40, Pretty, Mac + Postgres only) - http://sequeljoe.ohwg.net…

- DataGrip - $89 first year, $71 second year, $53/year after that - Worth every penny for me and if you stop paying you get the last version

- TablePlus - $59 and it is $59/year. You can pay once but to keep getting updates you have to keep paying like with DataGrip

- DBeaver - Ugly but I agree, it's powerful

- SQuirrel/Heidi/Postico/SequelJoe/Azure - Never used

- Sequel Pro - God I loved this software and hung on to it way longer than I should have through the crashes and lack of updates (I would have paid in a heartbeat for it). Too bad it was MySQL-only

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

#113

Post by shock »

dunefox wrote: post #110
jmngomes wrote: post #47

Earlier quoted context omitted.

DBeaver is great as a mature cross platform sql editor, and packs a lot of db design and management tools: https://dbeaver.io

I used it for a bit and I find it lacks in the text editing capabilities.

Your comment would have been useful if you elaborated on what text editing capabilities DBeaver is currently lacking.

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

#114

Post by shock »

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.

If most users had your attitude we would have far fewer open source/free softwares. The author has already spent a significant amount of time making the tool, criticizing him for not spending more time/energy for something that can easily be done by the reporter seems, well, counter-productive.

In most cases, feedback is not worth much, depending on your goal. E.g.: I've made some software that satisfies my requirements. Should I be grateful for feedback that, in essence, requires more free work from me? What's the thinking here?

For these reasons I consider the author's attitude most appropriate, considering he could have said "the software is free, send a patch", or just "works for me, take a walk – I don't owe you anything".

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

#115

Post by oh-4-fucks-sake »

sam_goody wrote: post #108

For anyone chancing on this thread, here's my recap. Note that I have little experience with these, so am trying to summarize, not give my own verdict. Competition: - DataGrip (~$150/yr, Clunky, Powerful) - TablePlus ($50, Pretty, Useful) - DBeaver (Free version, Clunky, Powerful) - SQuirrel (Free, Clunky, Usable) - Heidi (Free, Clunky, Usable) - Postico ($40, Pretty, Mac + Postgres only) - http://sequeljoe.ohwg.net…

Let me throw in Popsql (free for 2 saved DB connections, $12/mo for unlimited). I've used a handful of the above but Popsql has become my darling if only because the UI has a productive and inviting feel at a reasonable cost. It's obviously on the expensive side compared to OSS and one-time-licensing-fee products but when I'm firing off dozens of queries per day, it's worth it. As a bonus, their site offers live chat support directly with the engineers so the handful of times I've had some small issues, they've been super helpful.

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

#116

Post by dunefox »

shock wrote: post #113
dunefox wrote: post #110

Earlier quoted context omitted.

I used it for a bit and I find it lacks in the text editing capabilities.

Your comment would have been useful if you elaborated on what text editing capabilities DBeaver is currently lacking.

Multiple cursors, jumping around in the text without the mouse, etc.

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

#117

Post by nkkollaw »

rathboma wrote: post #92
nkkollaw wrote: post #46

Looks great. Sequel Pro you mentioned is by far the best on Mac, none of the clients on Windows or Linux I tried even come close. This is great, and badly needed IMHO—specially if one can use a single app for both MySQL and SQL Server (Beaver DB is a usability nightmare). The name will put off a lot of people. To be honest, if someone in a team said "we should replace all our SQL clients with Beekeeper!" the first re…

Thanks! There's a history to the name, but I agree there are negatives. The positive is that it is distinct and can hopefully provide its own identity. Businesses use all sorts of software with silly names!

Sure, they do use them, but as a startup I'd personally think it's better to not making harder than it already is.

What's the story behind the name..? :-)

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

#118

Post by manzu »

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.

Rider comes with DB tools on par with DataGrip included. Same for PHPStorm. The exception si WebStorm and maybe other smaller ones

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

#120

Post by [deleted] »

capableweb wrote: post #102
mbesto wrote: post #93

Earlier quoted context omitted.

It seems weird that someone who has spent a lot of their own time (e.g. money) to help a community is being shunned for not taking even more time out of their day for a simple request. This also disregards software ticket guidelines 101: - There isn't fully defined steps to reproduce - Limited details on what the user expected to see - No details about the users environment People pour their souls into FOSS projects…

Well, "shunned" might be a bit too strong, but I don't speak native English. I certainly didn't mean to put down the author in any way, which is why I prefixed it with "Not that it's a big thing", it's just a helpful note regarding how to respond to feedback. Let's cool it down with trying to start up some heated argument around this, no one is interested in that.

[deleted]
Post reply on HN