How to load extension for SQLIte DB (better-sqlite3)?

Questions and Answers
1
System Information
  • Strapi Version: 4.23.1
  • Operating System: ubuntu 20
  • Database: sqlite
  • Node Version: 20.11.0
  • NPM Version: 10.2.4
  • Yarn Version:

Hi, i want to use extension “unicode” (from GitHub - nalgeon/sqlean: The ultimate set of SQLite extensions) for my SQLite db

I know that better-sqlite3 db instance has method .loadExtension and it is exactly what i need.

How can i call this loadExtension method for my db on start of Strapi project?

2

Strapi uses knex under the hood for DB connections seems like knex does not have support for this.