1. Forum
  2. DOVE-Net
  3. Synchronet JavaScript

  • SQLite

    From John Dovey@GATOFUEG to All on Friday, June 11, 2021 20:43:38
    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
  • From Ragnarok@DOCKSUD to John Dovey on Saturday, June 12, 2021 13:34:23
    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
  • From Boondock@ELGATO to Ragnarok on Saturday, June 12, 2021 18:16:12
    Re: Re: SQLite
    By: Ragnarok to John Dovey on Sat Jun 12 2021 13:34:23

    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.
    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
  • From Tracker1@TRN to Ragnarok on Sunday, June 27, 2021 14:54:10
    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