SQLite command-line utility

Trace:

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
Next revisionBoth sides next revision
howtos:sqlitecommandlineutility [2009/03/08 13:28] – Updated to mention SQLite 3.x and sqlite3.exe xueshenghowtos:sqlitecommandlineutility [2009/03/08 23:53] – Insert cross-reference links 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") 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: The Windows version of POPFile comes with a simple SQLite command-line utility. 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:
  
-  * POPFile SQLite Database Status Check utility +  * [[/docs/howtos:sqlitestatuscheck | POPFile SQLite Database Status Check utility]] 
-  * POPFile Run SQLite Utility+  * [[/docs/howtos:runsqlite | 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 ''popfile.db.backup''). There are also two versions of the SQLite command-line utility: ''sqlite3.exe'' works with SQLite 3.x format databases and ''sqlite.exe'' works with SQLite 2.x databases.+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 ''popfile.db.backup'').
  
-The shortcuts created by the Windows installer will automatically use the appropriate version of the SQLite command-line utility.+There are two versions of the SQLite command-line utility: ''sqlite3.exe'' works with SQLite 3.x format databases and ''sqlite.exe'' works with SQLite 2.x databases. The shortcuts created by the Windows installer will automatically use the appropriate version 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.
 
howtos/sqlitecommandlineutility.txt · Last modified: 2009/03/10 16:54 by 127.0.0.1
Old revisions

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