Re: [Chicken-users] Big integers as statement parameters in sql-de-lite

2013-07-22 Thread Jim Ursetto
It's not that the values are too large, it's that srfi 19 represents them as bignums, which is not currently supported by sql-de-lite. However, they work as floats (they will be converted to integers before being passed to the database, due to the column type). Even on 32-bit systems, we fully

Re: [Chicken-users] Big integers as statement parameters in sql-de-lite

2013-07-22 Thread Matt Gushee
Hi, Kon-- On Mon, Jul 22, 2013 at 4:34 PM, Kon Lovett wrote: > Do you need the range a SRFI-19 datetime provides? Maybe an epoch based > approach, like provided by the posix module. No, I don't need the range. In fact, my project is a lightweight blogging platform, and the date-times in questi

Re: [Chicken-users] Big integers as statement parameters in sql-de-lite

2013-07-22 Thread Kon Lovett
On Jul 22, 2013, at 3:26 PM, Matt Gushee wrote: > Hi, chickenists-- > > I am working on an application that stores data in a SQLite3 database, > and am currently using the sql-de-lite egg to interface with the DB. I > have a few fields that represent dates, and I have defined their > datatype a

[Chicken-users] Big integers as statement parameters in sql-de-lite

2013-07-22 Thread Matt Gushee
Hi, chickenists-- I am working on an application that stores data in a SQLite3 database, and am currently using the sql-de-lite egg to interface with the DB. I have a few fields that represent dates, and I have defined their datatype as INTEGER. However, when I attempt to execute a statement such