有SQLAlchemy方言支持JDBC吗? [英] Is there SQLAlchemy dialect support JDBC?
问题描述
我想通过JDBC驱动程序将超集连接到数据库.但是从我发现的结果来看，没有为此目的准备好的SQLAlchemy方言.最接近的选项可能是 jaydebeapi ，但它也没有SQLAlchemy方言.
I want to connect superset to a database by a JDBC driver. But from what I find there is no a SQLAlchemy dialect ready for this purpose. The closest option may be jaydebeapi but it does not have a SQLAlchemy dialect either.
问题是从SQLAlchemy DB Engine是否可以通过JDBC驱动程序连接数据库?还是有一种方法可以在 superset 中使用JDBC驱动程序?
Question is if there is a way from SQLAlchemy DB Engine to connect a database through JDBC driver? Or is there a way to use JDBC driver in superset?
推荐答案
我一直遇到这个问题-SQLAlchemy项目和JayDeBeAPI项目都不想跨越这个桥梁，这真是可耻.
This something I keep coming up against - it's a real shame that neither the SQLAlchemy project nor the JayDeBeAPI project want to cross this bridge.
它会自动在选择SQLAlchemy的任何工具(如Superset)中启用如此多的附加功能.
It would automatically enable so much additional functionality in any tool that chooses SQLAlchemy like Superset.
我了解到，SQL Alchemy因其ORM功能而需要对特定数据库的SQL方言有更深入的了解，但实现功能最强大的通用JDBC层和/或继承现有方言应该相当简单.
I understand that SQL Alchemy needs a deeper understanding of the specific DB's SQL dialect for it's ORM functionalty, but it should be fairly simple to implement a mostly functional generic JDBC layer and/or inherit the existing dialects.
我能找到的最新参考文献是:
The most up to date reference I can find is this:
这篇关于有SQLAlchemy方言支持JDBC吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
