- Repocopy pgpool-II-2.2.6 (maintenance branch) to
databases/pgpool-II-22 and upgrade databases/pgpool-II to 2.3.
- Record $CONFLICTS each other.
Please note upgrade from 2.2.6 to 2.3 causes small incompatibility
(read NEWS file in distribution).
The PyMongo distribution contains tools for interacting with
the Mongo database from Python. The pymongo package is a native
Python driver for the Mongo database. The gridfs package is a
gridfs implementation on top of pymongo.
WWW: http://github.com/mongodb/mongo-python-driver
Mongo (from "humongous") is a high-performance, open source,
schema-free, document-oriented database. A common name in the
"NOSQL" community.
WWW: http://www.mongodb.org/
PR: ports/140257 [1]
ports/140144 [2]
ports/140489 [2]
Submitted by: Ivan Voras <ivoras@FreeBSD.org> [1]
Mirko Zinn <mail@derzinn.de> [2]
Mongo (from "humongous") is a high-performance, open source,
schema-free, document-oriented database. A common name in the
"NOSQL" community.
WWW: http://www.mongodb.org/
PR: ports/140144 [1]
ports/140257 [2]
ports/140489 [1]
Submitted by: Mirko Zinn <mail@derzinn.de> [1]
Ivan Voras <ivoras@FreeBSD.org> [2]
A Ruby interface to the PostgreSQL Relational Database Management System.
The 'pg' module is the newer module, that has been greatly improved, and
is almost a complete rewrite. It is not backwards compatible. Use this module
for newly written code. It should be more stable, less buggy, and has more
features.
LICENSE: BSD or GPL2
WWW: http://rubyforge.org/projects/ruby-pg/
Add Berkeley DB 4.8 to the ports tree as a "regular" port for now.
Once FreeBSD 8.0 ships, I'll update all the USE knobs that are
necessary to allow other ports to make use of this port.
PR: ports/138831
Submitted by: Gea-Suan Lin <gslin@gslin.org>
Approved by: portmgr@
Rose::DBx::Object::Renderer generates web UIs for Rose::DB::Object.
It encapsulates many web conventions in the generated UIs as default
behaviours. For example, email addresses are by default rendered as
mailto links in tables and appropiate validation is enforced
automatically in forms. These behaviours are highly extensible.
Renderer uses CGI::FormBuilder to generate forms and the Google Chart
API to render charts. Template::Toolkit is used for template processing,
however, Renderer can dynamically generate a full set of UIs without
any templates.
WWW: http://search.cpan.org/dist/Rose-DBx-Object-Renderer
Doctrine is an object relational mapper (ORM) for PHP 5.2.3+ that
sits on top of a powerful database abstraction layer (DBAL).
One of its key features is the option to write database queries in a
proprietary object oriented SQL dialect called Doctrine Query
Language (DQL), inspired by Hibernate's HQL. This provides developers
with a powerful alternative to SQL that maintains flexibility without
requiring unnecessary code duplication.
WWW: http://www.doctrine-project.org/
Feature safe: yes
This library will provide the ipv4 ISINNET, IP2INT, INT2IP,
NETFROM, NETLENGTH, NETMASKLENGTH functions in SQL queries.
WWW: http://mobigroup.ru/files/sqlite-ext/inet/
PR: ports/137295
Submitted by: Pavel Volkov <pol at iib.ru>
Google contacts and calendar akonadi resource. It allows syncing your calendar
and contacts with your google account.
WWW: http://code.google.com/p/libgcal/
PR: ports/137996
Submitted by: Troels Kofoed Jacobsen <tkjacobsen at gmail.com>
pg_filedump is a utility to format PostgreSQL heap, index, and control
files into a human-readable form. You can format/dump the files
several ways as well as dumping straight binary. This utility is
intended to aid in the understanding of the internal contents of a
PostgreSQL block.
WWW: http://sources.redhat.com/rhdb/utilities.html
Cassandra is a highly scalable, eventually consistent, distributed,
structured key-value store. Cassandra brings together the distributed
systems technologies from Dynamo and the data model from Google's
BigTable. Like Dynamo, Cassandra is eventually consistent. Like
BigTable, Cassandra provides a ColumnFamily-based data model richer
than typical key/value systems.
Cassandra was open sourced by Facebook in 2008, where it was designed
by one of the authors of Amazon's Dynamo. In a lot of ways you can
think of Cassandra as Dynamo 2.0. Cassandra is in production use at
Facebook but is still under heavy development.
WWW: http://incubator.apache.org/cassandra/
PR: ports/137477
Submitted by: Gea-Suan Lin <gslin at gslin.org>
This is South, intelligent schema migrations for Django apps.
South is:
* Intelligent; it knows if you've missed out a migration or two
* Database independent, so there's no hassle if you need to move databases.
* Easy; it can write migrations for you, and it takes about a minute to
convert your app over to use South.
* Designed for a pluggable Django world; you can declare dependencies
between apps so they all migrate together correctly, and you can still
use syncdb for your non-migrated apps without it interfering.
* Useful for data too; you can write migrations to transform legacy data.
* Better (we think, anyway) than the alternatives.
WWW: http://south.aeracode.org/
PR: ports/137234
Submitted by: Stanislav Svirid <count at 211.ru>
MySQL Workbench is a cross-platform, visual database design tool developed
by MySQL. It is the highly anticipated successor application of the
DBDesigner4 project.
5.2 branch still in Alpha stage
WWW: http://dev.mysql.com/workbench/
PR: ports/136088 (part 2 of 2)
Submitted by: Maxim Ignatenko
MySQL Workbench is a cross-platform, visual database design tool developed
by MySQL. It is the highly anticipated successor application of the
DBDesigner4 project.
WWW: http://dev.mysql.com/workbench/
PR: ports/136088 (part 1 of 2)
Submitted by: Maxim Ignatenko
Welcome PostgreSQL 8.4
After many years of development, PostgreSQL has become feature-complete in many
areas.
This release shows a targeted approach to adding features (e.g., authentication,
monitoring, space reuse), and adds capabilities defined in the later SQL
standards.
The major areas of enhancement are:
Windowing Functions
Common Table Expressions and Recursive Queries
Default and variadic parameters for functions
Parallel Restore
Column Permissions
Per-database locale settings
Improved hash indexes
Improved join performance for EXISTS and NOT EXISTS queries
Easier-to-use Warm Standby
Automatic sizing of the Free Space Map
Visibility Map (greatly reduces vacuum overhead for slowly-changing tables)
Version-aware psql (backslash commands work against older servers)
Support SSL certificates for user authentication
Per-function runtime statistics
Easy editing of functions in psql
New contrib modules: pg_stat_statements, auto_explain, citext, btree_gin
URL: http://www.postgresql.org/docs/8.4/interactive/release-8-4.html
PgDBF is a program for converting XBase databases - particularly FoxPro
tables with memo files - into a format that PostgreSQL can directly
import. It's a compact C project with no dependencies other than standard
Unix libraries. While the project is relatively tiny and simple, it's also
heavily optimized via profiling - routine benchmark were many times faster
than with other Open Source programs. In fact, even on slower systems,
conversions are typically limited by hard drive speed.
WWW: http://pgdbf.sourceforge.net/
PR: ports/135969
Submitted by: kirk at daycos.com
mysqlbackup: create MySQL-database servers backup easy
Why mysqlbackup?
1. Required minimum coding to create everyday MySQL-backups with some
additional functions.
2. Backups can be compressed on-the-fly and automatically rotated after
specified number of a days past.
3. It is includes basic database maintenance: check, optimize tables before
backup creation.
4. It can be safely used on a large MySQL installations (1000+ databases).
5. It is written in sh - code interpreter available in a base system.
WWW: http://renatasystems.org/freebsd/mysqlbackup.html
PR: ports/135331
Submitted by: Alexey V. Degtyarev
Here are new Linux Fedora 10 infrastructure ports.
Those ports are intended to be used with 8-CURRENT at least
with SVN r192206.
If you want to switch to linux-f10 ports, please define at /etc/make.conf:
OVERRIDE_LINUX_BASE_PORT=f10
OVERRIDE_LINUX_NONBASE_PORTS=f10
An upgrading procedure is shown at /usr/ports/UPDATING, entries 20090401
and 20070327.
For the first time all tested linux ports work as expected(!):
. acroread8;
. google-earth;
. skype;
. seamonkey.
Many thanks for kernel folks who really did the main work
(and I wrote only some lines of ports).
There is a good chance that those ports may become a default
for 8.0-RELEASE. Please, test and report back to emulation@ ML.
LuaSQL is a simple interface from Lua to a DBMS. It enables a Lua
program to:
* Connect to ODBC, ADO, Oracle, MySQL, SQLite and PostgreSQL databases;
* Execute arbitrary SQL statements;
* Retrieve results in a row-by-row cursor fashion.
WWW: http://www.keplerproject.org/luasql/
LuaSQL is a simple interface from Lua to a DBMS. It enables a Lua
program to:
* Connect to ODBC, ADO, Oracle, MySQL, SQLite and PostgreSQL databases;
* Execute arbitrary SQL statements;
* Retrieve results in a row-by-row cursor fashion.
WWW: http://www.keplerproject.org/luasql/
----------------------------------------------------------------------
LuaSQL is a simple interface from Lua to a DBMS. It enables a Lua
program to:
* Connect to ODBC, ADO, Oracle, MySQL, SQLite and PostgreSQL databases;
* Execute arbitrary SQL statements;
* Retrieve results in a row-by-row cursor fashion.
WWW: http://www.keplerproject.org/luasql/
sqliteman is the best developer's and/or admin's GUI tool for
Sqlite3 in the world. No joking here (or just a bit only).It
contains the most complette feature set of all tools available.
And much more , it's available for all major platforms, and
it's free.
WWW: http://sqliteman.sf.net/
PR: ports/134733
Submitted by: Wen Heping <wenheping at gmail.com>
pgtune takes the wimpy default postgresql.conf and expands
the database server to be as powerful as the hardware it's
being deployed on.
WWW: http://pgfoundry.org/projects/pgtune/
PR: ports/134546
Submitted by: Matthieu BOUTHORS
pyodbc is a Python module that allows you to use ODBC to connect to
almost any database from Windows, Linux, OS/X, and more.
It implements the Python Database API Specification v2.0, but
additional features have been added to simplify database
programming even more.
WWW: http://code.google.com/p/pyodbc/
PR: ports/133757
Submitted by: Robet Kruus <rob.kruus@gmail.com>
mysqlidxchk (MySQL Index Checker) checks MySQL databases/tables for
unused indexes. Given one or more slow, general, or "raw" log files,
mysqlidxchk reports which indexes in the database schema are not used
by the queries in the log files.
WWW: http://hackmysql.com/mysqlidxchk
PR: ports/134107
Submitted by: Andrey Ignatov <rdna at rdna.ru>
Ruby DataObjects driver to the SQLite DB engine version 3
The purpose of DO.rb is to rewrite existing Ruby database drivers to conform to
a single interface.
At present, PostgreSQL, MySQL, and SQLite adapters are available.
Author: Dirkjan Bussink (dbussink) <d.bussink@gmail.com>
WWW: http://rubyforge.org/projects/dorb/
PR: ports/133853
Submitted by: Espen Volden aka voldern <voldern at hoeggen.net>
The purpose of DO.rb is to rewrite existing Ruby database drivers to conform to
a single interface.
At present, PostgreSQL, MySQL, and SQLite adapters are available.
Author: Dirkjan Bussink (dbussink) <d.bussink@gmail.com>
WWW: http://rubyforge.org/projects/dorb/
PR: ports/133842
Submitted by: Espen Volden aka voldern <voldern at hoeggen.net>
There's plenty of modules which need a database, and they all have
to be configured differently and they're always a PITA when you first
install and each and every time they upgrade.
Test::Database provides a simple way for test authors to request
a test database, without worrying about environment variables or the
test host configuration.
WWW: http://search.cpan.org/dist/Test-Database/
PR: ports/133273
Submitted by: Wen Heping <wenheping at gmail.com>
New port databases/p5-DBIx-Class-HTML-FormFu:
Fill a HTML::FormFu form from the database and vice-versa.
(Yes, I'm adding a deprecated port! But I need it for a new module...)
New port databases/p5-DBIx-Class-EncodedColumn:
This DBIx::Class component can be used to automatically encode a
column's contents whenever the value of that column is set.
New port databases/p5-DBIx-Class-DateTime-Epoch:
This module automatically inflates/deflates DateTime objects
corresponding to applicable columns. Columns may also be
defined to specify their nature, such as columns representing a
creation time (set at time of insertion) or a modification time
(set at time of every update).
New port, databases/p5-DBIx-Class-ResultSet-RecursiveUpdate
It is a base class for ResultSets providing just one method: recur-
sive_update which works just like update_or_create but can recursively
update or create data objects composed of multiple rows. All rows need
to be identified by primary keys - so you need to provide them in the
update structure (unless they can be deduced from the parent row - for
example when you have a belongs_to relationship). If not all colums
comprising the primary key are specified - then a new row will be cre-
ated, with the expectation that the missing columns will be filled by
it (as in the case of auto_increment primary keys).
Python extension for libmemcache, the C API to memcached. cmemcache API is the
same as python-memcache, so it is easy to replace python-memcache with
cmemcache, and vice versa.
WWW: http://gijsbert.org/cmemcache/
PR: ports/132699
Submitted by: Qing Feng <qingfeng at me.com>
ORLite is an object-relation system specifically tailored for SQLite that
follows many of the same principles as the ::Tiny series of modules and has
a design and feature set that aligns directly to the capabilities of SQLite.
WWW: http://search.cpan.org/dist/ORLite/
PR: ports/132406
Submitted by: Cezary Morga <cm at therek.net>
ORLite::Migrate is a light weight single class Database Schema Migration
enhancement for ORLite. It provides a simple implementation of schema
versioning within the SQLite database using the built-in user_version pragma
(which is set to zero by default).
WWW: http://search.cpan.org/dist/ORLite-Migrate/
PR: ports/132406
Submitted by: Cezary Morga <cm at therek.net>
buzhug is a fast, pure-Python database engine, using a syntax that Python
programmers should find very intuitive.
The data is stored and accessed on disk (it is not an in-memory database);
the implementation has been designed to make all operations, and especially
selection, as fast as possible with an interpreted language.
The database is implemented as a Python iterator, yielding objects whose
attributes are the fields defined when the base is created ; therefore,
requests can be expressed as list comprehensions or generator expressions,
instead of SQL queries.
WWW: http://buzhug.sourceforge.net/
PR: ports/132278
Submitted by: Wen Heping <wenheping at gmail.com>
2009-03-01 databases/rubygem-rrdtool: port no longer maintained by upstream use
rrdtools own ruby bindings instead
2009-01-19 graphics/crystalentitylayer-devel: Depends on broken, expired port
2008-09-19 graphics/crystalspace-devel: Has been broken for more than 6 months
The openark kit is a set of utilities for MySQL. They solve everyday
maintenance tasks, which may be complicated or time consuming to work
by hand.
WWW: http://code.openark.org/forge/openark-kit
PR: ports/132175
Submitted by: Gea-Suan Lin <gslin at gslin.org>
py-simplecouchdb is a simple librairy to allow your python
applicationto use CouchDB.
With simplecouchdb, you can manage documents like you do
directly with CouchDB, schema-free. So document instance
(see :ref:schema-ref) are completly dynamic, you could
add/delete properties in your documents, retrieve them
without any schema, etc.
WWW: http://code.google.com/p/py-simplecouchdb/
PR: ports/131296
Submitted by: Wen Heping <wenheping at gmail.com>
memcached is a high-performance, distributed memory object caching
system, generic in nature, but intended for use in speeding up dynamic
web applications by alleviating database load.
This extension uses libmemcached library to provide API for
communicating with memcached servers.
WWW: http://pecl.php.net/package/memcached
PR: ports/131172
Submitted by: Gea-Suan Lin <gslin at gslin.org>
rubygem-pg provides the module "pg", a Ruby interface to the
PostgreSQL Relational Database Management System, which
supersedes the old "postgres" module.
WWW: http://rubyforge.org/projects/ruby-pg/
PR: ports/131270
Submitted by: Wen Heping <wenheping at gmail.com>
2009-01-19 games/emacs-chess: has been broken for more than 6 months
2009-02-01 devel/subversion-devel: Use devel/subversion or
devel/subversion-freebsd instead of this port
2009-01-19 devel/hs-hat: has been broken for more than 6 months
2009-01-19 devel/hs-hpl: has been broken for more than 6 months
2009-01-19 databases/mysqlbigram: has been broken for more than 6 months
2009-01-19 mail/claws-mail-clamav: has been broken for more than 6 months
2009-01-19 mail/sylpheed2-devel: has been broken for more than 6 months
2009-01-19 www/pecl-mnogosearch: has been broken for more than 6 months
2009-01-31 x11-fonts/mathfonts: This port was supported by Mozilla 1.8
(including Firefox 2.0) - to be replaced by STIX fonts for Firefox 3.x
2009-01-19 x11-wm/fluxspace: has been broken for more than 6 months
2009-01-31 x11-wm/expocity: project has been abandoned
2009-01-19 x11/bbuname: has been broken for more than 6 months
2009-01-19 security/squidclam: has been broken for more than 6 months
2009-01-19 print/virtualpaper: depends on broken, expired port
2009-01-19 print/ifhp: has been broken for more than 6 months
2009-01-19 net-p2p/peercast: has been forbidden for more than 6 months
2009-01-19 palm/pdbc: has been broken for more than 6 months
2009-01-19 net-mgmt/NeTraMet: has been broken for more than 6 months
2009-01-19 net-im/sulci: has been broken for more than 6 months
2009-01-19 multimedia/mjpegtools-yuvfilters: has been broken for more than 6
months
2009-01-19 multimedia/helixplayer: has been broken for more than 6 months
2009-01-19 lang/quack: has been broken for more than 6 months
2009-01-19 misc/pybliographer: has been broken for more than 6 months
2009-01-19 net/versuch: has been broken for more than 6 months
2009-01-19 net/py-mantissa: has been broken for more than 6 months
2009-01-19 net/libunpipc: has been broken for more than 6 months
2009-01-19 net/gnometelnet: has been broken for more than 6 months
2009-01-19 net/gacxtool: depends on expired, broken port
2009-01-19 devel/py-coro: has been broken for more than 6 months
2009-01-19 chinese/stardict2-dict-zh_TW: has been broken for more than 6 months
2009-01-19 x11-themes/gtk-industrial-theme: has been broken for more than 6
months
Presenting GNOME 2.24 for FreeBSD.
See http://library.gnome.org/misc/release-notes/2.24/ for the general
release notes. On the FreeBSD front, this release introduces Fuse support
in HAL, adds multi-CPU support to libgtop, WebKit updates, and fixes some
long-standing seahorse and gnome-keyring bugs. The documentation updates
to the website are forthcoming.
This release features commits by adamw, ahze, kwm, mezz, and myself. It would
not have been possible without are contributors and testers:
Alexander Loginov
Craig Butler [1]
Dmitry Marakasov [6]
Eric L. Chen
Joseph S. Atkinson
Kris Moore
Lapo Luchini [7]
Nikos Ntarmos
Pawel Worach
Romain Tartiere
TAOKA Fumiyoshi [3]
Yasuda Keisuke
Zyl
aZ [4]
bf [2] [5]
Florent Thoumie
Peter Wemm
pluknet
PR: 125857 [1]
126993 [2]
130031 [3]
127399 [4]
127661 [5]
124302 [6]
129570 [7]
129936
123790
KirbyBase is a small, plain-text, DBMS written in Ruby.
It can be used either embedded or client/server. It aims
to be as "Ruby-ish" as possible. For example, queries
are specified using Ruby code blocks, rather than SQL strings.
WWW: http://rubyforge.org/projects/kirbybase/
PR: ports/130231
Submitted by: Wen Heping <wenheping at gmail.com>
PQueue is a package providing low-level PQ protocol classes for
interacting with a PostgreSQL database. It supports version 3.0
of the protocol--the current primary version of protocol. The
package also provides a basic protocol transaction class. This
class keeps the state of the protocol in an interrupt safe manner,
and validates the integrity of the communication as messages are
received.
In general, you probably will never use this package directly,
unless you are writing a driver.
WWW: http://python.projects.postgresql.org/
PR: ports/130252
Submitted by: Wen Heping <wenheping at gmail.com>
DataMapper is a Object Relational Mapper written in Ruby. The goal
is to create an ORM which is fast, thread-safe and feature-rich with
ActiveRecord-compatibility.
WWW: http://datamapper.rubyforge.org/
2008-09-19 databases/py-tada: Has been broken for more than 6 months
2008-09-19 databases/qdbm-java: Has been broken for more than 6 months
2008-09-19 audio/shellac: Has been broken for more than 6 months
2008-09-19 audio/snett: Has been broken for more than 6 months
Because the many-to-many relationships are not real relationships,
they can not be introspected with DBIx::Class. Many-to-many
relationships are actually just a collection of convenience methods
installed to bridge two relationships. This DBIx::Class component
can be used to store all relevant information about these
non-relationships so they can later be introspected and examined.
This module is fairly esoteric and, unless you are dynamically
creating something out of of a DBIC Schema, is probably the wrong
solution for whatever it is you are trying to do. Please be advised
that compatibility is not guaranteed for DBIx::Class 0.09000+. We
will try to mantain all compatibility, but internal changes might
make it impossible.
WWW: http://search.cpan.org/dist/DBIx-Class-IntrospectableM2M/
This is DataSource driver for Structures_DataGrid which uses PEAR::DB.
Please note that this driver is deprecated. Consider using DBQuery or MDB2
DataSource drivers instead.
WWW: http://pear.php.net/package/Structures_DataGrid_DataSource_DB/
Submitted by: Nick Hilliard <nick at foobar.org>
The Perl 5 module DBICx::Deploy deploys a DBIx::Class schema to a
database. A command line script, dbicdeploy, is provided.
WWW: http://search.cpan.org/dist/DBICx-Deploy
