chazomaticus/sqlite3-unicodesn
Folders and files
| Name | Name | Last commit date | ||
|---|---|---|---|---|
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.