• Feature Request: SQLite3 interface

    From Tracker1@1:229/2 to All on Wednesday, November 04, 2020 15:57:36
    From: tracker1@TRN.remove-9ax-this

    To: DOVE-Net.Synchronet_Discussion
    Would be nice to be able to utilize SQLite3 based databases from the
    JavaScript Object Model.

    An example of a decent API for Database access would be the
    better-sqlite3 module, this is specifically for node, but the interface
    could be adapted for Synchronet.

    https://github.com/JoshuaWise/better-sqlite3/blob/HEAD/docs/api.md

    The most striking example of where this could be useful would be the
    JSON db service. Though there are others, especially external modules
    and potentially other uses over time.

    --
    Michael J. Ryan
    tracker1 +o Roughneck BBS
    ---
    þ Synchronet þ Roughneck BBS - roughneckbbs.com
    --- Synchronet 3.18c-Win32 NewsLink 1.113
    * Vertrauen - Riverside County, California - telnet://vert.synchro.net

    --- SoupGate-Win32 v1.05
    * Origin: www.darkrealms.ca (1:229/2)
  • From Ragnarok@1:229/2 to All on Thursday, November 05, 2020 18:06:13
    From: ragnarok@DOCKSUD.remove-opd-this

    To: Tracker1
    El 4/11/20 a las 19:57, Tracker1 escribió:
    Would be nice to be able to utilize SQLite3 based databases from the JavaScript Object Model.

    An example of a decent API for Database access would be the
    better-sqlite3 module, this is specifically for node, but the interface
    could be adapted for Synchronet.

    https://github.com/JoshuaWise/better-sqlite3/blob/HEAD/docs/api.md

    The most striking example of where this could be useful would be the
    JSON db service.  Though there are others, especially external modules
    and potentially other uses over time.

    few years ago, I made a patch to begin support sqlite into js model
    NOTE: this code will not work under actual sbbs source tree, but maybe
    can be as approach

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

    Saludos!

    ---
    þ Synchronet þ Dock Sud BBS TLD 24 HS - bbs.docksud.com.ar
    --- Synchronet 3.18c-Win32 NewsLink 1.113
    * Vertrauen - Riverside County, California - telnet://vert.synchro.net

    --- SoupGate-Win32 v1.05
    * Origin: www.darkrealms.ca (1:229/2)