Forum: The Gate BBS

Dark
Register
Log in

Username Password

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
- Yer Lee
  Friday, November 13, 2026 13:59:18
  from Manitowoc, Wi via Telnet
- Carmella Palladini
  Friday, November 13, 2026 13:56:41
  from Rio Grande, Nj via Telnet
- Don Robinson
  Friday, November 13, 2026 13:53:48
  from New Braunfels, Tx via Telnet
- N3OWM
  Friday, November 13, 2026 07:51:49
  from Pennsauken, NJ via Telnet
- Sherry Brooks
  Friday, November 13, 2026 06:58:49
  from Cantralia, Il via Telnet
- Peter Mills
  Friday, November 13, 2026 06:56:27
  from Las Cruces, Nm via Telnet
- Michelle Andrea
  Friday, November 13, 2026 06:51:36
  from Calera, Al via Telnet
- Dr. What
  Friday, November 13, 2026 06:32:15
  from Rockford, MI via Telnet
- Setsuna Seisei
  Friday, November 13, 2026 05:37:33
  from Clermont, Fl via Telnet
- N4CLY
  Thursday, November 12, 2026 21:14:52
  from Polkville, NC via Telnet

System Info

Sysop:	Gate Keeper
Location:	Shelby, NC
Users:	1,105
Nodes:	20 (0 / 20)
Uptime:	497258:27:58
Calls:	16,507
Calls today:	9
Files:	5,713
D/L today:	2 files (8,192P bytes)
Messages:	696,494