TZUTC: -0700   
   MSGID: 52303.syncprog@1:103/705 2c840e58   
   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: UTF-8 4   
   FORMAT: flowed   
   https://gitlab.synchro.net/main/sbbs/-/merge_requests/538#note_7222   
      
   No, my English is pretty bad, this is a assisted translation, ha!   
      
   Regarding the interface, it's true... Perl uses the same idea... do() for   
   queries without results, and prepare() and execute() for queries that return   
   rows.   
   I think this would work (perhaps without needing the prepare method as a   
   separate method).   
      
   Could something like this work? What do you think? (from js side)   
      
   ```javascript   
      
   var ret; //return object array   
   var row; //row object   
      
   db = new SQLite("/tmp/base1");   
   db. debug = false;   
   if (!db. open())   
     writeln ("i can't open it: " + db. errormsg);   
      
   if (db. exec("create table test (a int, b text)"))   
     writeln ("OK Create");   
   else    
     writeln("ops " + db.errormsg);   
      
   for (i=1;i<10;i++)   
     if(db.exec("insert into test values ​​(" + i + ",'hello')"))    
       writeln("OK inserted ");   
     else    
       writeln("ops " + db.errormsg);   
      
   writeln("querying data:");   
      
   if (ret = db.query("select a,b from test")) {    
     for (row in ret) {    
       writeln (ret[row].a + " " + ret[row].b);    
     }   
   } else {    
     writeln("ops: " + db.errormsg);   
   }   
      
   writeln("deleting data:");   
      
   if (ret = db.exec("delete from test")) {    
     writeln("OK delete");   
   } else {    
      writeln("ops: " + db.errormsg);   
   }   
      
   ```   
   --- 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