Turso: Has anyone attempted running with a Turso database backend?

commentsBot · June 24, 2024, 12:45am

since Turso (https://turso.tech/) is basically just SQLight (in a hosting env) it feels like it should work but I’ve had gotchas in the past and just want to see if anyone else has already done the hard part.

This topic has been created from a Discord post (1254598356500746300) to give it more visibility.
It will be on Read-Only mode here.
Join the conversation on Discord

commentsBot · June 24, 2024, 5:29am

It would need to be supported by Knex, if it isn’t supported them them, we could never support it.

commentsBot · June 24, 2024, 6:58am

Knex supports SQLite so I guess if Turso connects the same way it should work?

commentsBot · June 24, 2024, 9:26am

thanks will let you know what I find.

commentsBot · June 24, 2024, 9:50am

I suppose it’s more accurate to say it uses libSQL (GitHub - tursodatabase/libsql: libSQL is a fork of SQLite that is both Open Source, and Open Contributions.) which is a fork of SQLite

commentsBot · June 24, 2024, 10:00am

commentsBot · June 24, 2024, 10:01am

Seems to show how to use libsql with Knex. I haven’t gotten into anything yet though.

commentsBot · July 1, 2024, 9:21pm

This would be the dream

commentsBot · July 10, 2024, 5:38pm

I tried with a custom dialect that knex seems to suggest but unfortunately there’s code which runs inside strapi that expects the database client property to be a string, so passing a custom knex implementation doesn’t work.

github.com

strapi/strapi/blob/840962f2a5cbe899490400e880a366f32b06d532/packages/core/database/src/dialects/index.ts#L26


      
              case 'sqlite':
                return SqliteClass;
              default:
                throw new Error(`Unknown dialect ${client}`);
            }
          };
          
          /**
           * Get the dialect of a database client
           */
          const getDialectName = (client: unknown) => {
            switch (client) {
              case 'postgres':
                return 'postgres';
              case 'mysql':
              case 'mysql2':
                return 'mysql';
              case 'sqlite':
              case 'sqlite-legacy':
                return 'sqlite';
              default:

commentsBot · July 10, 2024, 6:13pm

Managed to spoof sqlite3 package to be @libsql/sqlite3 but I’m running into an issue with the filename I’m passing in (for libsql://) being transformed into a file path.

commentsBot · July 10, 2024, 6:24pm

This function is preventing it from working: strapi/packages/core/database/src/dialects/sqlite/index.ts at develop · strapi/strapi · GitHub

commentsBot · July 10, 2024, 6:26pm

Could you please support libsql based on the GitHub - libsql/libsql-node-sqlite3: node-sqlite3 compatible API for libSQL implementation?

Namely, refactor configure to allow the url paths accepted by libsql?

Additionally it would be nice if strapi supported it more natively, such that we can pass in custom knex clients

commentsBot · July 10, 2024, 6:27pm

That’s not up to us, it would have to be accepted by Knex before we could even consider it

commentsBot · July 10, 2024, 6:27pm

Knex has very specific driver package requirements that we can’t change

commentsBot · July 10, 2024, 6:27pm

Kinda feel like you’re passing the buck a little here ngl

commentsBot · July 10, 2024, 6:28pm

We have no other choice, the way to work with Knex requires Knex to support the driver

commentsBot · July 10, 2024, 6:28pm

github.com

knex/knex/blob/176151d8048b2a7feeb89a3d649a5580786d4f4e/lib/constants.js#L8-L34


      
          const SUPPORTED_CLIENTS = Object.freeze(
            [
              'mssql',
              'mysql',
              'mysql2',
              'oracledb',
              'postgres',
              'pgnative',
              'redshift',
              'sqlite3',
              'cockroachdb',
              'better-sqlite3',
            ].concat(Object.keys(CLIENT_ALIASES))
          );
          
          const DRIVER_NAMES = Object.freeze({
            MsSQL: 'mssql',
            MySQL: 'mysql',
            MySQL2: 'mysql2',
            Oracle: 'oracledb',

This file has been truncated. show original

commentsBot · July 10, 2024, 6:28pm

Those are the supported clients and drivers by Knex

commentsBot · July 10, 2024, 6:28pm

if it’s not in that list we can’t support it

commentsBot · July 10, 2024, 6:30pm

“Can’t” as in literally cannot