BSD Ports

databases/pg_similarity 20160917_2 DragonFly

Set of functions and operators for executing similarity queries

System
DragonFly
Repository
DPorts
Maintainer
[email protected] (as in FreeBSD)
License
BSD3CLAUSE
Categories
databases
Package size
28.7 KiB, 96.1 KiB installed

Description

pg_similarity is an extension to support similarity queries on PostgreSQL. The implementation is tightly integrated in the RDBMS in the sense that it defines operators so instead of the traditional operators (= and <>) you can use ~~~ and ! (any of these operators represents a similarity function).

pg_similarity has three main components:

* Functions: a set of functions that implements similarity algorithms available in the literature. These functions can be used as UDFs and, will be the base for implementing the similarity operators; * Operators: a set of operators defined at the top of similarity functions. They use similarity functions to obtain the similarity threshold and, compare its value to a user-defined threshold to decide if it is a match or not; * Session Variables: a set of variables that store similarity function parameters. Theses variables can be defined at run time.

In the other systems

SystemPortVersion
DragonFlydatabases/pg_similarity20160917_2
FreeBSDdatabases/pg_similarity20160917_2
HardenedBSDdatabases/pg_similarity20160917_2
GhostBSDdatabases/pg_similarity20160917_2

Install

Binary package:

pkg install postgresql13-pg_similarity

From DPorts:

cd /usr/dports/databases/pg_similarity && make install clean

Dependencies

Run dependencies 1

No port depends on this one.