Results 1 to 3 of 3

Thread: Install sqlite fts3

  1. #1
    Join Date
    Nov 2007
    Beans
    32
    Distro
    Ubuntu 13.04 Raring Ringtail

    Question Install sqlite fts3

    Hi all,

    I want to install sqlite fts3 to use it in a work for school... I found no tutorial how to install it, so can someone tell me how please ?

    ps: I only found tutos on installing sqlite only... I heard That it's the same method and I have to enable the full text mode, I don't know how :/

    Thanks in advance

  2. #2
    Join Date
    Aug 2010
    Location
    Lancs, United Kingdom
    Beans
    1,181
    Distro
    Xubuntu 14.04 Trusty Tahr

    Re: Install sqlite fts3

    Simply install the sqlite3 package. fts3 is a compile time extension that is already enabled in the Ubuntu package. Once installed, you can test it like this.
    Code:
    $ sqlite3 temp.sqlite
    SQLite version 3.7.9 2011-11-01 00:52:41
    Enter ".help" for instructions
    Enter SQL statements terminated with a ";"
    sqlite> CREATE VIRTUAL TABLE pages USING fts3(title, keywords, body);
    sqlite> .tables
    pages           pages_content   pages_segdir    pages_segments
    $
    For more information on fts3 see http://www.sqlite.org/fts3.html

  3. #3
    Join Date
    Nov 2007
    Beans
    32
    Distro
    Ubuntu 13.04 Raring Ringtail

    Re: Install sqlite fts3

    I've the same output as you

    Thanks mate

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •