By default sqlite3 is fairly safe, so when you change a pragma
ensure that you are not disabling a safety feature.
To get an idea, check this thread where I had the opposite need
(more speed, less safety)
http://sqlite.1065341.n5.nabble.com/What-pragma-to-use-to-get-maximum-speed-at-expense-of-saf
Thanks for answer.
I can do integrity check by PRAGMA integrity_check.Please correct me if i
wrong.
Here backup means copying database file OR we can create query to SQLite
for backup or copy.
Cheers-
Techi
On Wed, Jul 17, 2013 at 4:42 PM, Paolo Bolzoni <
paolo.bolzoni.br...@gmail.com> wrote:
On Wed, Jul 17, 2013 at 12:55 PM, techi eth wrote:
> 2) How do we make database safe from these error Or What is Possibility
> to
> access database after error.
After error, as Stephan said you are out of luck.
You should avoid this errors in the first place:
- make backup often,
- keep the
On Wed, Jul 17, 2013 at 12:55 PM, techi eth wrote:
> Hi,
>
> I have question on SQLITE_CORRUPT, SQLITE_IOERR occur during database
> access.
>
> Question
>
> 1) How to get generated this kind of error for testing.
>
While your application has the db opened, use a tool of your choice to
over
Hi,
I have question on SQLITE_CORRUPT, SQLITE_IOERR occur during database
access.
Question
1) How to get generated this kind of error for testing.
2) How do we make database safe from these error Or What is Possibility to
access database after error.
Cheers-
Techi
__
5 matches
Mail list logo
