Ultorg: The User Interface for Relational Databases

(ultorg.com)

60 points | by Ivoah 5 hours ago

11 comments

  • mapcars 2 minutes ago
    Any features worth to switch from DBeaver?
  • kragen 3 hours ago
    Eirik Bakke's Ultorg (SIEUFERD) is amazing and inspirational research, and I'm glad to see that it's finally available to the public after 17 years. It's one of those things that really makes you sit up and take notice of how much better our everyday software could have been.

    However, I wouldn't be willing to try it under proprietary-software terms. Last week, I was thinking about eliciting open-source software with the Ultorg look and feel from an LLM, thus replicating Bakke's HCI research and enabling other HCI researchers to build on it, which won't be possible under a proprietary license.

    My notes on Ultorg may be of interest; you can

      git clone http://canonical.org/~kragen/sw/pavnotes2.git
    
    and read sieuferd.md (5200 words).

    The introduction:

    > Eirik Bakke’s [SIEUFERD][0] (or, as he sometimes spells it, SIUEFERD) is a really interesting and promising generic database frontend, a “schema-independent database UI”. The elevator pitch is “a new kind of graphical query interface [with] the power of SQL but the ease-of-use of a spreadsheet”. (Unfortunately, he forgot to implement the DDL part of SQL, just doing the DML part.)

    I can highly recommend Bakke's 5-minute talk on it from 10 years ago at https://vimeo.com/173726371.

  • akshayrajeshwar 2 hours ago
    Previously used it and it's AMAZING given you have data stored with good practices, e.g. with unique IDs that are consistent among many databases/sheets. I found it's easier to begin with Ultorg's usecase in mind than to migrate existing files to fit its use.

    And I do agree with the criticisms mentioned in the thread. Ultorg is solving a lot of problems of data organisation and context awareness, so starting a business with a perpetual license would be awesome.

    Guess I just don't wanna lose access to the tool once I have all the tailored files and fail to pay again.

    Should mention that Eirik is a joy talk to and will quite possibly accommodate you. All the best to him.

  • NetMageSCW 3 hours ago
    A small desktop app that is a subscription rubs me the wrong way.
    • aetherspawn 2 hours ago
      I agree, it’s novel but please give me a perpetual version that costs like $500 and I’ll buy it. Hate subs.
      • dymk 20 minutes ago
        Problem is, only you and two other people would buy it.
  • maxloh 2 hours ago
    Someone just posted an open-source alternative earlier today. Its UI looks better too.

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

    • vim-guru 44 minutes ago
      From the looks of it, that is just the performance part of it. Ultorg is so much more.
  • polskibus 47 minutes ago
    Isn’t this like a pivot table, that many advanced BI solutions (that have a modeler inside) already have ?
    • wodenokoto 28 minutes ago
      It is and it isn't.

      It looks like a polished thing that from a UX perspective sits between a spreadsheet and PowerBI

      It let's any user with DB access build reports pretty close to how you'd edit a spreadsheet and without having to build pipelines in PowerBI and setup ingestion etc, etc.

      The closest thing I've seen here is the old Tableu Desktop, but this one is more focused on tables than figures.

    • kragen 12 minutes ago
      Not really. Ultorg can do anything SQL (DML) can do, and pivot tables can't do any of that. Ultorg also does pivot tables: https://www.ultorg.com/docs/present/crosstabs/
  • endverbraucher 1 hour ago
    Or you can use open-source DBFlux https://dbflux.dev/
    • wodenokoto 22 minutes ago
      The screenshots looks nice, but the text on the landing page does make me wonder if the whole thing is just a pile of slop.
  • patates 1 hour ago
    I like its flexibility but nothing beats LINQPad and its .Dump() method on that front.
  • refactor_master 2 hours ago
    Sheesh, and they said Apple was doomed for putting small icons inside dropdown menus. Who designed this monstrosity?
  • aetherspawn 2 hours ago
    Question: Is there any way to customise the interface like add extra buttons, for example to export an invoice?
  • chilarai 3 hours ago
    [flagged]