edgarrmondragon / gatsby-source-sql Goto Github PK

since the plugin is not available as npm it is not listed at: https://www.gatsbyjs.org/plugins/?=sql

:(

Gatsby v4 appears to no longer use the gatsby-node.js file.

I'm using this in my gatsby-config.ts file:

    {
      resolve: 'gatsby-source-sql',
      options: {
        typeName: 'Songs',
        fieldname: 'data',
        dbEngine: {
          client: 'better-sqlite3',
          debug: true,
          connection: {
            filename: './src/data.db',
          },
        },
        queryChain: (x) =>
          x.select('id', 'title')
          .from('songs')
      },
    },

...but I see this error go by when starting gatsby develop:

Error: knex: Unknown configuration option 'client' value better-sqlite3.

(I'm using better-sqlite3 as sqlite3 won't compile for me; Node 16.13, MacOS 12.3)

The server starts up, and in GraphiQL I can see entries for allSqlSource and sqlSource, however they do not reflect the data in my file.

(Tangential: it's not clear to me how the fieldName value is used.)

I am unable to get this to work with mssql. I get no errors and my queries don't show up in graphiql.