5 ms·

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

by sagarjs 4y ago

kostko 4y ago
Yes, tableau
qwertox 4y ago
This is the most interesting thing related to databases I've seen in years.
- abirch 4y ago
  I agree. This is better than DataGrip that my employer gives me.
anigbrowl 4y ago
https://dbeaver.io/ 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.
- majkinetor 4y ago
  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.
leetrout 4y ago
Datastation is sorta similar but in my brief experience the description is more aspirational at this stage. https://datastation.multiprocess.io/ https://datastation.multiprocess.io/
- eatonphil 4y ago
  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.
fatih-erikli 4y ago
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.
throwawayboise 4y ago
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.
- eternityforest 4y ago
  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.
  - throwawayboise 4y ago
    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.
    - eternityforest 4y ago
      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.
password4321 4y ago
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 https://news.ycombinator.com/item?id=26657803 (208 points on April 1, 2021 | 142 comments)
nikvdp 4y ago
https://github.com/dbgate/dbgate https://github.com/dbgate/dbgate is an open source SQL IDE that automatically join data from other tables through a similar interface
- crumpled 4y ago
  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.
jkdufair 4y ago
LINQPad
jgale 4y ago
Sigma is a BI system with a visual manipulation interface for query construction (Workbook) that has similarities with Ultorg. https://www.sigmacomputing.com/ https://www.sigmacomputing.com/
jbverschoor 4y ago
Access, Salesforce

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

kostko 4y ago

Yes, tableau

qwertox 4y ago

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

abirch 4y ago
I agree. This is better than DataGrip that my employer gives me.

anigbrowl 4y ago

https://dbeaver.io/ 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.

majkinetor 4y ago
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.

leetrout 4y ago

Datastation is sorta similar but in my brief experience the description is more aspirational at this stage. https://datastation.multiprocess.io/ https://datastation.multiprocess.io/

eatonphil 4y ago
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.

fatih-erikli 4y ago

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.

throwawayboise 4y ago

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.

eternityforest 4y ago
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.
- throwawayboise 4y ago
  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.
  - eternityforest 4y ago
    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.

password4321 4y ago

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 https://news.ycombinator.com/item?id=26657803 (208 points on April 1, 2021 | 142 comments)

nikvdp 4y ago

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

crumpled 4y ago
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.

jkdufair 4y ago

LINQPad

jgale 4y ago

Sigma is a BI system with a visual manipulation interface for query construction (Workbook) that has similarities with Ultorg. https://www.sigmacomputing.com/ https://www.sigmacomputing.com/

jbverschoor 4y ago

Access, Salesforce