On 21 Apr 2011, at 12:03am, Donald Griggs wrote: > The video mentions that the file "consolidated.db" is an ordinary sqlite > file, containing latitude, longitude, and timestamps. The data they > examined went back several months. > > http://radar.oreilly.com/2011/04/apple-location-tracking.html > > There's no allegation the data is *transmitted* to Apple or anyone else, but > this is intriguing nonetheless.
SQLite is not really related to this, other than the data is held in an SQLite database file, as is almost all database-suitable data (rows and columns) in an iPhone. Technically, the data referred to is as follows. An iPhone logs details of which phone base stations it connects to, and the 'status' data obtained from the base station when it was connected. The location (long & lat) of the base station is part of the base station's status string. That is all. Many phones for many manufacturers do this: it's a vital part of the information used when looking at poor signal strengths and dropped calls. I am not at all surprised that this data is collected, since it's invaluable when diagnosing problems with the phone functions. What surprises me is that entries in that database are not deleted after, say, a month. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
