home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.os.vms      DEC's VAX* line of computers & VMS.      264,096 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 262,915 of 264,096   
   Lawrence D'Oliveiro to All   
   Re: VMS x86-64 database server   
   29 Jul 25 04:25:53   
   
   From: ldo@nz.invalid   
      
   On Mon, 28 Jul 2025 22:36:59 -0400, Arne Vajhøj wrote:   
      
   > Even with ORM you need to express the query.   
      
   So a lot of the stuff in SQLAlchemy is useless, then?   
      
   > JPQL example (ORM specific query language):   
   >   
   > List res = em.createQuery("SELECT o FROM T1 AS o WHERE o.f > 0",   
   > T1.class).getResultList();   
      
   That seems like a really dumb idea. You see my point about having   
   their own query language does nothing to simplify the code.   
      
   > The big difference in the above two examples compared to traditional   
   > SQL API (JDBC and ADO.NET for Java and .NET) is that it return a   
   > List instead of a generic result like List.   
      
   Is there a version that returns an iterator? Can be more   
   memory-efficient for dealing with lots of returned records.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca