[HN Gopher] The Prompt() Function: Use the Power of LLMs with SQL
       ___________________________________________________________________
        
       The Prompt() Function: Use the Power of LLMs with SQL
        
       Author : sebg
       Score  : 24 points
       Date   : 2024-10-17 21:07 UTC (1 hours ago)
        
 (HTM) web link (motherduck.com)
 (TXT) w3m dump (motherduck.com)
        
       | domoritz wrote:
       | I love the simplicity of this. Hurray for small models for small
       | tasks.
        
       | delichon wrote:
       | FROM hn.hacker_news       LIMIT 100
       | 
       | "Oops I forgot the limit clause and now owe MotherDuck and OpenAI
       | $93 billion."
        
       | korkybuchek wrote:
       | Interesting -- is there any impact from LLM outputs not being
       | deterministic?
        
         | xnx wrote:
         | Aren't LLM outputs deterministic given the same inputs?
        
           | korkybuchek wrote:
           | They are not, necessarily. Especially when using commercial
           | providers who may change models, finetunes, privacy layers,
           | and all kinds of other non-foundational-model things without
           | notice.
        
         | drdaeman wrote:
         | SQL functions can be non-deterministic just fine. E.g. SQL:2003
         | grammar defines DETERMINISTIC | NOT DETERMINISTIC
         | characteristic for CREATE FUNCTION. Or, e.g. PostgreSQL has
         | IMMUTABLE | STABLE | VOLATILE clauses.
        
           | korkybuchek wrote:
           | Nice, TIL. Thanks!
        
       ___________________________________________________________________
       (page generated 2024-10-17 23:00 UTC)