search

opendatahub-io-contrib / workbench-images

Various custom Workbenches and Runtimes for Open Data Hub and OpenShift Data Science
MIT License
35 stars 23 forks source link

Add sqlalchemy with the default DB packages #33

Closed guimou closed 11 months ago

shalberd commented 11 months ago

https://pypi.org/project/SQLAlchemy/

2.0.20 or equivalent ~= in the 2.0.x ...

Preferably both in the runtime image and workbench image, if I understand this correctly you assemble those via common snippets

https://github.com/opendatahub-io-contrib/workbench-images/blob/72cefa576c5e1b09215de791387724871bdbf29c/snippets/bundles/2-datascience/py311/Pipfile#L21

Background:

Sqlalchemy needed in order to resolve a User Warning when used together with pandas.io.sql. Does not matter whether postgres or SQL Server

C:\ProgramData\Miniconda3\lib\site-packages\pandas\io\sql.py:758: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) or
database string URI or sqlite3 DBAPI2 connection
other DBAPI2 objects are not tested, please consider using SQLAlchemy
  warnings.warn(

Thank you :-)