[HN Gopher] Ultorg: A General-Purpose User Interface for Relatio...
       ___________________________________________________________________
        
       Ultorg: A General-Purpose User Interface for Relational Databases
       (2020) [video]
        
       Author : ivank
       Score  : 47 points
       Date   : 2021-12-22 11:19 UTC (11 hours ago)
        
 (HTM) web link (www.youtube.com)
 (TXT) w3m dump (www.youtube.com)
        
       | jhgb wrote:
       | Anyone here nostalgic for Dabble DB? That's probably the first
       | thing that came to my mind when I saw this.
        
       | ivank wrote:
       | http://www.ultorg.com/
       | 
       | https://twitter.com/ultorg
        
       | beaconstudios wrote:
       | This makes a lot of sense. In my tinkering with what a radically
       | clarified form of programming would look like, I've come to
       | believe that any such effort would have to be built around a
       | database at its core. Personally, I think graph databases are a
       | more intuitive fit for how we think about objects and their
       | relationships to each other, but relational dbs are pretty close
       | too.
        
         | convolvatron wrote:
         | they should be really two views of the same thing?
        
           | beaconstudios wrote:
           | A graph and tables are similar perspectives but different in
           | a number of really important ways. Tables generally lend
           | themselves best to analysis of homogeneous data within a
           | small number of tables for example, while graph databases
           | make it easy to perform deep queries across many different
           | schemas while still keeping the resultant objects separate.
        
       | lioeters wrote:
       | Also of interest, an article from the research project on which
       | Ultorg is based:
       | 
       | Expressive Query Construction through Direct Manipulation of
       | Nested Relational Results
       | 
       | http://people.csail.mit.edu/ebakke/research/sieuferd_sigmod2...
       | (PDF)
        
       | arnarbi wrote:
       | The part of the demo where he creates a computed field inside the
       | sub-result (in a hierarchy), and then uses that in an aggregate
       | at the next level above is excellent. And then he can still see
       | the constituent rows contributing to the aggregate and continue
       | adding filters on them.
       | 
       | I am sold, even as someone comfortable with writing complex
       | queries.
        
       | akvadrako wrote:
       | Just skipped to the middle of that video and see the other 3
       | participants are pretty weird. They are constantly holding big
       | smiles with their teeth showing. That can't be real.
        
         | cdcarter wrote:
         | Those are photographs of the participants.
        
       | eternityforest wrote:
       | Seems very much needed. Direct access to production databases
       | with current tools is clearly not safe.
        
       ___________________________________________________________________
       (page generated 2021-12-22 23:02 UTC)