Switch DB from better-sqlite3 to libsql #736

New Issue

MrUnknownDE · 2026-04-05T17:37:14+02:00

MrUnknownDE commented

2026-04-05 17:37:14 +02:00

Originally created by @Lokowitz on 10/21/2025

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.12.2) 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.ts to don't skip this task.

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

*Originally created by @Lokowitz on 10/21/2025* ## 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](https://github.com/fosrl/pangolin/issues/1492) 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.12.2) 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.ts` to don't skip this task. 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

Sign in to join this conversation.

Branches Tags

main

dev

dependabot/npm_and_yarn/dev-minor-updates-b4e5d6b9c5

revert-2766-feature/systemd-install-instructions

dependabot/npm_and_yarn/prod-patch-updates-05702d39f2

dependabot/npm_and_yarn/next-16.2.1

dependabot/npm_and_yarn/recharts-3.8.1

alerting-rules

private-site-ha

dependabot/docker/docker/library/node-25-slim

ssh

delete-account

msg-delivery

org-only-idp

cicd

patch

site-targets-auto-login

No Label

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: github/pangolin#736