This is an old revision of the document!


SQLite command-line utility

(sqlite.exe)

Starting with POPfile version 0.21.0 release, POPFile uses a SQLite version 2.x database to store the POPfile corpus, magnets, and other data. POPFile's SQLite database is a single file, usually named 'popfile.db'.

The Windows version of POPFile comes with a simple command-line utility named sqlite.exe. The Windows POPFile installer creates a shortcut (“Run SQLite utility”) in the 'User Data' folder to make it easy to use the SQLite command-line utility. The utility runs in a Command Prompt window. You must type the necessary commands into this window to make the utility do anything. The Windows POPfile installer provides some user-friendly front-end utilities you can use rather than having to memorize all of the command syntax:

NOTE: Binary versions of the SQLite command-line utility for other platforms (as well as the source code, for those who wish to compile it themselves) is available on the SQLite download page.

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.

A tutorial showing how to use this utility is on the SQLite website. Unfortunately, the tutorial page has been updated to describe the sqlite3.exe utility, which is not compatible with POPFile's SQLite version 2.x database at this time.

If you want to know more about the POPFile-compatible version of the SQLite command-line utility, a tutorial based on old information from the SQLite web site, is available here.

CAUTION: Although the SQLite web site describes the SQLite command-line utility as a “simple” utility, it is actually very powerful. If you use it incorrectly, you could seriously damage the POPFile database, preventing POPFile from working properly.

 
howtos/sqlitecommandlineutility.1169465050.txt.gz · Last modified: 2008/02/08 19:49 (external edit)

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.

Recent changes RSS feed Donate Driven by DokuWiki
The content of this wiki is protected by the GNU Fee Documentation License