On Friday, November 8, 2013 3:31:50 PM UTC-8, Nobu Games wrote:
The SQLite documentation http://www.sqlite.org/limits.htmlsays 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
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
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 from
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 nathan.d.mel...@gmail.com wrote:
On Thursday, November 7, 2013 10:58:03 PM UTC-8, gjs wrote:
Hi,
Ask the customer if he/she runs some
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:
The SQLite documentation http://www.sqlite.org/limits.htmlsays 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
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 my code
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
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 to a
9 matches
Mail list logo