Information on SQLite

SQLite replaced the BerkeleyDB in POPFile 0.21.0,

The SQLite page is here. The sqlite command line utility, pre-compiled for Windows, is available on the downloads page. It is not neccessary to also download the library since that is already included with the DBD::SQLite module.

Note that if you installed using the Windows Installer, you have everything you need already, including the SQLite commandline program.

DBD::SQLite 1.0 (released July 21, 2004) has a bug that prevents it from properly interpreting UNIX-style file paths when built and run under under cygwin.

v 0.21.0 Schema

Instructions for Installing DBD::SQLite

Note: The latest CVS Win installer will automatically install all required components. These instructions apply to non-Windows users or users who do not use the Win installer

DBD-SQLite and DBI

  1. Install the Perl Module, DBD::SQLite
    ppm
    >install DBD-SQLite
    >install DBI            (may already be present. required if not)
    >exit

Optional, but highly recommended:

alternatively,

  • you can download SQLiteCC (SQLite Control Center), which is a graphical version of the command line utility.

If you want to play with your corpus and don't know anything about SQL, try the SQL tutorial here: http://www.w3schools.com/sql/

 
sqlite.txt · Last modified: 2008/02/08 19:49 by 127.0.0.1

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