This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
howtos:sqlitecommandlineutility [2009/03/08 13:30] – xuesheng | howtos:sqlitecommandlineutility [2009/03/10 15:54] – A minor clarification xuesheng | ||
---|---|---|---|
Line 7: | Line 7: | ||
The Windows version of POPFile comes with a simple SQLite command-line utility. The Windows POPFile installer creates a shortcut ("Run SQLite utility" | The Windows version of POPFile comes with a simple SQLite command-line utility. The Windows POPFile installer creates a shortcut ("Run SQLite utility" | ||
- | * POPFile SQLite Database Status Check utility | + | * [[/ |
- | * POPFile Run SQLite Utility | + | * [[/ |
SQLite 2.x and 3.x databases are not compatible therefore POPFile 1.1.0 (or later) will automatically upgrade an existing SQLite 2.x database to the new 3.x format (and save the old database as '' | SQLite 2.x and 3.x databases are not compatible therefore POPFile 1.1.0 (or later) will automatically upgrade an existing SQLite 2.x database to the new 3.x format (and save the old database as '' | ||
- | There are also two versions of the SQLite command-line utility: '' | + | There are two versions of the SQLite command-line utility: '' |
Two common uses for the SQLite command-line utility are: checking the integrity of an SQLite database, and defragmenting an SQLite database. The utility also allows advanced users to manually enter and execute SQL commands to manipulate an SQLite database. | Two common uses for the SQLite command-line utility are: checking the integrity of an SQLite database, and defragmenting an SQLite database. The utility also allows advanced users to manually enter and execute SQL commands to manipulate an SQLite database. | ||
Line 26: | Line 26: | ||
**NOTE**: Binary versions of the SQLite command-line utility which are compatible with SQLite 2.x format databases as used by POPFile 0.21.0 to 1.0.1 are no longer listed on the [[http:// | **NOTE**: Binary versions of the SQLite command-line utility which are compatible with SQLite 2.x format databases as used by POPFile 0.21.0 to 1.0.1 are no longer listed on the [[http:// | ||
- | If you want to know more about the POPFile-compatible | + | If you want to know more about the SQLite 2.x version of the SQLite command-line utility |
**CAUTION**: | **CAUTION**: |
Should you find anything in the documentation that is incomplete, unclear, outdated or just plain wrong, please let us know and leave a note in the Documentation Forum.