Forum: The Down-Lo BBS

Dark
Log in

Username Password

SQLite Client

From Michael J. Ryan@1:103/705 to GitLab note in main/sbbs on Sun Feb 7 07:04:09 2021

https://gitlab.synchro.net/main/sbbs/-/issues/118#note_1555

Bump.Suggested API/UX: https://github.com/JoshuaWise/better-sqlite3/blob/master/docs/api.mdWhere `Database` or `Sqlite3` is a declared constructor in all the Synchronet JS environments.
--- SBBSecho 3.12-Linux
* Origin: Vertrauen - [vert/cvs/bbs].synchro.net (1:103/705)

From Michael J. Ryan@1:103/705 to GitLab note in main/sbbs on Sun Feb 7 07:05:21 2021

https://gitlab.synchro.net/main/sbbs/-/issues/118#note_1556

Would also be nice to include the SQLite3 JSON extensions.
--- SBBSecho 3.12-Linux
* Origin: Vertrauen - [vert/cvs/bbs].synchro.net (1:103/705)

From Rob Swindell@1:103/705 to GitLab note in main/sbbs on Sun Feb 7 12:59:44 2021

https://gitlab.synchro.net/main/sbbs/-/issues/118#note_1557

That Suggested API/UX seems to show `Database` and `Statement` classes, no `Sqlite3` class.
--- SBBSecho 3.12-Linux
* Origin: Vertrauen - [vert/cvs/bbs].synchro.net (1:103/705)

From Michael J. Ryan@1:103/705 to GitLab note in main/sbbs on Mon Feb 8 18:13:28 2021

https://gitlab.synchro.net/main/sbbs/-/issues/118#note_1562

@rswindell better-sqlite3 is a named import, so can use whatever names you want... I figured since it would be global in sync, might want to use different names for the classes.
--- SBBSecho 3.12-Linux
* Origin: Vertrauen - [vert/cvs/bbs].synchro.net (1:103/705)

From Nigel Reed@1:103/705 to GitLab note in main/sbbs on Sun Apr 27 06:25:15 2025

https://gitlab.synchro.net/main/sbbs/-/issues/118#note_7149

I'm going to bump this since I'm working on a project that would benefit from sql due to the amount of data and being able to sort and select on it.
--- SBBSecho 3.24-Linux
* Origin: Vertrauen - [vert/cvs/bbs].synchro.net (1:103/705)

From Fernando Toledo@1:103/705 to GitLab note in main/sbbs on Sun Apr 27 12:50:17 2025

https://gitlab.synchro.net/main/sbbs/-/issues/118#note_7151

In the Jurassic era there was something like this:

https://downloads.bbs.docksud.com.ar/sync/js_sqlite/
--- SBBSecho 3.24-Linux
* Origin: Vertrauen - [vert/cvs/bbs].synchro.net (1:103/705)

From Nigel Reed@1:103/705 to GitLab note in main/sbbs on Sun Apr 27 22:31:14 2025

https://gitlab.synchro.net/main/sbbs/-/issues/118#note_7153

This site doesn't appear available.
--- SBBSecho 3.24-Linux
* Origin: Vertrauen - [vert/cvs/bbs].synchro.net (1:103/705)

From Nigel Reed@1:103/705 to GitLab note in main/sbbs on Sun Apr 27 22:31:49 2025

https://gitlab.synchro.net/main/sbbs/-/issues/118#note_7153

This site doesn't appear available. Maybe you can zip the files and attach them here or upload them to my bbs endofthelinebbs.com if you have time. Thanks.
--- SBBSecho 3.24-Linux
* Origin: Vertrauen - [vert/cvs/bbs].synchro.net (1:103/705)

From Fernando Toledo@1:103/705 to GitLab note in main/sbbs on Mon Apr 28 19:23:27 2025

https://gitlab.synchro.net/main/sbbs/-/issues/118#note_7161

I do not see connection issues, but I attach files here [js_sqlite.zip](/uploads/191acb325f53ae3fa561270e108e53db/js_sqlite.zip)
--- SBBSecho 3.24-Linux
* Origin: Vertrauen - [vert/cvs/bbs].synchro.net (1:103/705)

Who's Online
Recent Visitors
- StingRay
  Sat Aug 22 09:47:49 2026
  from A-Net Online, Ga via SSH
- TestUser
  Sat Aug 22 04:33:01 2026
  from Internet, Io via Telnet
- TestUser
  Sat Aug 22 04:29:04 2026
  from Internet, Io via Telnet
- TestUser
  Sat Aug 22 04:27:06 2026
  from Internet, Io via Telnet

System Info

Sysop:	Winzlo
Location:	Minnesota, USA
Users:	11
Nodes:	16 (0 / 16)
Uptime:	495945:01:53
Calls:	82
Files:	1,070
D/L today:	27 files (11,920K bytes)
Messages:	287,039