Subj : Inital commit of sqlite support.
To   : GitLab note in main/sbbs
From : Nigel Reed
Date : Fri May 09 2025 16:36:06

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.

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

.