timeplus-io / proton-python-driver

Python driver for Timeplus Enterprise or Timeplus Proton
https://timeplus.com
Other
14 stars 4 forks source link

In addition to fetchall, also support df(), pl(), arrow() and fetchnumpy() #47

Closed jovezhong closed 3 weeks ago

jovezhong commented 3 months ago

Today https://github.com/timeplus-io/proton-python-driver/blob/develop/proton_driver/dbapi/cursor.py only support fetchall() to return the Python object. One user suggests us supporting dataframe out of box.

https://duckdb.org/docs/api/python/overview.html#result-conversion

image
jovezhong commented 3 months ago

Update, the Client supports dataframe query and insert, but the connect/cursor cannot Sample code https://github.com/timeplus-io/proton-python-driver/blob/develop/example/pandas/dataframe.py

Better to add those dataframe support in connect/cursor too