Re: How big an integer in SQLite?

Thanks Gerhard. I think this will work fine for what I am doing. Thanks.

Gerhard Häring wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> David Pratt wrote:
>> I am used to using a bigint type in postgres in some cases for table 
>> creation. I assume sqlite doesn't care how big the integer gets for an 
>> id. Is this true? [...]
> 
> SQLite's integer storage class is limited. It will use the platform's "long
> long" C type if it has it. This is a 64-bit signed type on your typical x86
> box. I've run the attached example script on my Ubuntu x86 and it resulted
> in a maximum of 4611686018427387904 (2**62). After that, arithmetics get
> out of hand (integer overflow producing negative number, then always zeros).
> 
> For larger numbers, you will have to use SQLite's float type.
> 
> - -- Gerhard
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.1 (GNU/Linux)
> Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
> 
> iD8DBQFEVhDtdIO4ozGCH14RAgmlAKCUbuRL0XN36XYH+RBu4Ajt/APiLACgkeeS
> OBoFUB4rg5PS9OdXmv1tCeM=
> =YGJJ
> -----END PGP SIGNATURE-----
> 
> 
> ------------------------------------------------------------------------
> 
> from pysqlite2 import dbapi2 as sqlite
> con = sqlite.connect(":memory:")
> cur = con.cursor()
> cur.execute("create table test(x)")
> cur.execute("insert into test(x) values (2)")
> 
> while True:
>     cur.execute("update test set x=x*2")
>     cur.execute("select x from test")
>     result = cur.fetchone()[0]
>     if result == 0:
>         break
>     print result, type(result)
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> pysqlite mailing list
> pysqlite-IAPFreCvJWPBWskQ1e/+sw@xxxxxxxxxxxxxxxx
> http://lists.initd.org/mailman/listinfo/pysqlite