Show HN: Simple but Powerful IDE for Databases • Hacker News Board

Re: Show HN: Simple but Powerful IDE for Databases

#81

Post by zepearl » Thu, Apr 18, 2019, 5:48 PM UTC

markuman wrote: post #16

I guess dbeaver is much better, more powerfull and open source IDE for databases.

I just needed a DB-client with which 1) I could have multiple SQLs in a single page/file (hope you know what I mean) and 2) execute single ones based on where the cursor is positioned, 3) without a delimiter at the end of each SQL, and 4) see as well execution plans (for some DBs e.g. MariaDB) and 5) to work with multiple databases (MariaDB, PostgreSQL, Clickhouse, DB2, MonetDB, Oracle, generic JDBC) and DBeaver totally saved me and I don't see any alternative (which I now anyway don't need).

I would pay for the "enterprise edition", but for a fixed amount not limited by usage but based on SW-versions (e.g. get upgrades for 1 year and after that to be able to keep using "the old version XYZ" until I have a reason to upgrade for which I would have to pay again). The 149$/year ( https://dbeaver.com/ at the bottom) sounds like it would stop working after 1y no matter which version I'm using :(

Re: Show HN: Simple but Powerful IDE for Databases

#82

Post by JetSpiegel » Thu, Apr 18, 2019, 5:49 PM UTC

russellbeattie wrote: post #74

arboghast wrote: post #64

Earlier quoted context omitted.

There's DBeaver Community

I'm pretty sure the GUI developers of DBeaver are blind sadists who want to punish all database admins for their sins. It would be considered 'cruel and unusual' in any U.S. court of law. It's not just ugly, it's a crime against humanity itself. Small animals within 10 yards of a computer inexplicably die any time the program is started. That said, it really is quite useful and usually the best tool to get db stuff d…

It's just a Eclipse skin, so this is accurate.

Re: Show HN: Simple but Powerful IDE for Databases

#83

Post by jjeaff » Thu, Apr 18, 2019, 5:50 PM UTC

thejohnconway wrote: post #78

CaptainHiggins wrote: post #23

Earlier quoted context omitted.

I think VS Code is the gold standard for Electron. Slack, not so much. On my work laptop, it uses 800mb over 5 processes, and is easily 5x slower to paste a screenshot into than Teams.

I wish VS Code wasn’t Electron. It’s noticeably laggier that native editors, and its performance under load is a lot worse.

I can detect no lag in my vscode. I do have a very powerful desktop.

Re: Show HN: Simple but Powerful IDE for Databases

#84

Post by newsoul2019 » Thu, Apr 18, 2019, 5:55 PM UTC

stephenr wrote: post #6

It's 2019 and not a single mention of which OS this runs on. I had to download it to find out it's for Windows. Might want to make a note of that somewhere.

Windows? Does anyone use that anymore?

Re: Show HN: Simple but Powerful IDE for Databases

#85

Post by swest » Thu, Apr 18, 2019, 6:00 PM UTC

AquaLineSpirit wrote: post #63

Phenix88be wrote: post #39

It's hard to find information on this marketing website. Here is a summary gathered from the comments : - It's for windows - It's not open source - They plan to build a cross-platform IDE using Electron I think we have solid alternative in the open source world and I don't really see how this product is better (This is based on the information provided by the website).

What is the open source alternative?

Azure Data Studio maybe? https://github.com/Microsoft/azuredatastudio

Re: Show HN: Simple but Powerful IDE for Databases

#86

Post by apeace » Thu, Apr 18, 2019, 6:01 PM UTC

lunchladydoris wrote: post #76

If you have IntelliJ IDEA Ultimate, try the Database plugin. It essentially turns IntelliJ into DataGrip (their dedicated database IDE).

I use Datagrip every day and SQLGate looks very similar.

Re: Show HN: Simple but Powerful IDE for Databases

#87

Post by TeMPOraL » Thu, Apr 18, 2019, 6:03 PM UTC

pknopf wrote: post #80

thejohnconway wrote: post #78

Earlier quoted context omitted.

I wish VS Code wasn’t Electron. It’s noticeably laggier that native editors, and its performance under load is a lot worse.

The question is, could any of the native editors keep the pace of new features/improvements?

Sure, why not? It's not like most of the features are strongly tied to VS Code being a browser app. Implemented against a different platform they'd probably look different. Maybe a bit less shiny, but likely a bit more performant.

Re: Show HN: Simple but Powerful IDE for Databases

#88

Post by btreecat » Thu, Apr 18, 2019, 6:18 PM UTC

AquaLineSpirit wrote: post #63

Phenix88be wrote: post #39

It's hard to find information on this marketing website. Here is a summary gathered from the comments : - It's for windows - It's not open source - They plan to build a cross-platform IDE using Electron I think we have solid alternative in the open source world and I don't really see how this product is better (This is based on the information provided by the website).

What is the open source alternative?

SquirrleSQL

Re: Show HN: Simple but Powerful IDE for Databases

#89

Post by natalyarostova » Thu, Apr 18, 2019, 6:23 PM UTC

....The entire video is in Japanese.

Re: Show HN: Simple but Powerful IDE for Databases

#90

Post by pknopf » Thu, Apr 18, 2019, 6:25 PM UTC

TeMPOraL wrote: post #87

pknopf wrote: post #80

Earlier quoted context omitted.

The question is, could any of the native editors keep the pace of new features/improvements?

Sure, why not? It's not like most of the features are strongly tied to VS Code being a browser app. Implemented against a different platform they'd probably look different. Maybe a bit less shiny, but likely a bit more performant.

> Sure, why not?

I was being facetious.

I'm not a fan of electron either, but when it comes to just HTML/CSS/JS, nothing beats it in developer productivity. The business logic is (of course) a sep discussion.

By the way, I have professional experience in HTML/JS/CSS/WPF/WinForms/Qt/Android/UIKit.