mirror of
https://github.com/fosrl/pangolin.git
synced 2025-12-05 19:17:29 -06:00
[PR #1723] Switch DB from better-sqlite3 to libsql #1194
No Assignees
Notifications
Due Date
No due date set.
Dependencies
No dependencies set.
Reference: github-starred/pangolin#1194
Reference in New Issue
Block a user
No description provided.
Delete Branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
📋 Pull Request Information
Original PR: https://github.com/fosrl/pangolin/pull/1723
Author: @Lokowitz
Created: 10/21/2025
Status: 🔄 Open
Base:
dev← Head:db-switch📝 Commits (10+)
0e1603cfirst change to libsql4a59823Actually run the migrations; update exit nodes18d8f72Change runner backd10830fFix exitNodeId cole77909dChange runs on000d6adMerge remote-tracking branch 'upstream/dev' into db-switchacf23ccmerge upstreamd20deadadd local testac04eecmigrationsfcad3a1set min version to 1.11.2📊 Changes
43 files changed (+299 additions, -2752 deletions)
View changed files
📝
.github/workflows/cicd.yml(+1 -1)📝
.github/workflows/linting.yml(+1 -1)📝
.github/workflows/test.yml(+1 -1)📝
Makefile(+8 -0)📝
package-lock.json(+235 -288)📝
package.json(+1 -2)📝
server/db/sqlite/driver.ts(+3 -3)📝
server/db/sqlite/migrate.ts(+1 -1)📝
server/lib/consts.ts(+1 -1)📝
server/private/routers/auth/quickStart.ts(+2 -2)📝
server/private/routers/remoteExitNode/createRemoteExitNode.ts(+2 -2)📝
server/private/routers/remoteExitNode/quickStartRemoteExitNode.ts(+2 -2)📝
server/routers/auth/signup.ts(+2 -2)📝
server/routers/newt/createNewt.ts(+2 -2)📝
server/routers/olm/createOlm.ts(+2 -2)📝
server/setup/migrationsPg.ts(+2 -0)📝
server/setup/migrationsSqlite.ts(+13 -49)📝
server/setup/scriptsPg/1.11.1.ts(+6 -2)➖
server/setup/scriptsSqlite/1.0.0-beta1.ts(+0 -5)➖
server/setup/scriptsSqlite/1.0.0-beta10.ts(+0 -44)...and 23 more files
📄 Description
Community Contribution License Agreement
By creating this pull request, I grant the project maintainers an unlimited,
perpetual license to use, modify, and redistribute these contributions under any terms they
choose, including both the AGPLv3 and the Fossorial Commercial license terms. I
represent that I have the right to grant this license for all contributed content.
Description
Hey guys,
this is related to the issue that better-sqlite3 is not supporting async anymore.
This PR is an example how we could do the step to libsql with a minimum of effort.
This will require all users to migrate first to the latest available version (current 1.11.1) because I deleted all old migration files for sql because otherwise they need to be completely rewritten.
I added a check in
server/setup/migrationsSqlite.tsto don't skip this task.If you want to go to version 2.0.0 is up to you and can be changed as you like.
If you don't want to go this way and want to rewrite all migration files, than feel free to take over because this is out of my skills :-D
Cheers Marvin
🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.