pg_fzy

FZY extension for PostgreSQL. You can either use the pre-compiled binaries, or build from source.

Pre-compiled binaries

Pre-compiled binaries are available for the following systems:

• Linux x86_64, Postgres: 11, 12, 13
• macOS x86_64, Postgres: 13

To make use of it, run:

make restore_precompiled_binary

Building

Requires postgresql development headers.

Linux

Install headers through your package manager.
Ubuntu: sudo apt install postgresql-server-dev-XX

macOS

brew: brew install libpq

make

Installation

sudo make install

Requires pg_config to be installed.

psql> CREATE EXTENSION fzy;

Usage

select name, fzy('Stev', "name"::cstring) as score from users;

Uses the case-insensitive version of fzy for now. Open an issue if you need the case sensitive version.

License

MIT