[feat]: add gatsby-source-sql

[DSchau]

Summary

It'd be awesome to be able to (at build time!) inject content from a SQL database, just like we do for other source types, e.g. filesystem, Contentful, etc.

Motivation

• People may have useful data stored away in SQL that could be exposed to enable helpful things, e.g. documentation, useful data, etc.
• The plugin will need to connect to a SQL database, and then pre-load queries (e.g. pass the SQL queries directly to the plugin?)

Further Detail

The general idea is that the source plugin will need to be able to connect to a SQL database (MySQL, MSSQL, ... ?; happy to start small and grow it in the future!) and query that data to inject into the GraphQL content layer for further processing via Gatsby.

Consider mysql, mssql for various means to inject data

See other source plugins for more info on how to build this out, e.g. gatsby-source-contentful, gatsby-source-wordpress, etc.

[daubaris]

me me me! Could you also direct on where to start? :)

[DSchau]

@daubaris 👋 Absolutely! So I'd recommend checking out one of the source plugins I linked, and kinda re-tracing from there!

So high level, this is what this will look like:

• Create/copy a directory in packages/gatsby-source-sql
• Implement the appropriate Node APIs (probably sourceNodes)
• Open up a PR (early/WIP is fine, just mark it as such!) and we'll be happy to give some feedback

If you're interested, we'd love to help out with a pairing session, as well. Sign up for those here

And let me know if I can help with this further :)

[ariamckinley]

If I were to suggest sqlite support as well, would that be lumped into this plugin or it's own thing?

[DSchau]

@garetmckinley good question! I'm not sure how to best resolve that complexity to be honest with you.

Ideally there'd be one shared sql plugin, but the more I think about it, I'm not sure how tenable that is because the engine will have to change between MySQL, mssql, SQLLite, etc.

So we may be able to introduce some shared helpers, but I think this plugin may take additional plugins, and those plugins should implement some API perhaps?

[DSchau]

(very similar to gatsby-transformer-remark if you're familiar!)

[ariamckinley]

Yeah, I think that makes the most sense! I'll keep an eye on the progress of this issue, because I have a use-case for gatsby with sqlite. I'd be more than happy to work on a sqlite plugin for this source when the time comes.

[DSchau]

@garetmckinley that would be so great! Stay tuned 👀

[oorestisime]

Once this progresses i d like to look for some postgres integration as well.

[koreyboone]

Is this claimed?