Re: [android-developers] Re: .db files being renamed to .back

2013-11-11 Thread Nathan
On Friday, November 8, 2013 3:31:50 PM UTC-8, Nobu Games wrote: > > The SQLite documentation says that the > maximum database file size is 2,147,483,646 pages > A single page can range from 512 to 65,536 bytes. So the minimum page size > configuration would yi

[android-developers] Re: .db files being renamed to .back

2013-11-09 Thread gjs
Hi, A strategy I use when the app is likely to collect a lot of (valuable) data & store it in an sqlite db is to also keep a log of each inserted row or transaction in separate files. In my case I create an additional xml file for each db transaction or table row, if the db file gets corrupted

Re: [android-developers] Re: .db files being renamed to .back

2013-11-08 Thread Nobu Games
The SQLite documentation says that the maximum database file size is 2,147,483,646 pages A single page can range from 512 to 65,536 bytes. So the minimum page size configuration would yield a maximum database file size of 1 TB. So something else is going wrong

Re: [android-developers] Re: .db files being renamed to .back

2013-11-08 Thread Nathan
On Friday, November 8, 2013 1:44:13 PM UTC-8, Steve Gabrilowitz wrote: > > Just a wild thought, the number of bytes in a 2GB database is also the 32 > bit maxint, could this be more than a coincidence? > It could very well be, and it is the subject of a previous thread by me: https://groups.go

Re: [android-developers] Re: .db files being renamed to .back

2013-11-08 Thread Steve Gabrilowitz
Just a wild thought, the number of bytes in a 2GB database is also the 32 bit maxint, could this be more than a coincidence? On Nov 8, 2013 2:49 PM, "Nathan" wrote: > > > On Thursday, November 7, 2013 10:58:03 PM UTC-8, gjs wrote: >> >> Hi, >> >> Ask the customer if he/she runs some sort of file

[android-developers] Re: .db files being renamed to .back

2013-11-08 Thread Nathan
On Thursday, November 7, 2013 10:58:03 PM UTC-8, gjs wrote: > > Hi, > > Ask the customer if he/she runs some sort of file back up / sync / virus > app & maybe ask them to rename the .back to .db & see if that fixes the > issue. > > The issue could be due to any number of things even arising

[android-developers] Re: .db files being renamed to .back

2013-11-07 Thread gjs
Hi, Ask the customer if he/she runs some sort of file back up / sync / virus app & maybe ask them to rename the .back to .db & see if that fixes the issue. The issue could be due to any number of things even arising from attempting to copy or sync files via a PC (blame Windows ;-) A general s

[android-developers] Re: .db files being renamed to .back

2013-11-07 Thread Nathan
No ideas? I'm completely lost. On Monday, October 28, 2013 4:04:19 PM UTC-7, Nathan wrote: > > Not that I have reproduced it here, but . .. > > Customer reports that some large db files were missing from storage and > were replaced by a .back file of the same approximate size. > > Nothing in m

[android-developers] Re: .db files being renamed to .back

2013-10-31 Thread Nathan
On Monday, October 28, 2013 4:04:19 PM UTC-7, Nathan wrote: > > Not that I have reproduced it here, but . .. > > Customer reports that some large db files were missing from storage and > were replaced by a .back file of the same approximate size. > > Nothing in my code ever renames a .db file