[FEATURE] 增加 Vertica 数据库支持 (基于 vertica-python)
Open
@yayanpei-fit2cloud is already working on this.
Since Mar 23, 2026.
feature
- Dominant language
- JavaScript
- Stars
- 6.8k
- Forks
- 882
- Avg merge
- 4h 37m
- Merged PRs (30d)
- 32
Description
SQLBot 1.7.0
需求背景
希望能原生支持 Vertica 数据库，以便直接连接和分析存储在 Vertica 数据仓库中的大规模数据，避免繁琐的中间导出步骤
实现建议
- 驱动程序：建议使用官方维护的
vertica-python（完全兼容 Python DB API 2.0）。 - SQLAlchemy 支持：如果项目基于 SQLAlchemy，可直接复用现有的 sqlalchemy-vertica 方言。
- 关键配置：默认端口 5433，支持标准连接参数（host, user, database, password）。
测试方案 (CI/CD 友好)
无需商业许可证，维护者可使用免费的 Vertica Community Edition (CE) Docker 镜像轻松搭建测试环境
docker pull vertica/vertica-ce:24.1.0-0
参考链接
驱动文档：https://pypi.org/project/vertica-python/
vertica镜像参考：https://blog.csdn.net/weixin_42316373/article/details/144888221
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.