I am writing an application to capture tweets (home_timeline) for an analysis - to check what my followers are reading, etc. I use the following DB structure to capture the max_id to use it in my next request:
db.define_table("MaxID", Field("max_id", type='integer', notnull=True), Field('modified_on', type='datetime', notnull=True, default=request.now)) The status_id of a tweet is 103502712657813505 In SQLite, and in GAE (both development and production), it is stored as long integer. In mySQL, the max_id field is translated as of type int(11)" and the signed value it could hold is between -2147483648 and 2147483647 and the unsigned is 4294967295. Hence when I try to store the value 103502712657813505, it will be stored 2147483647. One option could be - one could use string type and convert back and forth for max_id or update the Field type in MySQL. Since I encountered this problem, I thought I will bring this to the notice of everyone Is there a way to define BIGINT in DAL? Thanks Best Ram