Re: handling inconsistent Database files

Wes Hardaker <[email protected]>
Newsgroups gmane.network.net-snmp.user
Organization Sparta
Message-ID <[email protected]>
>>>>> On Thu, 27 May 2010 14:19:19 +0530, Vinod Nanjaiah <[email protected]> said:

VN> Are there any strategies in sqlite for avoiding Databases getting
VN> into an inconsistent state due to an application crash, system
VN> crash, etc.

VN> One scenario could be that my application is writing onto a DB file
VN> when the application crashes.  When the application comes up next,
VN> it would most likely find the DB in an inconsistent state.  Is there
VN> a way to overcome such problems?

What DB are you talking about?

Generically, the best solution for things like that is to write to a new
file and after you're done writing, rename it on-top of the old one.
-- 
Wes Hardaker
Cobham Analytic Solutions

------------------------------------------------------------------------------

_______________________________________________
Net-snmp-users mailing list
[email protected]
Please see the following page to unsubscribe or change other options:
https://lists.sourceforge.net/lists/listinfo/net-snmp-users
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.