Skip to content
/ fzql Public

fzql: Fuzzily full-text search an sqlite database

8 stars 0 forks Branches Tags Activity
Star
Notifications You must be signed in to change notification settings

benewberg/fzql

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

5 Commits
pics
pics
 
 
README.md
README.md
 
 
fzql
fzql
 
 

Repository files navigation

fzql

Fuzzily full-text search an sqlite database

What it does:

Simple bash script which pipes sqlite3's output to fzf and takes advantage of fzf's ability to fuzzy search the results.

Advantages over sqlite3's excellent FTS virtual tables:

  • No need to have the FTS tables established, just perform an ad-hoc full-text search on query results
  • Perform a fuzzy search

Dependencies:

  1. fzf
  2. sqlite3 (make sure both are in your PATH)

Example Usage:

fzql my_database "select * from my_table;"

Use case: search a database of zip code information for "Springfield"

Assume we don't know all of the field names, or perhaps more than one field may contain this value

Step 1: Specify the database location and the query:

Step 2: Enter fuzzy search information (note that the header will be shown at all times)

Step 3: (Optional) Select multiple rows using the Tab key

Step 4: Hit the Enter key to display the result (note that the header will also be displayed)

About

fzql: Fuzzily full-text search an sqlite database

Resources

Readme
Activity

Stars

8 stars

Watchers

1 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

No packages published

Languages