I'm not sure if this is doable, so I was wondering if, before I dive down the rabbit-hole, someone else has some idea.
I want to write something and access some SQLite data from within the js. Something like this:
=Start=
var sqlite3 = require('sqlite3').verbose();
var db = new sqlite3.Database(':memory:');

db.serialize(function() {
db.run("CREATE TABLE lorem (info TEXT)");

var stmt = db.prepare("INSERT INTO lorem VALUES (?)");
for (var i = 0; i < 10; i++) {
stmt.run("Ipsum " + i);
}
stmt.finalize();

db.each("SELECT rowid AS id, info FROM lorem", function(err, row) {
console.log(row.id + ": " + row.info);
});
});

db.close();

=end=

Any suggestions?

Thanks
JD
---
* El Gato de Fuego (The Fire Cat) 4:920/69 * Pedasi, Panama

.... HE has not a single redeeming defect.
---
■ Synchronet ■ El Gato de Fuego - Pedasi, Panama - gatofueg.synchro.net

El 11/6/21 a las 22:43, John Dovey escribi�:
> I'm not sure if this is doable, so I was wondering if, before I dive down the rabbit-hole, someone else has some idea.
> I want to write something and access some SQLite data from within the js. Something like this:
> =Start=
> var sqlite3 = require('sqlite3').verbose();
> var db = new sqlite3.Database(':memory:');
>
> db.serialize(function() {
> db.run("CREATE TABLE lorem (info TEXT)");
>
> var stmt = db.prepare("INSERT INTO lorem VALUES (?)");
> for (var i = 0; i < 10; i++) {
> stmt.run("Ipsum " + i);
> }
> stmt.finalize();
>
> db.each("SELECT rowid AS id, info FROM lorem", function(err, row) {
> console.log(row.id + ": " + row.info);
> });
> });
>
> db.close();
>
hi John, several year ago i wrote a simple patch to sbbs code to get
sqlite databases object in JS (very very very simple)
the patch is out of date now, but maybe you can patch against to actual
git code. Its no for production environment, just a test.

http://downloads.bbs.docksud.com.ar/sync/js_sqlite/

if i get free time maybe i try patching over current code.

Saludos!

---
� Synchronet � Dock Sud BBS TLD 24 HS - bbs.docksud.com.ar

Re: Re: SQLite
By: Ragnarok to John Dovey on Sat Jun 12 2021 13:34:23

Ra> hi John, several year ago i wrote a simple patch to sbbs code to get
Ra> sqlite databases object in JS (very very very simple)
Ra> the patch is out of date now, but maybe you can patch against to actual
Ra> git code. Its no for production environment, just a test.
Ra> if i get free time maybe i try patching over current code.

That looks fantastic, thank you. I will give that a try on my *crash+burn* server.

For the production one, I'm going to try exec an external program to handle database reading and update. We'll see how it goes.

All the best
John
---
BoonDock
aka John Dovey

.... Genius is one per cent inspiration and ninety-nine per cent perspiration.
---
■ Synchronet ■ Sent from El Gato de Fuego * The Fire Cat * elgato.synchronetbbs.org

On 6/12/2021 9:34 AM, Ragnarok wrote:
>
> hi John, several year ago i wrote a simple patch to sbbs code to get
> sqlite databases object in JS (very very very simple)
> the patch is out of date now, but maybe you can patch against to actual
> git code. Its no for production environment, just a test.
>
> http://downloads.bbs.docksud.com.ar/sync/js_sqlite/
>
> if i get free time maybe i try patching over current code.

It would be really nice to be able to access SQLite shared databases via
SynchroNet... I'm fond of the better-sqlite npm package myself for Node.
--
Michael J. Ryan - tracker1@roughneckbbs.com
---
� Synchronet � Roughneck BBS - roughneckbbs.com