summaryrefslogtreecommitdiff
path: root/databases
AgeCommit message (Collapse)AuthorFilesLines
2011-10-08Update p5-DBIx-Class to 0.08195.hiramatsu2-7/+6
Excerpted new features. For complete list of bug fixes, look into Changes file in the distfile. 0.08193 2011-07-14 17:00 (UTC) * New Features / Changes - Allow schema cloning to mutate attributes - DBIC now attempts more aggressive de-duplication of where conditions on resultset chaining - The Ordered component is now smarter wrt reordering of dirty objects, and does its job with less storage queries - Logging via DBIC_TRACE=1=<filename> no longer overwrites the logfile on every program startup, appending loglines instead 0.08191 2011-05-02 00:45 (UTC) (deleted from CPAN) * New Features / Changes - Add quote_names connection option. When set to true automatically sets quote_char and name_sep appropriate for your RDBMS - Add retrieve_on_insert column info flag, allowing to retrieve any column value instead of just autoinc primary keys - Bring back strict ordering of selectors in complex search chains (an ill-fated attempt was made in 0.08127 to order intelligently) - All limit dialects (except for the older Top and FetchFirst) are now using bind parameters for the limits/offsets, making DBI's prepare_cached useful across paged resutsets - Support for savepoints for SQLite - Support for MS Access databases via DBD::ODBC and DBD::ADO (only Win32 support currently tested) - Support for the Firebird RDBMS over the new DBD::Firebird driver - IC::DateTime support for MSSQL over DBD::ADO - Both the ::ODBC and ::ADO dispatchers now warn if a rdbms-specific driver is not found for this connection before falling back to plain ::Storage::DBI - ::Storage::DBI::sth was mistakenly marked/documented as public, privatize and warn on deprecated use - Massive overhaul of bind values/attributes handling - slightly changes the output of as_query (should not cause compat issues) - Support ancient DB2 versions (5.4 and older), with proper limit dialect - Support sub-second precision for TIMESTAMPs for Firebird over ODBC - Support BLOBs and CLOBs in WHERE clauses for Oracle, including LIKE queries for CLOBs. 0.08190-TRIAL 2011-01-24 15:35 (UTC) * New Features / Changes - Support for completely arbitrary SQL::Abstract-based conditions in all types of relationships 0.08127 2011-01-19 16:40 (UTC) * New Features / Changes - Schema/resultsource instances are now crossreferenced via a new system guaranteeing leak-free mutually assured destruction - DBIx::Class now warns when the user erroneously supplies AutoCommit => 0 to connect() - A warning is also issued before forcing the RaiseError setting of externally supplied DBI handles - Switch to a warning when find() is invoked with both a 'key' argument and a NULL-containing condition to satisfy the named constraint. Previously (starting with 0.08124) an exception was thrown - Switch to a warning when a commit is attempted with an out-of-sync transaction_depth (someone issued a begin externally to DBIC). Previously (starting with 0.08124) an exception was thrown 0.08126 2010-12-28 18:10 (UTC) * Fixes - Bump forgotten Class::Accessor::Grouped core dependency - Promote forgotten Hash::Merge optdep to a hard requirement - Skip t/storage/error.t on smokers with leaking perls - Fix t/storage/txn.t deadlocks on slower machines - Do not run on smokers if a trial Package::Stash is found 0.08125 2010-12-27 04:30 (UTC) * New Features / Changes - New method ResultSource columns_info method, returning multiple pairs of column name/info at once - $rs->search now throws when called in void context, as it makes no sense (and is nearly always a sign of a bug/misdesign) - Restore long-lost ability to supply unbalanced select/as pairs e.g. +select => \'DISTINCT(foo, bar)', +as => ['foo', 'bar'] - +columns now behaves just like columns by not stripping a fully-qualified 'as' spec (i.e. foo.bar results in $obj->foo->bar) - Deprecate legacy $rs->search( %condition ) syntax (warn once per callsite) - NULL is now supplied unquoted to all debug-objects, in order to differentiate between a real NULL and the string 'NULL' - New search() condition operator -value used to pass complex bind values to DBI: search({ array_col => { -value => [1,2,3] }}) - Add full INSERT...RETURNING support for Oracle - Deprecate use of -nest in search conditions (warn once per callsite) - Deprecate the completely useless DBIx::Class::Serialize::Storable result component
2011-10-06Update p5-Catalyst-Model-DBIC-Schema to 0.55.hiramatsu2-8/+7
Changes from previous: 0.55 Fri Sep 16 08:55:53 UTC 2011 - add DBD::SQLite to test_requires (RT#70357) 0.54 Fri Aug 5 11:29:00 EDT 2011 - Changed t/08helper.t to skip if required features are not installed. - tweaked the Makefile.PL to support these changes 0.53 Wed Aug 3 03:45:07 UTC 2011 - check loader args after connect_info against loader methods and remove them from connect_info 0.52 Thu Jul 28 22:07:38 UTC 2011 - fix a bug in loader args reading after connect_info (skip structs) 0.51 Wed Jul 27 20:57:47 UTC 2011 - warn when helper finds no tables - accept loader args after connect_info 0.50 Fri May 20 22:45:07 UTC 2011 - change repository link to the new git repo - get t/05testapp.t to run on Win32 0.49 Wed May 11 06:03:50 UTC 2011 - make sure storage_type class is loaded before ->isa check in Replicated trait (RT#65791) - fix regex stringification test for perl 5.14 (RT#68098) - update connect_info POD (RT#66010) 0.48 Thu Dec 9 21:08:33 UTC 2010 - fix usage of Try::Tiny in helper 0.47 Wed Dec 8 22:21:06 UTC 2010 - fix loader version check 0.46 Wed Dec 8 13:35:28 UTC 2010 - make use_moose detection more robust 0.45 Wed Dec 8 12:05:58 UTC 2010 - fix bug where non-result files were picked up for Moose check 0.44 Tue Dec 7 03:50:48 UTC 2010 - do not upgrade non-Moose schemas to use_moose=1 (RT#60558) - added col_collision_map => 'column_%s' as default loader option (will take effect on release of loader 0.07003)
2011-10-05Update p5-DBD-CSV to 0.33.hiramatsu2-7/+6
Changes from previous: 2011-09-07 0.33 H.Merijn Brand * NAME / DISTNAME in Makefile.PL 2011-09-07 0.32 H.Merijn Brand * TYPE should be numeric * Added tests for return count of delete statements in do * Upped copyright to 2011 * Added tests for return count of update statements (Peter Rabbitson) * Try to catch (more) usernames on Windows as schema names * More cross-checks for META data
2011-10-04Finish move of datapkg to py-datapkg.wiz5-169/+2
2011-10-04Simplify PKGNAME.wiz1-2/+2
2011-10-04Reimport pkgsrc/databases/datapkg.wiz4-0/+169
On request by joerg, prefix PKGNAME with py??- since it installs a python library; this way all binary packages can coexist. The separate packages will still conflict due to bin/datapkg though.
2011-10-03+ datapkg, py-ckanclient.wiz1-1/+3
2011-10-03Initial import of datapkg-0.8:wiz4-0/+167
datapkg is a Python library and command line tool for working with Data Packages and interacting with data hubs like CKAN.
2011-10-03Initial import of py-ckanclient-0.9.0:wiz4-0/+46
ckanclient is a Python module to read and write to a CKAN server via the API.
2011-10-03Changes 5.2.36:adam5-38/+41
* Updated the JDBC version shipped with Berkeley DB to support Oracle Java Embedded Client. * Fixed several memory leaks in the Online Backup API. * Fix a bug in the SQL API when using a blob field with a lot of content and multiple concurrent connections to the database. * Update EID_MASTER to be public static final so that it will be exposed in Java docs. * Fixed a bug where BFile module crashes when using BFile handle for SQL expressions interface on 64 bit platforms. * Fixed a bug where, on systems without FTRUNCATE, db_verify will return an error for truncated heap databases. * Let ADO.NET solution building skip SQLite Designer and Linq by default. * Fixed a bug that could cause BDB to run out of avaliable mutexes when renaming many databases. * Fixed a bug where the metadata page in hash databases would not be flushed to disk. * Fixed a bug where printlog would fail on in-memory heap databases. * Fixed a bug that would cause verify to call the wrong compare function if there are user defined compare functions used and the database has multilevel off page sorted duplicate trees. * Fixed a bug where two processes accessing the same table and one of those drops the table and recreates, the second process can crash. * Fixed a bug where it was possible to panic a heap database without an error message being printed. * Fixed a bug where it would fail to put records with overflow keys into hash duplicate database. * Fixed a bug where multiple Replication Manager processes would sometimes not all conform to replication-group-aware log archiving. * more...
2011-10-03Changes 3.7.8:adam7-24/+50
* Orders of magnitude performance improvement for CREATE INDEX on very large tables. * Improved the windows VFS to better defend against interference from anti-virus software. * Improved query plan optimization when the DISTINCT keyword is present. * Allow more system calls to be overridden in the unix VFS - to provide better support for chromium sandboxes. * Increase the default size of a lookahead cache line from 100 to 128 bytes. * Enhancements to the test_quota.c module so that it can track preexisting files. * Bug fix: Virtual tables now handle IS NOT NULL constraints correctly. * Bug fixes: Correctly handle nested correlated subqueries used with indices in a WHERE clause.
2011-10-02Doesn't like python24. Probably fixable, probably not worth the trouble.dholland1-1/+3
2011-09-29Add pkg-config to tools, seems to be needed (according towiz1-2/+2
bulk build logs provided by joerg.
2011-09-29Remove Python 2.3 from the list of supported versionsjoerg1-2/+2
2011-09-29Fixes shebang for bin/dbicdeployobache1-1/+3
2011-09-29Update p5-DBD-Sybase to 1.13, to buildable with perl-5.14.obache3-14/+15
Release 1.13 Fix for incorrect UTF8 handling when retrieving UNICODE data (Jean-Pierre Rupp). Release 1.12 Bug/Typo/Compatibility fixes with various versions of OpenClient. Experimental: Handle in/out parameters (Merijn Broeren) Release 1.11 Remove reliance on PERL_POLLUTE. Add better support for utf8 (Dave Rolsky) Release 1.10 Handle 15.x datatypes correctly. Add LONGMS date format symbol to handle microseconds for bigdatetime. Add support for CS_LONGCHAR_TYPE (Mark Aufflick) Document syb_isdead(). Handle 64bit builds with FreeTDS (Ian Grant/Hans Kristian Rosbach) Add foreign_key_info & statistics_info (Jim Radford) Change behavior of large fixed precision numeric types (money, bigint) to be converted to a string internally and returned as such to the caller (behavior similar to numeric/decimal). This can be reverted to the old behavior by defining SYB_NATIVE_NUM.
2011-09-29conditional EGG_FILE installation, fixes for python24.obache1-2/+2
2011-09-27Changes 9.1.1:adam5-11/+16
* Make pg_options_to_table return NULL for an option with no value * Fix memory leak at end of a GiST index scan * Fix explicit reference to pg_temp schema in "CREATE TEMPORARY TABLE"
2011-09-27Changes 9.0.5:adam11-29/+73
* Fix catalog cache invalidation after a "VACUUM FULL" or "CLUSTER" on a system catalog * Fix incorrect order of operations during sinval reset processing, and ensure that TOAST OIDs are preserved in system catalogs * Fix bugs in indexing of in-doubt HOT-updated tuples * Fix multiple bugs in GiST index page split processing * Fix possible buffer overrun in tsvector_concat() * Fix crash in xml_recv when processing a "standalone" parameter * Make pg_options_to_table return NULL for an option with no value * Avoid possibly accessing off the end of memory in "ANALYZE" and in SJIS-2004 encoding conversion * Protect pg_stat_reset_shared() against NULL input * Fix possible failure when a recovery conflict deadlock is detected within a sub-transaction * Avoid spurious conflicts while recycling btree index pages during hot standby * Shut down WAL receiver if it's still running at end of recovery * Fix race condition in relcache init file invalidation * Fix memory leak at end of a GiST index scan * Fix memory leak when encoding conversion has to be done on incoming command strings and "LISTEN" is active * Fix incorrect memory accounting (leading to possible memory bloat) in tuplestores supporting holdable cursors and plpgsql's RETURN NEXT command * Fix trigger WHEN conditions when both BEFORE and AFTER triggers exist * more...
2011-09-27Changes 8.4.9:adam11-40/+44
* Fix bugs in indexing of in-doubt HOT-updated tuples * Fix multiple bugs in GiST index page split processing * Fix possible buffer overrun in tsvector_concat() * Fix crash in xml_recv when processing a "standalone" parameter * Make pg_options_to_table return NULL for an option with no value * Avoid possibly accessing off the end of memory in "ANALYZE" and in SJIS-2004 encoding conversion * Prevent intermittent hang in interactions of startup process with bgwriter process * Fix race condition in relcache init file invalidation * Fix memory leak at end of a GiST index scan * Fix incorrect memory accounting (leading to possible memory bloat) in tuplestores supporting holdable cursors and plpgsql's RETURN NEXT command * Fix performance problem when constructing a large, lossy bitmap * Fix join selectivity estimation for unique columns * Fix nested PlaceHolderVar expressions that appear only in sub-select target lists * Allow nested EXISTS queries to be optimized properly * Fix array- and path-creating functions to ensure padding bytes are zeroes * Fix "EXPLAIN" to handle gating Result nodes within inner-indexscan subplans * Work around gcc 4.6.0 bug that breaks WAL replay * Fix dump bug for VALUES in a view * Disallow SELECT FOR UPDATE/SHARE on sequences This operation doesn't work as expected and can lead to failures. * Fix "VACUUM" so that it always updates pg_class.reltuples/relpages * more...
2011-09-27Changes 8.3.16:adam11-29/+44
* Fix bugs in indexing of in-doubt HOT-updated tuples * Fix multiple bugs in GiST index page split processing * Fix possible buffer overrun in tsvector_concat() * Fix crash in xml_recv when processing a "standalone" parameter * Avoid possibly accessing off the end of memory in "ANALYZE" and in SJIS-2004 encoding conversion * Fix race condition in relcache init file invalidation * Fix memory leak at end of a GiST index scan * Fix performance problem when constructing a large, lossy bitmap * Fix array- and path-creating functions to ensure padding bytes are zeroes * Work around gcc 4.6.0 bug that breaks WAL replay * Fix dump bug for VALUES in a view * Disallow SELECT FOR UPDATE/SHARE on sequences This operation doesn't work as expected and can lead to failures. * Defend against integer overflow when computing size of a hash table * Fix cases where "CLUSTER" might attempt to access already-removed TOAST data * Fix portability bugs in use of credentials control messages for "peer" authentication * Fix SSPI login when multiple roundtrips are required * Fix typo in pg_srand48 seed initialization * Avoid integer overflow when the sum of LIMIT and OFFSET values exceeds 2^63 * Add overflow checks to int4 and int8 versions of generate_series() * Fix trailing-zero removal in to_char() * Fix pg_size_pretty() to avoid overflow for inputs close to 2^63 * In pg_ctl, support silent mode for service registrations on Windows * Fix psql's counting of script file line numbers during COPY from a different file * more...
2011-09-27Fix for PR#45403adam4-16/+16
2011-09-24configure (ab)uses Perljoerg1-1/+2
2011-09-23PLIST has been wrongadam1-1/+237
2011-09-21PLIST correction (not only support dylib)adam1-9/+5
2011-09-20Use ${PKGLOCALEDIR} to tell configure where to put locales.hans1-2/+2
2011-09-18remove *_drivers filescheusov4-60/+2
2011-09-17Only make "readlink" a run-time dependence if we are actually buildingtron1-1/+5
the embedded server which is the only binary that requires the library. No revision bump as there is no changed to the default binary package.
2011-09-17Change "readline" to a run-time dependence as it is used by at leasttron1-6/+2
"bin/mysql_embedded". This fixes the build in pkgsrc developer mode. Bump package revision because the dependence changed.
2011-09-16Changes 5.5.16:adam5-24/+28
* The default thread-handling model in MySQL Server executes statements using one thread per client connection. * Commercial distributions of MySQL now include two plugins that enable MySQL Server to use external authentication methods to authenticate MySQL users * Important Change: Replication: The RESET SLAVE statement has been extended with an ALL keyword. * A new utility, mysql_plugin, enables MySQL administrators to manage which plugins a MySQL server loads. * Bugs fixed.
2011-09-16Bump PKGREVISION from PHP_VERSION_DEFAULT changes.obache2-7/+6
2011-09-15Files related to libdbi DB drivers have been moved tocheusov7-8/+66
databases/libdbi-driver-sqlite3 directory. This fixes pkglint warnings for databases/libdbi.
2011-09-15Fix PKGVERSION, noted by obache.wiz1-2/+2
2011-09-15Added databases/postgresql91 version 9.1.0adam1-1/+16
2011-09-15Version 9.1 delivers several features which users have been requesting foradam70-0/+4014
years, removing roadblocks to deploying new or ported applications on PostgreSQL. These include: * Synchronous Replication: enable high-availability with consistency across multiple servers * Per-Column Collations: support linguistically-correct sorting per database, table or column. * Unlogged Tables: greatly improves performance for ephemeral data Our community of contributors innovates with cutting-edge features. Version 9.1 includes several which are new to the database industry, such as: * K-Nearest-Neighbor Indexing: index on "distance" for faster location and text search queries * Serializable Snapshot Isolation: keeps concurrent transactions consistent without blocking, using "true serializability" * Writeable Common Table Expressions: execute complex multi-stage data updates in a single query * Security-Enhanced Postgres: deploy military-grade security and Mandatory Access Control
2011-09-14Update "phpmyadmin" package to version 3.4.5. Chances since version 3.4.4:tron3-161/+7
- bug #3375325 [interface] Page list in navigation frame looks odd - bug #3313235 [interface] Error div misplaced - bug #3374802 [interface] Comment on a column breaks inline editing - patch #3383711 [display] Order by a column in a view doesn't work in some cases - bug #3386434 [interface] Add missing space to server status - [core] Remove library PHPExcel, due to license issues - [export] Remove native Excel export modules (xls and xlsx formats) - [import] Remove native Excel import modules (xls and xlsx formats) - bug #3392920 [edit] BLOB emptied after editing another column - [security] Fixed XSS in Inline Edit on save action, see PMASA-2011-14 - [security] Fixed XSS with db/table/column names, see PMASA-2011-14
2011-09-14Fix build on SunOS.hans4-4/+16
2011-09-13+ pgbuildfarm.wiz1-1/+2
2011-09-13Initial import of pgbuildfarm-4.5, packaged for wip by Nicolas Thauvin.wiz5-0/+90
The PostgreSQL BuildFarm is a distributed build system designed to detect build failures of the source code of PostgreSQL on a large collection of platforms and configurations. This is the client software that enables to perform automated test builds and checks.
2011-09-12Update ruby-cassandra pacakge to 0.12.1.taca2-8/+8
v0.12.1 - Fix issue with simple_uuid dependency. - Fix issue with get_range & get_range_batch keeping all results when a block is given. Resolves Issue# 112. v0.12.0 Changed thrift_client dependency to 0.7.0
2011-09-12Update ruby-sequel pacakge to 3.27.0.taca3-7/+13
=== 3.27.0 (2011-09-01) * Add support for native prepared statements to the tinytds adapter (jeremyevans) * Add support for native prepared statements and stored procedures to the mysql2 adapter (jeremyevans) * Support dropping primary key, foreign key, and unique constraints on MySQL via the drop_constraint :type option (jeremyevans) * Add Sequel::SQLTime class for handling SQL time columns (jeremyevans) * Typecast DateTime objects to Date for date columns (jeremyevans) * When typecasting Date objects to timestamps, make the resulting objects always have no fractional date components (jeremyevans) * Add Model.dataset_module for simplifying many def_dataset_method calls (jeremyevans) * Make prepared_statements_safe plugin work on classes without datasets (jeremyevans) * Make Dataset#hash work correctly when referencing SQL::Expression instances (jeremyevans) * Handle allowed mass assignment methods correctly when including modules in classes or extending instances with modules (jeremyevans) * Fix Model#hash to work correctly with composite primary keys and with no primary key (jeremyevans) * Model#exists? now returns false without issuing a query for new model objects (jeremyevans)
2011-09-12Add b3.mk file for consistency with the other MySQL server packagesjoerg1-0/+15
2011-09-12Add proper upper limit to not result in mix of MySQL 5.1 and 5.5joerg1-2/+2
2011-09-11PR#45150: Fix DragonFly buildmarino2-1/+20
Add DragonFly entry to Makefile.shlib to allow client to build.
2011-09-11PR#45149: Fix DragonFly buildmarino2-1/+17
Add DragonFly entry to Makefile.shlib to allow client to build.
2011-09-08Apply the same -O20 -> -O3 change for the libdbi driver packagesjoerg3-3/+31
2011-09-07Unconditionalize use a sane optimizer level. -O20 never existed with GCCjoerg2-1/+29
and -O3 is a safe compromise for GCC and Clang (which enables LTO with -O4).
2011-09-03Enable pgbouncermjl1-1/+2
2011-09-03Initial import of pgbouncer-1.4.2mjl5-0/+113
pgbouncer is a lightweight connection pooler for PostgreSQL that provides the following features: * Several levels of brutality when rotating connections. * Low memory requirements. * It is not tied to one backend server, the destination databases can reside on different hosts. * Supports online reconfiguration for most of the settings. * Supports online restart/upgrade.
2011-09-01This patch isn't needed any more by introduce of OVERRIDE_GEMSPEC.taca2-17/+1
generated by cgit v1.2.3 (git 2.39.1) at 2025-01-10 07:05:40 +0000