<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">I have seen only 2 scenarios, which corrupt Valentina databases.<br><br>1. A rare bug when writing big amounts of data to a database.<br>2. The user does the 3 finger salute during writing.<br><br>Nothing really can happen when you use flush often.<br><br>As far as I understand databases threads aren't really a good idea for single-user databases. For this you should use a server, which is multi-threaded by default.<br><br><a href="mailto:valentina-bounces+bwillius=gmx.de@galileo.macserve.net">valentina-bounces+bwillius=gmx.de@galileo.macserve.net</a> schrieb am 03.01.2011 18:55:29:<br><br><blockquote type="cite">I guess a more pressing question (since I have a backup of the <br></blockquote><blockquote type="cite">database and am not worried about lost data) is: How do I prevent <br></blockquote><blockquote type="cite">this from happening in the future. I'm looking at migrating our <br></blockquote><blockquote type="cite">product to Valentina... but not with this being a possibility. I can<br></blockquote><blockquote type="cite">honestly say that I've never had this problem with SQLite in over 3 <br></blockquote><blockquote type="cite">years. In under 3 weeks of using Valentina I already have one <br></blockquote><blockquote type="cite">database corrupted (apparently) beyond recovery. I absolutely love <br></blockquote><blockquote type="cite">how Valentina works, especially its speed. But is there a Best <br></blockquote><blockquote type="cite">Practices approach to ensure this doesn't happen?<br></blockquote><blockquote type="cite"><br></blockquote><br>Regards<br><div>
<span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; ">Mit freundlichen Grüßen/Regards<br><br>Trixi Willius<br><br><a href="http://www.mothsoftware.com">http://www.mothsoftware.com</a><br>Mail Archiver X: archive, clean and search email<br>http://www.beatrixwillius.de<br>Fractals, 3d landscapes etc.</span>
</div>
<br></body></html>