Long integer values are changed by pandas SQLite driver database using to_sql
See

http://stackoverflow.com/questions/24416140/long-integer-values-in-pandas-dataframe-change-when-sent-to-sqlite-database-usin?noredirect=1#comment37772983_24416140

I am using pandas to organize and manipulate data I am getting from the twitter API. The 'id' key returns a very long integer (int64) that pandas has no problem handling (i.e. 481496718320496643).

However, when I send to SQL:

df.to_sql('Tweets', conn, flavor='sqlite', if_exists='append', index=False)

I now have tweet id: 481496718320496640 or something close to that number.

I converted the tweet id to str but Pandas SQLite Driver / SQLite still messes with the number. The data type in the SQLite database is [tweet_id] INTEGER. This seems to be an issue.
