Live data from Hacker News

Ultorg: A user interface for relational databases [video]

hytradboi.com

21–30 of 70 posts

Re: Ultorg: A user interface for relational databases [video]

#21
post #2

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

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.

Re: Ultorg: A user interface for relational databases [video]

#22
post #15

I've been using Hasura and TablePlus a lot lately, and actually wished for something that combines them. Hasura is great at understanding relations and making joins feel effortless and TablePlus is so good at making table editing feel as fast as excel. This looks like it's the thing, with some extra power thrown on top (formulas and nested layouts are nice!). The UI looks drab, but maybe that's ok? It means the funct…

No post body was provided.

Re: Ultorg: A user interface for relational databases [video]

#23
post #15

I've been using Hasura and TablePlus a lot lately, and actually wished for something that combines them. Hasura is great at understanding relations and making joins feel effortless and TablePlus is so good at making table editing feel as fast as excel. This looks like it's the thing, with some extra power thrown on top (formulas and nested layouts are nice!). The UI looks drab, but maybe that's ok? It means the funct…

+1 for TablePlus! I absolutely love them for the fast editing as well as quick and dirty filters. Beats typing SQL for simple stuff. These quality of life features are really underrated. Absolutely worth the yearly fee!

I feel like they see themselves as a database management tool, but with just a few tweaks (good UI for working with relations), could be a FileMaker / Airtable contender.

Re: Ultorg: A user interface for relational databases [video]

#24

Here’s some more information on Ultorg: > Ultorg creates general-purpose software that helps organizations manage their data. Based on a new method for interactive data visualization, our product combines ease-of-use with expressive power to allow end-users to query, display, and edit relational data, without resorting to custom programming. This fills a long-standing gap between spreadsheets and tailor-made database…

> I find it inspiring that it has such readable and space-efficient interface, compared to current trends in many web apps.

Agree.

Re: Ultorg: A user interface for relational databases [video]

#26
Related: I'm enjoying the format of the HYTRADBOI (have you tried rubbing a database on it?) videos. It doesn't have that live-presentation feel of an in-person conference talk, but as I'm behind a screen anyway I don't really care about that. Give me the information succinctly, so I can watch it during a coffee break or whatever.

The organiser of the conference had an interesting (and likeiwse pleasantly succinct!) post-mortem write up of the event, if anyone is interested

https://www.scattered-thoughts.net/writing/hytradboi-2022-po...

Re: Ultorg: A user interface for relational databases [video]

#27
post #6
post #2

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

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.

Re: Ultorg: A user interface for relational databases [video]

#28

Here’s some more information on Ultorg: > Ultorg creates general-purpose software that helps organizations manage their data. Based on a new method for interactive data visualization, our product combines ease-of-use with expressive power to allow end-users to query, display, and edit relational data, without resorting to custom programming. This fills a long-standing gap between spreadsheets and tailor-made database…

I wonder how much the data in the demo helps sell the readability and space-efficiency. Like anything looks tidy if there's 3-4 rows of data being joined. But that sort of well behaved small-scale hello world database isn't difficult to work with in any tool.

How does it handle if the table I join pulls in a thousand matching rows for each key?

Re: Ultorg: A user interface for relational databases [video]

#29
post #2

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

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.

Re: Ultorg: A user interface for relational databases [video]

#30

Here’s some more information on Ultorg: > Ultorg creates general-purpose software that helps organizations manage their data. Based on a new method for interactive data visualization, our product combines ease-of-use with expressive power to allow end-users to query, display, and edit relational data, without resorting to custom programming. This fills a long-standing gap between spreadsheets and tailor-made database…

I wonder how much the data in the demo helps sell the readability and space-efficiency. Like anything looks tidy if there's 3-4 rows of data being joined. But that sort of well behaved small-scale hello world database isn't difficult to work with in any tool. How does it handle if the table I join pulls in a thousand matching rows for each key?

> I wonder how much the data in the demo helps sell the readability and space-efficiency.

This is a very good question.. In the section of the video on automatic form layout it is strongly implied that the auto-layout is driven by semantic inference of the column names. I see this easily breaking -- anyone who's ever inherited a production database knows that column names are often cryptic or context specific.

Also makes me wonder how well that system handles databases with non-English identifiers?

Post reply on HN