Just a sample of the Echomail archive
Cooperative anarchy at its finest, still active today. Darkrealms is the Zone 1 Hub.
|    SYNC_PROGRAMMING    |    Synchronet/Baja/XSDK Programming    |    49,116 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 46,922 of 49,116    |
|    Nigel Reed to GitLab note in main/sbbs    |
|    Inital commit of sqlite support.    |
|    09 May 25 16:36:06    |
   
   TZUTC: -0700   
   MSGID: 52306.syncprog@1:103/705 2c8493b8   
   PID: Synchronet 3.21a-Linux master/85dea2614 Apr 11 2025 GCC 12.2.0   
   TID: SBBSecho 3.25-Linux master/0c503c4ea May 04 2025 GCC 12.2.0   
   BBSID: VERT   
   CHRS: ASCII 1   
   FORMAT: flowed   
   https://gitlab.synchro.net/main/sbbs/-/merge_requests/538#note_7224   
      
   This doesn't demonstrate how to do a prepare though.   
      
   For example, in perl, we'd do something like   
      
   ```   
   my $dbh = DBI->connect("dbi:SQLite:dbname=/sbbs/data/mydatabase.db", "", "", {   
    RaiseError => 1,   
    AutoCommit => 1,   
   }) or die $DBI::errstr;   
   my $try = $dbh->prepare("UPDATE queue SET retry=retry+1 WHERE site=?");   
   my $reset = $dbh->do("UPDATE queue SET retry=0");   
   my $comp = $dbh->prepare("UPDATE queue SET complete=1 WHERE site=?");   
      
      
   $try->execute("endofthelinebbs.com");   
   $comp->execute("vert.synchro.net");   
   $reset->execute();   
   ```   
      
   So db.query would be the same as $dbh->do   
      
   So do we need to create db.prepare ?   
      
   I'm really not sure where to go with this.   
   --- SBBSecho 3.25-Linux   
    * Origin: Vertrauen - [vert/cvs/bbs].synchro.net (1:103/705)   
   SEEN-BY: 103/705 105/81 106/201 124/5016 128/187 153/757 7715 154/10   
   SEEN-BY: 154/30 110 203/0 218/700 221/0 226/30 227/114 229/110 114   
   SEEN-BY: 229/206 317 400 426 428 470 550 700 705 240/1120 5832 263/1   
   SEEN-BY: 266/512 280/464 5003 5006 291/111 292/8125 301/1 320/219   
   SEEN-BY: 322/757 341/66 234 342/200 396/45 423/120 460/58 256 1124   
   SEEN-BY: 467/888 633/280 712/848 770/1 902/26 5020/400 8912 5054/30   
   SEEN-BY: 5075/35   
   PATH: 103/705 280/464 460/58 229/426   
      
|
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca