Numeric data type in SQLAlchemy

[psalvy]

Numeric data type in SQLAlchemy

[steve-federowicz]

There was no strong reason one way or the other. If you want to replace the numerics with floats I think that would be good.

[psalvy]

Thanks for the answer ! I feared there would be a compatibility issue or such ...
I will include this modification if I have a pull request in the future, I don't really like floating point conversions getting out of control..

[aebrahim]

To make numeric work in cobra, I would think all that would be required is
calling float() on the value put into the stoichiometry.

On Tue, Oct 28, 2014 at 5:47 PM, Pierre SALVY [email protected]
wrote:

Thanks for the answer ! I feared there would be a compatibility issue or
such ...
I will include this modification if I have a pull request in the future, I
don't really like floating point conversions getting out of control..

—
Reply to this email directly or view it on GitHub
#8 (comment).

[psalvy]

Of course, but the point was to avoid server-side floating-point conversion (no pun intended) when uploading a model, since Numeric more or less lets the choice to postgres.
Float columns work well so far.

[aebrahim]

Well in any case, as of opencobra/cobrapy@fe3e80f all solvers should work correctly with any numeric datatypes.