Skip to content
This repository has been archived by the owner on Mar 28, 2023. It is now read-only.

Add type conversions for floating point numbers in sqlalchemy #346

Open
ehennenfent opened this issue Sep 19, 2018 · 0 comments
Open

Add type conversions for floating point numbers in sqlalchemy #346

ehennenfent opened this issue Sep 19, 2018 · 0 comments
Labels
db SL2 Database stuff enhancement
Milestone

Comments

@ehennenfent
Copy link
Contributor

C:\Python3\lib\site-packages\sqlalchemy\sql\sqltypes.py:603: SAWarning: Dialect sqlite+pysqlite does *not* support Decimal objects natively, and SQLAlchemy must convert from floating point - rounding errors and other issues may occur. Please consider storing Decimal numbers as strings or integers on this platform for lossless storage.
  'storage.' % (dialect.name, dialect.driver))

SQLAlchemy complains about SQLite not having great handling for Decimal columns. We can add a TypeDecorator to fix this, but since it seems to be working right now, this is low priority.

@ehennenfent ehennenfent added enhancement db SL2 Database stuff labels Sep 19, 2018
@ehennenfent ehennenfent added this to the Polish milestone Sep 19, 2018
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
db SL2 Database stuff enhancement
Projects
None yet
Development

No branches or pull requests

1 participant