fts5.rb

Bundler.require

book = Gutenberg::Book.new_from_txt 'data/pg11.txt'

db = Sequel.sqlite
db.run "CREATE VIRTUAL TABLE units USING fts5(content);"
units = db[:units]

db.transaction do
  book.each_with_index do |unit, index|
    units << { rowid: index, content: unit }
  end
end

#query = '"all their simple"'
query = '"that would be"'
limit = 3
db['SELECT rowid,* FROM units WHERE units MATCH ? LIMIT ?', query, limit].each do |row|
  p row
end

# units[rowid: 1]