Subj : Inital commit of sqlite support.
To   : GitLab note in main/sbbs
From : Fernando Toledo
Date : Sat May 10 2025 11:07:29

https://gitlab.synchro.net/main/sbbs/-/merge_requests/538#note_7226

Hello! Please check this commit at my sqlite branch

https://gitlab.synchro.net/Ragnarok/sbbs/-/commit/2e7de43846adfe741b5b55f3b8e20e3feae05da6

It probably still needs better validations and verifications, but that's the idea I was trying to tell you.

Here is a js test example to use (notice that stmt is not use anymore here)

```javascript
var ret; //return object array
var row; //row object 

db = new Sqlite("/tmp/base1");
db.debug = true;
if (!db.open())
    writeln ("i cant 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 + ",'hola')"))
    writeln ("OK inserted ");
else
    writeln ("ops " + db.errormsg);
    
writeln ("queryng 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);
}

db.close();

```

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

.