• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Oh dearie me
#16
As a side note, I've heard multiple reports now of database problems due to the companion app, and I believe it may be due to the way I'm copying the database file from the PC to the tablet. I think what I'm currently doing is inherently unsafe. SQLite uses some advanced techniques to prevent database corruption, including the use of a journal file, which can delay when data that has been written to the database is actually present in the database file (transactions all go through the journal file first). I think it's possible for the companion to be sending the bytes of the database file when the file isn't in a proper state for that to be done. I'm going to try changing the companion app to use the SQLite backup api to create a copy of the database that is safe to send to the tablet. I will probably also change the tablet to clear out any journal file that is present if I replace the database, as I think having an invalid journal file present could also cause problems. I will also be working on adding more protection against possible disconnects while file transfers are still active.

Mike
Reply


Messages In This Thread
Oh dearie me - by GraemeJ - 05-16-2015, 12:09 PM
RE: Oh dearie me - by Zubersoft - 05-16-2015, 03:24 PM
RE: Oh dearie me - by GraemeJ - 05-16-2015, 06:39 PM
Oh dearie me - by Rey_a - 05-16-2015, 05:53 PM
RE: Oh dearie me - by sciurius - 05-16-2015, 05:56 PM
RE: Oh dearie me - by GraemeJ - 05-16-2015, 06:44 PM
RE: Oh dearie me - by bumblebee - 05-16-2015, 06:17 PM
RE: Oh dearie me - by sciurius - 05-16-2015, 07:08 PM
RE: Oh dearie me - by GraemeJ - 05-16-2015, 08:24 PM
RE: Oh dearie me - by sciurius - 05-17-2015, 05:15 AM
RE: Oh dearie me - by GraemeJ - 05-16-2015, 08:20 PM
RE: Oh dearie me - by bumblebee - 05-16-2015, 08:31 PM
RE: Oh dearie me - by sciurius - 05-16-2015, 09:27 PM
RE: Oh dearie me - by itsme - 05-16-2015, 09:50 PM
RE: Oh dearie me - by Zubersoft - 05-17-2015, 03:15 PM
RE: Oh dearie me - by sciurius - 05-18-2015, 12:05 AM
RE: Oh dearie me - by Zubersoft - 05-17-2015, 04:14 PM
RE: Oh dearie me - by sciurius - 05-17-2015, 11:56 PM
RE: Oh dearie me - by GraemeJ - 05-17-2015, 06:35 PM
RE: Oh dearie me - by Zubersoft - 05-20-2015, 07:34 AM
RE: Oh dearie me - by sciurius - 05-20-2015, 08:35 AM
RE: Oh dearie me - by GraemeJ - 05-20-2015, 08:42 AM
RE: Oh dearie me - by sciurius - 05-20-2015, 04:31 PM
RE: Oh dearie me - by sciurius - 05-21-2015, 01:25 AM
RE: Oh dearie me - by itsme - 05-21-2015, 07:31 AM
RE: Oh dearie me - by Zubersoft - 05-21-2015, 05:21 PM
RE: Oh dearie me - by sciurius - 05-21-2015, 05:45 PM



Users browsing this thread:
2 Guest(s)


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2024 MyBB Group.