Hacker News Reader

Comment by sagarjs | Hacker News Reader

I’m honestly really blown away by this. Are there other such tools out there that do a similar thing?

https://dbeaver.io/ is an open source tool with community and commercial builds that's quite mature and capable. I don't like SQL or database administration very much so it's become my go-to utility if I need to look at an unfamiliar DB. I've never had any problems with it though I keep a copy of SQL workbench around as it seems to perform better on large projects.

dBeaver is awesome and the best thing its free and open source. There is enterprise version tat includes NoSQL databases and some other stuff.

It also has vertical row view (swith by using TAB) that is great help when when you have lots of columns.

If they ever add option to join columns like this app, it could pretty much replace it.

Metabase is another one.

This is the most interesting thing related to databases I've seen in years.

I agree. This is better than DataGrip that my employer gives me.

https://github.com/dbgate/dbgate is an open source SQL IDE that automatically join data from other tables through a similar interface

From the screenshots, the interface doesn't look similar at all. Thanks for pointing out dbgate though, I am downloading it. ;-)

I really like Ultorg's grasp of how to display 3-dimensional+ data. That form generator shown in the video was really smart too.

I've been writing SQL for so long it's second nature. I have tried these GUI tools from time to time but for me, nothing beats just writing SQL in a text-mode window. I use emacs and whichever sql mode is appropriate for the database I'm working with.

If I don't understand the data model well enough to know how to write joins to get what I need, I have never found that a GUI helps me very much.

I think one big advantage of GUIs is safety. There's no shortage of people who accidentally typed a bad command in production.

GUIs usually don't let you operate on anything you can't see, so it's harder to do the wrong thing by selecting something without looking at it.

Like with dd, you can type /dev/sdWrongDrive and never see anything about the device. With a GUI you will click a button that says "Root Device: 67GB free of 128GB" and instantly see it is not your blank SD card.

I have not seen a GUI tool of this sort that is substantially safer than a command line tool. If you're letting users do things like deleting or altering production data with any kind of ad-hoc tool, you've got a bigger issue than what the specific tool is.

Judging by meme threads, and comments on them, it seems like unfortunately nobody got the memo that it's a bad idea.

The usual issues are things like a select without a WHERE, least with a GUI, the tool can ideally do a select before any modifications happen, and say "You're about to affect 39482 rows out of 39482 total".

I suppose you could do things like parsing the SQL, figuring out the intent, and generating the select call, and throwing an error if it can't pre-check things on the CLI, but GUIs also have a speed bump effect that keeps the confident power user types from moving faster than their heads, and different expectations.

People seem to expect command line tools not to have layers and layers of confirmations and hoops to jump through, and the people who want this stuff probably prefer a GUI.

Not a tool but Django admin has also a similar concept. You define the models as Python classes and it provides an abstract CRUD user interface. It also supports one-to-one or one-to-many joins, so you don't have to generate or write a CRUD app from scratch.

Sigma is a BI system with a visual manipulation interface for query construction (Workbook) that has similarities with Ultorg.

https://www.sigmacomputing.com/

Datastation is sorta similar but in my brief experience the description is more aspirational at this stage.

https://datastation.multiprocess.io/

Hey thanks for the shoutout and trying it out!

It is indeed early stages (I started it not yet a year ago).

I'd love to hear any feedback you've got.

In general every release gets more stable, more automated tests, better performance, etc.

Per some of the other answers, you might want to check out this discussion from last year:

Ask HN: Best low-/no-code solution for simple web-based database frontends

https://news.ycombinator.com/item?id=26657803

(208 points on April 1, 2021 | 142 comments)

Yes, tableau

Access, Salesforce

LINQPad

Reply on news.ycombinator.com