codemirror-sql: a CodeMirror extension for SQL linting, hover, completions, and more

v6
1

Hey all, I wanted to share @marimo-team/codemirror-sql: a CodeMirror extension for SQL linting, hover, completions and many more features. This also contains additional dialect support for other databases like DuckDB and BigQuery.

We would love feedback or open to collaborating.

3 Likes
2

Very cool. I’ve linked the package from the community page.

1 Like
3

thank you @marijn, and thank you for sharing CodeMirror, it is such an amazing library/ecosystem!

4

@mscolnick We’d love to use this in pgAdmin. Very nice.

5

Hi @mscolnick ,

I noticed pl/pgsql is not supported. Any future plans for adding support for constructs like BEGIN END?

6

The main codemirror sql package has the dialect for Postgres - lang-sql/src/sql.ts at main · codemirror/lang-sql · GitHub. You can grab it there.

7

@mscolnick I tried to use this package, and it is failing to compile. When I debugged, it is failing in instance of check for FacetProvider. Likely, mismatch in codemirror version.

I also checked the demo code, and it is using the source code directly. Not the built version.

Any suggestions would help. I use “codemirror” as dependency in package.json.

react-dom.development.js:22874 Uncaught Error: Unrecognized extension value in extension set ([object Object]). This sometimes happens because multiple instances of @codemirror/state are loaded, breaking instanceof checks.
    at inner (index.cjs:1997:23)
    at inner (index.cjs:1972:17)
    at inner (index.cjs:1972:17)
    at inner (index.cjs:1972:17)
    at flatten (index.cjs:2001:5)
    at Configuration.resolve (index.cjs:1909:25)
    at EditorState.create (index.cjs:2741:43)
8

Hi @marijn @mscolnick ,

Can you suggest please?