GitHub - illarionov/sqlite3-unicodesn: SQLite unicode full-text-search tokenizer with Snowball stemming

illarionov / sqlite3-unicodesn Public

Notifications You must be signed in to change notification settings
Fork 13
Star 34

SQLite unicode full-text-search tokenizer with Snowball stemming

34 stars 13 forks Branches Tags Activity

Notifications

Name		Name	Last commit message	Last commit date
Latest commit History 13 Commits
libstemmer_c		libstemmer_c
Makefile		Makefile
README		README
extension.c		extension.c
fts3Int.h		fts3Int.h
fts3_tokenizer.h		fts3_tokenizer.h
fts3_unicode2.c		fts3_unicode2.c
fts3_unicodesn.c		fts3_unicodesn.c
fts3_unicodesn.h		fts3_unicodesn.h
sqlite3_unicodesn_tokenizer.c		sqlite3_unicodesn_tokenizer.c
sqlite3_unicodesn_tokenizer.h		sqlite3_unicodesn_tokenizer.h

Repository files navigation

SQLite3-unicodesn
==============

SQLite "unicode" full-text-search tokenizer with Snowball stemming

Installation
============

   $ git clone git://github.com/littlesavage/sqlite3-unicodesn.git
   $ cd sqlite3-unicodesn
   $ make
   $ su
   # make install

Usage
======

    $ sqlite3
    sqlite> .load unicodesn.sqlext
    sqlite> CREATE VIRTUAL TABLE fts USING fts3(text, tokenize=unicodesn "stemmer=russian");
    sqlite> INSERT INTO fts VALUES ("Пионэры! Идите в жопу!");
    sqlite> SELECT * FROM fts WHERE text MATCH 'Жопа';
    Пионэры! Идите в жопу!

License
=======

Snowball files and stemmers are covered by the BSD license.

SQLite is in the Public Domain.

SQLite3-unicodesn code is in the Public Domain.