Documentation Source Text

Check-in [32f90bde6c]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Add FAQ #20.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 32f90bde6cc4ad4e208740e078648e497c0269ea
User & Date: drh 2009-01-26 14:15:36
Context
2009-01-29
19:28
Update the keyword list and description in the language documentation. CVSTrac ticket #3612. check-in: 561c52b85b user: drh tags: trunk
2009-01-26
14:15
Add FAQ #20. check-in: 32f90bde6c user: drh tags: trunk
14:06
Update the descriptions of download products. Tweaks to the HLR. check-in: 899c36f139 user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/faq.in.

485
486
487
488
489
490
491




















492
493
494
495
496
497
498
  so the time per insert statement is greatly reduced.

  <p>Another option is to run [PRAGMA synchronous=OFF].  This command will
  cause SQLite to not wait on data to reach the disk surface, which will make
  write operations appear to be much faster.  But if you lose power in the
  middle of a transaction, your database file might go corrupt.
}





















# End of questions and answers.
#############

hd_puts {<h2>Frequently Asked Questions</h2>}

hd_puts {<oL>}







>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>







485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
  so the time per insert statement is greatly reduced.

  <p>Another option is to run [PRAGMA synchronous=OFF].  This command will
  cause SQLite to not wait on data to reach the disk surface, which will make
  write operations appear to be much faster.  But if you lose power in the
  middle of a transaction, your database file might go corrupt.
}

faq {
  I accidently deleted some important information from my SQLite database.
  How can I recover it?
} {
  If you have a backup copy of your database file, recover the information
  from your backup.

  <p>If you do not have a backup, recovery is very difficult.  You might
  be able to find partial string data in a binary dump of the raw database
  file.  Recovering numeric data might also be possible given special tools,
  though to our knowledge no such tools exist.  SQLite is sometimes compiled
  with the [SQLITE_SECURE_DELETE] option which overwrites all deleted content
  with zeros.  If that is the case then recovery is clearly impossible.
  Recovery is also impossible if you have run [VACUUM] since the data was
  deleted.  If SQLITE_SECURE_DELETE is not used and VACUUM has not been run,
  then some of the deleted content might still be in the database file, in
  areas marked for reuse.  But, again, there exist no procedures or tools
  that we know of to help you recover that data.
}

# End of questions and answers.
#############

hd_puts {<h2>Frequently Asked Questions</h2>}

hd_puts {<oL>}