From owner-svn-ports-head@freebsd.org Sat Jul 28 14:57:54 2018 Return-Path: Delivered-To: svn-ports-head@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 71FB01054594; Sat, 28 Jul 2018 14:57:54 +0000 (UTC) (envelope-from miwi@FreeBSD.org) Received: from mxrelay.nyi.freebsd.org (mxrelay.nyi.freebsd.org [IPv6:2610:1c1:1:606c::19:3]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client CN "mxrelay.nyi.freebsd.org", Issuer "Let's Encrypt Authority X3" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 1B5B1725C6; Sat, 28 Jul 2018 14:57:54 +0000 (UTC) (envelope-from miwi@FreeBSD.org) Received: from repo.freebsd.org (repo.freebsd.org [IPv6:2610:1c1:1:6068::e6a:0]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mxrelay.nyi.freebsd.org (Postfix) with ESMTPS id EB12A2DC; Sat, 28 Jul 2018 14:57:53 +0000 (UTC) (envelope-from miwi@FreeBSD.org) Received: from repo.freebsd.org ([127.0.1.37]) by repo.freebsd.org (8.15.2/8.15.2) with ESMTP id w6SEvrN5060680; Sat, 28 Jul 2018 14:57:53 GMT (envelope-from miwi@FreeBSD.org) Received: (from miwi@localhost) by repo.freebsd.org (8.15.2/8.15.2/Submit) id w6SEvrSu060677; Sat, 28 Jul 2018 14:57:53 GMT (envelope-from miwi@FreeBSD.org) Message-Id: <201807281457.w6SEvrSu060677@repo.freebsd.org> X-Authentication-Warning: repo.freebsd.org: miwi set sender to miwi@FreeBSD.org using -f From: Martin Wilke Date: Sat, 28 Jul 2018 14:57:53 +0000 (UTC) To: ports-committers@freebsd.org, svn-ports-all@freebsd.org, svn-ports-head@freebsd.org Subject: svn commit: r475583 - in head/databases: . pg_similarity X-SVN-Group: ports-head X-SVN-Commit-Author: miwi X-SVN-Commit-Paths: in head/databases: . pg_similarity X-SVN-Commit-Revision: 475583 X-SVN-Commit-Repository: ports MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-BeenThere: svn-ports-head@freebsd.org X-Mailman-Version: 2.1.27 Precedence: list List-Id: SVN commit messages for the ports tree for head List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 28 Jul 2018 14:57:54 -0000 Author: miwi Date: Sat Jul 28 14:57:52 2018 New Revision: 475583 URL: https://svnweb.freebsd.org/changeset/ports/475583 Log: 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. WWW: http://pgsimilarity.projects.pgfoundry.org PR: 220428 Submitted by: Jov Sponsored by: iXsystems Inc. Added: head/databases/pg_similarity/ head/databases/pg_similarity/Makefile (contents, props changed) head/databases/pg_similarity/distinfo (contents, props changed) head/databases/pg_similarity/pkg-descr (contents, props changed) Modified: head/databases/Makefile Modified: head/databases/Makefile ============================================================================== --- head/databases/Makefile Sat Jul 28 14:55:21 2018 (r475582) +++ head/databases/Makefile Sat Jul 28 14:57:52 2018 (r475583) @@ -590,6 +590,7 @@ SUBDIR += pg_qualstats SUBDIR += pg_reorg SUBDIR += pg_repack + SUBDIR += pg_similarity SUBDIR += pg_stat_kcache SUBDIR += pgaccess SUBDIR += pgadmin3 Added: head/databases/pg_similarity/Makefile ============================================================================== --- /dev/null 00:00:00 1970 (empty, because file is newly added) +++ head/databases/pg_similarity/Makefile Sat Jul 28 14:57:52 2018 (r475583) @@ -0,0 +1,32 @@ +# Created by: Jov +# $FreeBSD$ + +PORTNAME= pg_similarity +PORTVERSION= 20160917 +CATEGORIES= databases +PKGNAMEPREFIX= postgresql${PGSQL_VER:S/.//}- + +MAINTAINER= amutu@amutu.com +COMMENT= Set of functions and operators for executing similarity queries + +LICENSE= BSD3CLAUSE + +USES= gmake pgsql:9.1+ +USE_GITHUB= yes +GH_ACCOUNT= eulerto +GH_TAGNAME= be1a8b0 + +MAKE_ENV= USE_PGXS=1 + +WANT_PGSQL= server + +PLIST_FILES= lib/postgresql/pg_similarity.so \ + share/postgresql/extension/pg_similarity--1.0.sql \ + share/postgresql/extension/pg_similarity--unpackaged--1.0.sql \ + share/postgresql/extension/pg_similarity.control \ + share/postgresql/extension/pg_similarity.sql + +post-install: + ${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/postgresql/pg_similarity.so + +.include Added: head/databases/pg_similarity/distinfo ============================================================================== --- /dev/null 00:00:00 1970 (empty, because file is newly added) +++ head/databases/pg_similarity/distinfo Sat Jul 28 14:57:52 2018 (r475583) @@ -0,0 +1,3 @@ +TIMESTAMP = 1498975894 +SHA256 (eulerto-pg_similarity-20160917-be1a8b0_GH0.tar.gz) = 6c990a211c6bc9f477fd401f5ecce102743b3e4811db73c233cdc79cc187ace9 +SIZE (eulerto-pg_similarity-20160917-be1a8b0_GH0.tar.gz) = 57627 Added: head/databases/pg_similarity/pkg-descr ============================================================================== --- /dev/null 00:00:00 1970 (empty, because file is newly added) +++ head/databases/pg_similarity/pkg-descr Sat Jul 28 14:57:52 2018 (r475583) @@ -0,0 +1,17 @@ +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. + +WWW: http://pgsimilarity.projects.pgfoundry.org