Forum: The Gate BBS

SQLite Client

From Michael J. Ryan@1:103/705 to GitLab note in main/sbbs on Sunday, February 07, 2021 07:04:09

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 Sunday, February 07, 2021 07:05:21

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 Sunday, February 07, 2021 12:59:44

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 Monday, February 08, 2021 18:13:28

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 Sunday, April 27, 2025 06:25:15

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 Sunday, April 27, 2025 12:50:17

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 Sunday, April 27, 2025 22:31:14

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 Sunday, April 27, 2025 22:31:49

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 Monday, April 28, 2025 19:23:27

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
- Dr. What
  Sunday, July 06, 2025 09:20:15
  from Rockford, MI via Telnet

System Info

Sysop:	Gate Keeper
Location:	Shelby, NC
Users:	792
Nodes:	20 (0 / 20)
Uptime:	81:14:05
Calls:	12,361
Calls today:	1
Files:	5,294
D/L today:	19 files (4,301K bytes)
Messages:	576,571