svn commit: r475583 - in head/databases: . pg_similarity

[Martin Wilke]

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 <amutu at amutu.com>
  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 <amutu at amutu.com>
+# $FreeBSD$
+
+PORTNAME=	pg_similarity
+PORTVERSION=	20160917
+CATEGORIES=	databases
+PKGNAMEPREFIX=	postgresql${PGSQL_VER:S/.//}-
+
+MAINTAINER=	amutu at 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 <bsd.port.mk>

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