This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
howtos:sqlitecommandlineutility [2007/01/18 10:04] – xuesheng | howtos:sqlitecommandlineutility [2009/03/10 16:54] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
====== SQLite command-line utility ====== | ====== SQLite command-line utility ====== | ||
- | ==== (sqlite.exe) ==== | ||
- | Starting with the 0.21.0 release POPFile uses a SQLite 2.x database to store the corpus, the magnets and other data. POPFile' | + | ==== Introduction ==== |
- | **Although | + | Starting with POPFile version 0.21.0, POPFile uses a SQLite database to store the POPFile corpus, magnets and other data. POPFile' |
- | The POPFile installer creates a shortcut ("Run SQLite utility" | + | The Windows version of POPFile comes with a simple SQLite command-line utility. The Windows |
- | * [[howtos:SQLiteStatusCheck|POPFile SQLite Database Status Check utility]] | + | * [[/docs/howtos:sqlitestatuscheck |
- | * [[howtos:RunSQLite|POPFile Run SQLite Utility]] | + | * [[/docs/howtos:runsqlite |
- | The sqlite.exe command-line utility allows advanced users to manually enter and execute SQL commands against an SQLite database. A brief [[http:// | + | 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 |
- | **Be very careful if you decide to use this utility - a simple mistake made while using it could stop POPFile from working.** | + | There are two versions of the SQLite command-line |
+ | 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. | ||
+ | |||
+ | ==== sqlite3.exe (for use with POPFile 1.1.0 or later) ==== | ||
+ | |||
+ | A [[http:// | ||
+ | |||
+ | **CAUTION**: | ||
+ | |||
+ | ==== sqlite.exe (for use with POPFile 0.21.0 to 1.0.1) ==== | ||
+ | |||
+ | **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 SQLite 2.x version of the SQLite command-line utility used by POPFile releases 0.21.0 to 1.0.1, a tutorial based on old information from the SQLite web site, is available [[sqlite_tutorial | here]]. | ||
+ | |||
+ | **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.