New port: databases/postgresql-orafce
The "orafce" is a module of PostgreSQL. It implements of some functions from
the Oracle database. The functionality was verified on Oracle 10g, and the
module is useful for production work. This module contains some useful function
which can help with porting Oracle application to PostgreSQL or can be useful
generally.
WWW: https://github.com/orafce/orafce
PR: 219616
Submitted by: Jov <amutu@amutu.com>

New port: databases/postgresql-zhparser
Zhparser is a PostgreSQL extension for full-text search of Chinese. It use
Simple Chinese Word Segmentation (SCWS) as driver and highly configurable and
easy to use. The default dictionary of Zhparser is for Simplified Chinese. If
you use Tranditional Chinese,you can download the dicionary from SCWS offical
site.
WWW: https://github.com/amutu/zhparser
PR: 219649
Submitted by: Jov <amutu@amutu.com>

New port: databases/postgresql-tds_fdw
Tds_fdw is a PostgreSQL foreign data wrapper that can connect to databases that
use the Tabular Data Stream (TDS) protocol, such as Sybase databases and
Microsoft SQL server. The current version does not yet support JOIN push-down,
or write operations. It does support WHERE and column pushdowns when
match_column_names is enabled.
WWW: https://github.com/tds-fdw/tds_fdw
PR: 219671
Submitted by: Jov <amutu@amutu.com>

New port: databases/pg_repack
Pg_repack is a PostgreSQL extension which lets you remove bloat from tables and
indexes, and optionally restore the physical order of clustered indexes. Unlike
CLUSTER and VACUUM FULL it works online, without holding an exclusive lock on
the processed tables during processing. pg_repack is efficient to boot, with
performance comparable to using CLUSTER directly.
WWW: https://github.com/reorg/pg_repack
PR: 219679
Submitted by: Jov <amutu@amutu.com>

New port: databases/pgFormatter
This SQL formatter/beautifier supports keywords from SQL-92, SQL-99,
SQL-2003, SQL-2008, SQL-2011 and PostgreSQL specifics keywords. May
works with any other databases too. pgFormatter can work as a console
program or as a CGI. It will automatically detect his environment and
output as text or as HTML following the context. Keywords highlighting
will only be available in CGI context.
WWW: https://github.com/darold/pgFormatter
PR: 219681
Submitted by: Jov <amutu@amutu.com>

- Add database/pldebugger
This module is a set of shared libraries which implement an API for
debugging pl/pgsql functions on PostgreSQL 8.4 and above.
WWW: https://git.postgresql.org/gitweb/?p=pldebugger.git;a=summary

Remove expired ports:
2017-06-15 databases/pgpool-II: Deprecated by upstream; use database/pgpool
instead
2017-06-15 databases/pgpool-II-30: Deprecated by upstream; use database/pgpool
instead
2017-06-18 games/libgames-support: Superseded by libgnome-games-support, no
longer used by anything
2017-06-22 net/sixxs-aiccu: SixXS shutdown on 2017-06-06,
https://www.sixxs.net/sunset/
databases/pgpoolAdmin: depended on expired databases/pgpool-II and only
supported PostgreSQL 9.2 which is will EOL in September 2017

Update the Calligra ports to 3.0.1.
The 3.x series is based on KDE Frameworks 5, and some programs have been split
into separate ports:
- Sheets, Words & co are in editors/calligra.
- Krita is in graphics/krita.
- Kexi is in databases/kexi.
- The calligra-l10n* ports are now part of editors/calligra itself.
Okular support in editors/calligra and Marble support in textproc/kreport have
been disabled for now because they need the KF5 version of those ports.
Thanks to everyone who's tested it and worked on it in our area51 repository.
Submitted by: Adrian de Groot <groot@kde.org>, tcberner, rakuco
Reviewed by: rakuco, mat (earlier versions)
Differential Revision: https://reviews.freebsd.org/D10167

New port: databases/postgresql-cstore_fdw
Cstore_fdw is a extension of PostgreSQL. This extension uses the Optimized Row
Columnar (ORC) format for its data layout. ORC improves upon the RCFile format
developed at Facebook, and brings the following benefits:
- Compression: Reduces in-memory and on-disk data size by 2-4x. Can be
extended to support different codecs.
- Column projections: Only reads column data relevant to the query.
Improves performance for I/O bound queries.
- Skip indexes: Stores min/max statistics for row groups, and uses them
to skip over unrelated rows.
Further, cstore_fdw used the Postgres foreign data wrapper APIs and type
representations with this extension. This brings:
- Support for 40+ Postgres data types. The user can also create new types
and use them.
- Statistics collection. PostgreSQL's query optimizer uses these stats to
evaluate different query plans and pick the best one.
- Simple setup. Create foreign table and copy data. Run SQL.
WWW: https://github.com/citusdata/cstore_fdw
PR: 219635
Submitted by: Jov <amutu@amutu.com>

Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL
compatible schema. It connects your Oracle database, scan it automatically
and extracts its structure or data, it then generates SQL scripts that you
can load into your PostgreSQL database. Ora2Pg can be used from reverse
engineering Oracle database to huge enterprise database migration or simply
to replicate some Oracle data into a PostgreSQL database. It is really easy
to used and doesn't need any Oracle database knowledge than providing the
parameters needed to connect to the Oracle database.
WWW: https://github.com/darold/ora2pg
PR: 219682
Submitted by: amutu@amutu.com

New port: databases/retcl
Retcl is an event-driven, object-oriented, Redis client library targetting the
Tcl scripting language. The library consists of a single Tcl Module file, which
makes it extremely easy to deploy or integrate into existing projects.
WWW: https://github.com/gahr/retcl

2017-04-30 devel/stormlib-ghost++: Unfetchable for more than six months (google
code has gone away)
2017-04-30 devel/py-coil: Unfetchable for more than six months (google code has
gone away)
2017-04-30 devel/py-cmdln: Unfetchable for more than six months (google code has
gone away)
2017-04-30 devel/privman: Unfetchable for more than six months (google code has
gone away)
2017-04-30 devel/c-unit: Unfetchable for more than six months (google code has
gone away)
2017-04-30 devel/py-px: Unfetchable for more than six months (google code has
gone away)
2017-04-30 devel/nglogc: Unfetchable for more than six months (google code has
gone away)
2017-04-30 devel/bncsutil-ghost++: Unfetchable for more than six months (google
code has gone away)
2017-04-30 devel/liblouisxml: Unfetchable for more than six months (google code
has gone away)
2017-04-30 devel/nxt-python: Unfetchable for more than six months (google code
has gone away)
2017-04-30 devel/spdict: Unfetchable for more than six months (google code has
gone away)
2017-04-30 devel/guiloader-c++: Unfetchable for more than six months (google
code has gone away)
2017-04-30 devel/streamhtmlparser: Unfetchable for more than six months (google
code has gone away)
2017-04-30 devel/winpdb: Unfetchable for more than six months (google code has
gone away)
2017-04-30 net/opendpi: Unfetchable for more than six months (google code has
gone away)

Varstack is a system that allows you to stack of layer a set of
configuration variables and let definitions in the higher more specific
levels of the stack override/extend the broader one in the lower levels.
Sponsored by: Absolight

New port, databases/rubygem-active_record_query_trace: Rails 3+ plugin to
log sources of SQL queries to Rails log
This port is being added because it is a dependency of the upcoming
net-im/mastodon port.
WWW: https://github.com/ruckus/active-record-query-trace/
Reviewed by: swills (mentor, implicit)

New port, databases/rubygem-pghero: A performance dashboard for Postgres
Adding this because it is a dependency of the upcoming www/mastodon port.
WWW: https://github.com/ankane/pghero/
Approved by: swills (mentor, implicit)

Add p5-Xapian 1.4.3.0
This module wraps most methods of most Xapian classes. The missing classes and
methods should be added in the future. It also provides a simplified, more
'perlish' interface - as demonstrated above.
The Xapian library is evolving very quickly at the time of writing, hence any
documentation placed here would be likely to become out of date quite rapidly,
and I do not have the patience to write some which could rapidly become
redundant.
WWW: https://xapian.org/

New port: databases/sqliteconvert
Sqliteconvert is a set of tools to convert SQLite3 schema files into
documentation. It includes sqlite2dot(1), which converts into a
graphviz file; sqlite2html(1), which converts into an HTML5 fragment;
and sqliteconvert(1), which pulls these tools together with some sane
default templates.
WWW: https://kristaps.bsd.lv/sqliteconvert/
Approved by: lme (mentor)
Differential Revision: https://reviews.freebsd.org/D9895

DBIx::Lite was written with some goals in mind, that no other
available module provides. Such goals/key features are:
no need to define your database schema (most features work without
one and some advanced features only require some bits, and still
not the full table definitions)
no need to connect to database: the module can just generate SQL
for you
chained methods with lazy SQL generation
joins/relationships
optional custom classes for results and resultsets with custom methods
SQL::Abstract syntax
paging features (with Data::Page)
WWW: http://search.cpan.org/dist/DBIx-Lite/

New port: databases/p5-File-Locate
File::Locate provides the locate() function that scans the locate
database for a given substring or POSIX regular expression. The
module can handle both plain old locate databases as well as the
more hip slocate format.
WWW: http://search.cpan.org/dist/File-Locate/

Welcome Percona 5.7 ports to the tree
- client and server version 5.7.16-10
- pam-for-mysql: compatible with newer MySQL API (MySQL 5.7+)
Thanks to all who have worked on Percona, MariaDB, and MySQL ports. Your
tireless efforts have been instrumental in making this port happen.
Differential Revision: https://reviews.freebsd.org/D8785

fakeredis is a pure python implementation of the redis-py python client that
simulates talking to a redis server. This was created for a single purpose:
to write unittests. Setting up redis is not hard, but many times you want to
write unittests that do not talk to an external server (such as redis). This
module now allows tests to simply use this module as a reasonable substitute
for redis.
WWW: https://github.com/jamesls/fakeredis

new port: databases/mysqldump-secure
Mysqldump-secure is a POSIX compliant open-source backup tool for MySQL
databases with strong security in mind. It will backup every available database
(which is readable by the specified user) as a separate file with the
possibility to opt out via blacklisting.
PR: 208032
Submitted by: jsmith@resonatingmedia.com
Reviewed by: matthew
Approved by: matthew (mentor)
Differential Revision: https://reviews.freebsd.org/D9001

- Add php70-memcache
Memcached is a caching daemon designed especially for dynamic web applications
to decrease database load by storing objects in memory. This extension allows
you to work with memcached through handy OO and procedural interfaces.
Note that this port uses unofficial development from
https://github.com/websupport-sk/pecl-memcache (NON_BLOCKING_IO_php7 branch).
WWW: https://pecl.php.net/package/memcache

- Add py-sqlalchemy11 1.1.4
The Python SQL Toolkit and Object Relational Mapper
SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that
gives application developers the full power and flexibility of SQL.
It provides a full suite of well known enterprise-level persistence
patterns, designed for efficient and high-performing database access,
adapted into a simple and Pythonic domain language.
WWW: http://www.sqlalchemy.org/