ODBC or JDBC support??

[jimrandell]

I LOVE this!!! So how ungrateful would I be to request ODBC and/or JDBC support?

I use dbeaver because it handles just about anything ODBC/JDBC, but boy, would I love to store my sippets in notebooks in my node projects in vscode, and just run them whenever.

• I offer to assist in whatever way I can:
  • I'm a newbe javascript developer, but can follow broad outlines
  • (especially with good examples)
  • my dbeaver configurations and classes, if that helps

[sschneider-ihre-pvs]

relates to #1

[vbdevpro]

I second this request. Adding simple JDBC\ODBC would make this extension the best SQL Query tool available for VS Code and open it up to any RDBMS system that offers ODBC (which is pretty much all of them).

[vbdevpro]

relates to #1

Adding a driver for ODBC sources is not the same as Oracle. I do not believe this is related. Closing the Oracle request should not close this one. Separate issue entirely.

[cmoog]

I'd welcome a contribution in this area. Most of the work will be adding a driver implementation to https://github.com/cmoog/vscode-sql-notebook/blob/a0fea8ce8808c86c683cc5b3dd634cc0af242897/src/driver.ts

[jimrandell]

I'm jammed up for the next few weeks, but when things loosen up, will take a look at https://github.com/cmoog/vscode-sql-notebook/blob/a0fea8ce8808c86c683cc5b3dd634cc0af242897/src/driver.ts, and see if there is anything i could do! (I miss Chicago!!! I lived in Wrigleyville from 90-96 before moving to SF)

[rubensa]

Looks like something like:

• node-jdbc: The most feature rich. Currently looking for maintainers or sponsors.
• node-jdbc-connection: Not much features.
• node-jdbc-driver: More up to date but looks like the API is not very "generic".

might be used here.

[rubensa]

More alternatives:

• naxmefy/jdbc: Has some problems on Windows (because node-java)
• node-jdbc-tibero: A fork from node-jdbc-driver

And for the ODB support, looks like this might be the way to go:

• node-odbc