Subj : Inital commit of sqlite support.
To   : GitLab note in main/sbbs
From : Fernando Toledo
Date : Fri May 09 2025 07:07:05

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);
}

```

---
 þ Synchronet þ Vertrauen þ Home of Synchronet þ [vert/cvs/bbs].synchro.net

.