Forum: The Horizon BBS

SQLite Client

From Michael J. Ryan@VERT to GitLab note in main/sbbs on Sun Feb 7 15: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.md

Where `Database` or `Sqlite3` is a declared constructor in all the Synchronet JS environments.

---
� Synchronet � Vertrauen � Home of Synchronet � [vert/cvs/bbs].synchro.net

From Michael J. Ryan@VERT to GitLab note in main/sbbs on Sun Feb 7 15:05:21 2021

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

Would also be nice to include the SQLite3 JSON extensions.

---
� Synchronet � Vertrauen � Home of Synchronet � [vert/cvs/bbs].synchro.net

From Rob Swindell@VERT to GitLab note in main/sbbs on Sun Feb 7 20: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.

---
� Synchronet � Vertrauen � Home of Synchronet � [vert/cvs/bbs].synchro.net

From Michael J. Ryan@VERT to GitLab note in main/sbbs on Tue Feb 9 02: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.

---
� Synchronet � Vertrauen � Home of Synchronet � [vert/cvs/bbs].synchro.net

From Nigel Reed@VERT 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.

---
� Synchronet � Vertrauen � Home of Synchronet � [vert/cvs/bbs].synchro.net

From Fernando Toledo@VERT 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/

---
� Synchronet � Vertrauen � Home of Synchronet � [vert/cvs/bbs].synchro.net

From Nigel Reed@VERT 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.

---
� Synchronet � Vertrauen � Home of Synchronet � [vert/cvs/bbs].synchro.net

From Nigel Reed@VERT 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.

---
� Synchronet � Vertrauen � Home of Synchronet � [vert/cvs/bbs].synchro.net

From Fernando Toledo@VERT 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)

---
� Synchronet � Vertrauen � Home of Synchronet � [vert/cvs/bbs].synchro.net

Who's Online
Recent Visitors
- Dave Drum
  Thu Jun 12 19:26:59 2025
  from Springfield, Illinois via Telnet
- Dave Drum
  Thu Jun 12 19:11:17 2025
  from Springfield, Illinois via Telnet
- Dave Drum
  Thu Jun 12 18:55:19 2025
  from Springfield, Illinois via Telnet
- Genalb
  Thu Jun 12 07:15:59 2025
  from Slc, Utah via Telnet

System Info

Sysop:	Chris Crash
Location:	Huntington Beach, CA.
Users:	615
Nodes:	8 (0 / 8)
Uptime:	57:30:43
Calls:	10,874
Files:	5
Messages:	517,943