#sqlite-extension #sqlite #tokenizer #extension #temporary-files #fts5

libsimple

Rust bindings to simple, a SQLite3 fts5 tokenizer which supports Chinese and PinYin

8 releases

0.3.4 Oct 6, 2024
0.3.3 Sep 13, 2024
0.3.1 Jul 25, 2024
0.3.0 May 20, 2024
0.1.0 Apr 15, 2024

#787 in Database interfaces

49 downloads per month

MIT license

13MB
180K SLoC

C 178K SLoC // 0.2% comments C++ 1K SLoC // 0.1% comments Rust 118 SLoC

libsimple

Crate GitHub last commit GitHub issues GitHub pull requests GitHub

Description

Rust bindings to simple, a SQLite3 fts5 tokenizer which supports Chinese and PinYin.

Usage

Add this to your Cargo.toml:

[dependencies]
libsimple = "~0.3"

Example

use anyhow::Result;
use tempfile::tempdir;

fn main() -> Result<()> {
    libsimple::enable_auto_extension()?;
    let dir = tempdir()?;
    libsimple::release_dict(&dir)?;
    
    let conn = rusqlite::Connection::open_in_memory()?;
    libsimple::set_dict(&conn, &dir)?;
    
    conn.execute_batch("
        CREATE VIRTUAL TABLE d USING fts5(id, text, tokenize = 'simple');
        INSERT INTO d (id, text) VALUES (1, '中华人民共和国国歌');
        INSERT INTO d (id, text) VALUES (2, '周杰伦');
    ")?;
    assert_eq!(1, conn.query_row(
        "SELECT id FROM d WHERE text MATCH jieba_query('中华国歌')",
        [], |row| row.get::<_, i64>(0)
    )?);
    assert_eq!(2, conn.query_row(
        "SELECT id FROM d WHERE text MATCH simple_query('zhoujiel')",
        [], |row| row.get::<_, i64>(0)
    )?);
    Ok(())
}

License

Licensed under MIT license (LICENSE or http://opensource.org/licenses/MIT)

Version map

This is the compatible version map between libsimple and rusqlite:

libsimple version rusqlite version
=0.3.4 ~0.32
=0.3.3 ~0.32
=0.3.2 ~0.32
=0.3.1 ~0.32
=0.3.0 ~0.31
=0.2.2 ~0.31
=0.2.1 ~0.31
=0.2.0 ~0.31
=0.1.0 ~0.31

Dependencies

~22MB
~429K SLoC