sqlalchemy does not have a type called Double

pydiverse / pydiverse.pipedag

A data pipeline orchestration library for rapid iterative development with automatic cache invalidation allowing users to focus writing their tasks in pandas, polars, sqlalchemy, ibis, and alike.

https://pydiversepipedag.readthedocs.io/

BSD 3-Clause "New" or "Revised" License

15 stars 2 forks source link

sqlalchemy does not have a type called Double #96

Closed QuantCo-mr-T closed 1 year ago

QuantCo-mr-T commented 1 year ago

see dtype.py:196: DType.FLOAT64: sa.Double(),

Is this a problem that ruff should have picked up?

windiana42 commented 1 year ago

I have seen FLOAT(53)=double vs. FLOAT(24)=real/float but I am not sure this is reliable across all database targets. We can test with databases pipedag supports.

Random link about this topic: https://stackoverflow.com/questions/1056323/difference-between-numeric-float-and-decimal-in-sql-server