Re: [sqlalchemy] Emit INSERT query with float values reducing number of decimal digits

2018-03-05 Thread Mike Bayer
On Mon, Mar 5, 2018 at 10:42 AM, Ruben Di Battista wrote: > I have a table that is storing a huge amount of numerical details about my > application. I have huge INSERT queries (also millions of rows for each of > them) of float values that are made with core API, while

Re: [sqlalchemy] Emit INSERT query with float values reducing number of decimal digits

2018-03-05 Thread Ruben Di Battista
Thanks, I believe that precision keyword sets the Float type precision *on the DB. *The SQL query values still have lots of decimal digits. I believe the modification has to be done within Python/SQLAlchemy: the query string must be generated with a "less-precise" float number string. Basically I

Re: [sqlalchemy] Emit INSERT query with float values reducing number of decimal digits

2018-03-05 Thread Антонио Антуан
You can specify column precision пн, 5 мар. 2018 г. в 18:42, Ruben Di Battista : > I have a table that is storing a huge amount of numerical details about my > application. I

[sqlalchemy] Emit INSERT query with float values reducing number of decimal digits

2018-03-05 Thread Ruben Di Battista
I have a table that is storing a huge amount of numerical details about my application. I have huge INSERT queries (also millions of rows for each of them) of float values that are made with core API, while the rest of application logic is ORM. The precision I need on each float is not big,