||Open Source Technical Updates [Page: 10 of 75] @ TACKtech Corp.
The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 9.5.1, 9.4.6, 9.3.11, 9.2.15, and 9.1.20. This release fixes two security issues, as well as several bugs found over the last four months. Users vulnerable to the security issues should update their installations immediately; other users should update at the next scheduled downtime.
Security Fixes for Regular Expressions, PL/Java
This release closes security hole CVE-2016-0773, an issue with regular expression (regex) parsing. Prior code allowed users to pass in expressions which included out-of-range Unicode characters, triggering a backend crash. This issue is critical for PostgreSQL systems with untrusted users or which generate regexes based on user input.
The update also fixes CVE-2016-0766, a privilege escalation issue for users of PL/Java. Certain custom configuration settings (GUCS) for PL/Java will now be modifiable only by the database superuser.
Other Fixes and Improvements
In addition to the above, many other issues were patched in this release based on bugs reported by our users over the last few months. This includes multiple fixes for new features introduced in version 9.5.0, as well as refactoring of pg_dump to eliminate a number of chronic issues with backing up EXTENSIONs. Among them are:
- Fix many issues in pg_dump with specific object types
- Prevent over-eager pushdown of HAVING clauses for GROUPING SETS
- Fix deparsing error with ON CONFLICT ... WHERE clauses
- Fix tableoid errors for postgres_fdw
- Prevent floating-point exceptions in pgbench
- Make \det search Foreign Table names consistently
- Fix quoting of domain constraint names in pg_dump
- Prevent putting expanded objects into Const nodes
- Allow compile of PL/Java on Windows
- Fix "unresolved symbol" errors in PL/Python execution
- Allow Python2 and Python3 to be used in the same database
- Add support for Python 3.5 in PL/Python
- Fix issue with subdirectory creation during initdb
- Make pg_ctl report status correctly on Windows
- Suppress confusing error when using pg_receivexlog with older servers
- Multiple documentation corrections and additions
- Fix erroneous hash calculations in gin_extract_jsonb_path()
This update also contains tzdata release 2016a, with updates for Cayman Islands, Metlakatla, Trans-Baikal Territory
(Zabaykalsky Krai), and Pakistan.
Users of version 9.4 will need to reindex any jsonb_path_ops indexes they have created, in order to fix a persistent issue with missing index entries. Users of other versions who have skipped multiple update releases may need to perform additional post-update steps; see the Release Notes for details.
All PostgreSQL update releases are cumulative. As with other minor releases, users are not required to dump and reload their database or use pg_upgrade in order to apply this update release; you may simply shut down PostgreSQL and update its binaries.
Full View / NID: 58045 / Submitted by: The Zilla of Zuron
The PHP development team announces the immediate availability of PHP 5.5.32. This is a security release. Several security bugs were fixed in this release. All PHP 5.5 users are encouraged to upgrade to this version. For source downloads of PHP 5.5.32 please visit our downloads page, Windows binaries can be found on windows.php.net/download/. The list of changes is recorded in the ChangeLog.
Full View / NID: 57940 / Submitted by: The Zilla of Zuron
The PHP development team announces the immediate availability of PHP 5.6.18. This is a security release. Several security bugs were fixed in this release. All PHP 5.6 users are encouraged to upgrade to this version. For source downloads of PHP 5.6.18 please visit our downloads page, Windows binaries can be found on windows.php.net/download/. The list of changes is recorded in the ChangeLog.
Full View / NID: 57939 / Submitted by: The Zilla of Zuron
PL/Java brings functions, triggers, and types in Java. 1.5.0, now in beta, supports latest PostgreSQL and Java versions with a range of improvements and fixes.
Project site: http://tada.github.io/pljava/
Release notes: http://tada.github.io/pljava/releasenotes.html
1.5.0 brings a policy change to a more secure-by-default posture, where the ability to create functions in `LANGUAGE java' is no longer automatically granted to 'public', but can be selectively granted to roles that will have that responsibility. The change reduces exposure to a known issue present in 1.5.0 and earlier versions, that will be closed in a future release; details are in the release notes.
The new policy will be applied in a new installation; permissions will not be changed in an upgrade, but any site can move to this policy, even before updating to 1.5.0, with
REVOKE USAGE ON LANGUAGE java FROM public; followed by explicit GRANT commands for the users/roles expected to create Java functions. Many sites guided by the principle of least privilege may have chosen such a policy already.
MS Windows note:
1.5.0 development snapshots have been repeatedly tested on Windows building with Visual Studio (including the Express and Community editions), and the build documentation covers this combination. Beta testers should find it straightforward.
Resources have not been available to test MinGW-based builds. Beta testers using this combination are encouraged to report build issues they may encounter. (Patches, where possible, would be appreciated also. A likely place to look in case of issues would be the comments above PLJAVADLLEXPORT in Backend.c.)
Many thanks to all the individuals and organizations listed in the release notes under Credits.
Full View / NID: 57936 / Submitted by: The Zilla of Zuron
After seven successful sessions dedicated to the new features of PostgreSQL 9.0 (February 2011), to PostGIS (June 2011 & September 2014), to replication systems (February 2012), to migration from Oracle to PostgreSQL (October 2012), to PostgreSQL performance (March 2013) and to our 10th anniversary, in September 2015, we'd like to announce that the 8th PostgreSQL Session will be held on April 6th, 2016, in Lyon, France.
This year, another place, but always the same format!
Indeed, Dalibo and Oslandia organize together one day of lectures dedicated to PostgreSQL and PostGIS.
We're launching a call for papers for this event. You may now submit your talks, in English or in French. Each talk should last 30 minutes (questions included). We are interested in any talks on the following subjects:
- What's New in PostgreSQL
- Use cases
- Migration to PostgreSQL
- Performance Tuning
- Backup and Restore
- Data Warehouse / Big Data
- Advanced spatial analysis with PostgreSQL/PostGIS
- PointCloud Data and/or 3D with PostgreSQL/PostGIS
- Performances improvements with PostgreSQL/PostGIS
Talks can be either: a case study, a Proof of Concept, a tutorial, a benchmark, a presentation of a new feature, etc. Of course, we're open to propositions on any other migration related topics (monitoring, hardware, replication, etc.) !
The submission deadline is February 29, 2016.
You can now send your proposals to email@example.com
Please give us a little information about yourself and your talk, such as:
- First Name and Last Name
- Twitter Account (if any)
- Short Biography (contributions to the PostgreSQL community)
- Talk title
- Talk abstract
- Any specific needs
Slides should have a free licence (Creative Commons BY-ND 3.0 or compatible), and sent to Dalibo.
This day will be filmed, and all the lectures will be recorded and published after the Session. By sending a proposal, you agree to be recorded and waive any compensation for it.
The selected speakers not living in France will be reimbursed for travel and one night accomodation.
See you in Lyon in April !
About the PostgreSQL Sessions:
The PostgreSQL sessions are designed to be a time to discover and meet the community. Each session is a single day consisting of lectures, organized around a specific theme and a guest. The proposed talks aimed at all levels and all profiles: Developer, Administrator, Project Managers, IT Managers, ...
Entry is free and open to all, within the limits of available seats.
Since 2005, Dalibo is the leading French PostgreSQL company and provides its experience and expertise to its clients in Europe. The company
delivers a full range of PostgreSQL services: Training, Development, Performance Tuning, High Availibilty setup, Oracle to
PostgreSQL migration, Troubleshooting, and PostgreSQL support.
Oslandia is a company with a focus on Open Source GIS architecture.
We are characterized by our expertise, agility and dynamism.
Our business model is based on services around Open Source GIS software which we are expert on.
More than just offering expertise, we are also software editor for some OpenSource GIS components we develop, renown and used worldwide (PostGIS, MapServer Suite, QGIS).
This implication requires us to be in the heart of communities of developers and standardisation (worldwide codesprints, participation in future software version orientation, new feature development on our own R&D budgets...).
Full View / NID: 57735 / Submitted by: The Zilla of Zuron
SAN FRANCISCO, CA – January 14th, 2016 - PipelineDB (www.pipelinedb.com), a pioneer in streaming analytics database technology, today announced the release of PipelineDB Enterprise, a commercial edition of the company’s open-source database. PipelineDB Enterprise extends the functionality of the company’s open-source relational database, which runs SQL queries continuously on streaming data for realtime analytics applications, and adds horizontal scaling, high availability, and realtime alerting capabilities. PipelineDB and PipelineDB Enterprise are based on PostgreSQL 9.4 and will be refactored to be compatible with PostgreSQL 9.5 this quarter.
This new product enables anybody familiar with the ubiquitous SQL to build scalable, fault-tolerant analytics applications such as realtime reporting dashboards and realtime monitoring systems. The launch of PipelineDB Enterprise reinforces the company’s mission to give a wide range of developers an easy way to build scalable realtime applications without writing custom application code.
“An increasing number of organizations are beginning to think about data as perpetually moving streams rather than static and at rest. PipelineDB is highly conducive to applying this new mindset to information in ways that generate real business value, and PipelineDB Enterprise makes this possible at the largest scale,” said Derek Nelson, the company’s CEO and Co-Founder.
Since launching the company in July, 2015 the company says it has seen significant adoption in verticals including finance, telecommunications, advertising, gaming, and networking. They report having several paying enterprise customers, although they were unable to offer specific names due to being under NDA.
“Soon after we released our open-source core product, many of our biggest users wanted to pay for easy scaling, high availability, and support, which is exactly what PipelineDB Enterprise delivers. We have several customers currently piloting PipelineDB Enterprise and we are excited to announce its public availability today,” said Jeff Ferguson, the company’s President and Co-Founder.
PipelineDB Enterprise Highlights:
· Shared-nothing architecture for seamless horizontal scaling
· Replication and failover of hardware nodes for high availability
· Realtime alerting capabilities
· 24/7 enterprise support
PipelineDB Enterprise is offered under a commercial license for one and three year terms. To try PipelineDB Enterprise contact firstname.lastname@example.org. PipelineDB is free, open-source, and offered under the GPLv3 license. It can be downloaded from the company’s website at www.pipelinedb.com.
PipelineDB is the leader in streaming analytics database technology. Their open-source relational database runs SQL queries continuously on streaming data and is used by the world’s leading companies to power realtime analytics systems. The company is based in San Francisco, CA and is backed by prominent Silicon Valley investors including Y-Combinator, SV Angel, Data Collective, Susa Ventures, and others.
Follow us on twitter @pipelinedb or email us at email@example.com for more information.
President and Co-Founder
Full View / NID: 57661 / Submitted by: The Zilla of Zuron
PremiumSoft today released an upgraded version of Navicat for PostgreSQL version 11.2, with full support for PosgreSQL 9.5.
In the latest version of Navicat for PostgreSQL, version 11.2 is introducing a new feature - PL/PGSQL Code Debugger and Navicat Cloud Collaboration, a newly developed solution to help teams work better together.
"Navicat Cloud is a cloud-based solution that will align your development team for better collaboration and across platforms” said Ken Lin, Software Development Director at PremiumSoft CyberTech Ltd. "Navicat Cloud portal is an excellent solution that allows team members to instantly view a project shared by a colleague without a Navicat license, while the Desktop and iOS applications allow you to manage your projects such as sharing connections, queries and models.
Major New Features:
- Navicat Cloud Collaboration
- Create/Modify/Delete projects.
- Add members to project for sharing connection settings, queries and models.
- View Project Activity Log.
- PostgreSQL Objects
- Support Foreign Server with User Mapping.
- Support Foreign Table.
- Support PostgreSQL Debugger.
- Enhanced Object Designers.
- Data Modeling Tool
- Support Model Conversion.
- Support Views.
- Enhanced Table Designer.
Navicat Cloud Collaboration Capabilities
With Navicat Cloud Collaboration, Navicat customers now have the ability to invite a colleague to work together on a project— to assign roles to members and have visibility into the activities in the Activity Log.
Plans, Pricing and Availability
Starting today, Navicat Cloud will be available for all new and existing Navicat customers— Navicat Cloud Basic Plan (free) includes up to 150 units of storage & 3 projects; Navicat Cloud Pro Plan features 5,000 units of storage & up to 500 projects for US$9.99 per month / US$99 per year. For more details, please visit: http://www.navicat.com/navicat-cloud
A Free 14-day Trial is also available for download, for more details please go to : http://www.navicat.com/download/navicat-for-postgresql
To learn more about Navicat for PostgreSQL, please visit: http://www.navicat.com/products/navicat-for-postgresql
To learn more about Navicat Cloud Collaboration, please visit: http://www.navicat.com/navicat-collaboration
Navicat develops the leading database management and development software. One of its top-rated products, Navicat Premium, allows you to access up to 6 databases all-in-one including MySQL, MariaDB, SQL Server, SQLite, Oracle, and PostgreSQL, eliminating workflow disruption to leverage users’ time and increasing productivity and efficiency.
PremiumSoft CyberTech Ltd. is a multinational corporation headquartered in Hong Kong, the company was founded in 1999 and has developed numerous award-winning products over the years.
Full View / NID: 57647 / Submitted by: The Zilla of Zuron
I am happy to announce the new major release of dbMigration .NET v2.
It is a simple, easy and intuitive multiple database migration and sync tool ,
With it you can easily migrate schema and data between different databases without complicated procedures.
Supported databases: PostgreSQL, SQL Server, SQL Azure, LocalDB, MySQL, Oracle, IBM DB2, Informix,
HP Vertica, NuoDB, Teradata, Sybase ASE, Firebird, SQLite, SQLCe, Access, dBase, FoxPro...etc.
Free, All-In-One, Portable, and Single executable file.
Major New features from version 1.1 to 2.3:
- Compatible with PostgreSQL 9.5
- Updated to Npgsql.dll 2.2.7
- Added Data Synchronization
- Excel, Generic ODBC and Generic OleDB support
- VIEW Objects support
- Added Automatically create indexes
- Added Saving Changes
- Added Skipping error rows
- Improved Automatically match columns
- Change Password prompt dialog when password expired
- Added Selecting multiple columns to Edit
- Added Auto Completion for Filter
- UPPERCASE and lowercase support
- Improved Automatic column matching
- Improved Filter source data
- (Command-Line) Default Confirmation Options (if the target table exists): -defopt:[rename/recreate/delete/append/sync]
- (Command-Line) Log mode and No window (DBMigration.log): -log
- (Command-Line) Exit Code: Success=0, Failure=1
- (Command-Line) Automatically create a target database (Firebird/SQLite/Access/SQLCe/Excel)
- (Command-Line) Automatically add source and target connections (Firebird/SQLite/Access/SQLCe/Excel/FoxPro/OleDB)
- ...and more
The new version is immediately available for download.
Full View / NID: 57597 / Submitted by: The Zilla of Zuron
Postgres Professional (Postgres Pro), the Russian PostgreSQL company, has prepared binary Windows® builds of PostgreSQL. Versions 9.5.0 and 9.4.5 are available for download at http://postgrepro.com/windows. The installer sources are on github.
The installer sources contain the complete build scripts set. This allows everybody to build custom variants of PostgreSQL with any versions of all the required libraries including openssl, perl or python.
Full View / NID: 57609 / Submitted by: The Zilla of Zuron
2ndQuadrant is pleased to announce the General Availability release of 2UDA 9.5.
2UDA (2ndQuadrant Unified Data Analytics) is a data analytics application suite that unifies databases, spreadsheets, data mining and visualisation in one seamless desktop installer.
This new release continues to provide easy installation of three open source applications for visual data analysis: PostgreSQL 9.5, Orange 3, and LibreOffice 5, which together offer a powerful combination of database, data visualization and spreadsheet in a single, easy-to-use package.
Following the General Availability release of PostgreSQL 9.5, the development team are pleased to offer a number of improvements to take advantage of the latest PostgreSQL features, creating a highly stable product and fixing discovered and reported bugs in previous releases of 2UDA.
Full release notes for 2UDA 9.5 are available at http://packages.2ndquadrant.com/2UDA/ReleaseNotes_9.5-GA_20160107.txt
We are particularly appreciative of users trialling 2UDA and providing valuable feedback to the development team, on all of the previous pre-GA releases. This has helped us to build a robust software package, the result of which is 2UDA 9.5.
2UDA 9.5 is available to download at http://2ndQuadrant.com/2uda
You’ll also find more details about the 2UDA project, including a tutorial to download.
Full View / NID: 57598 / Submitted by: The Zilla of Zuron
The PHP development team announces the immediate availability of PHP 5.5.31. This is a security release. Several security bugs were fixed in this release. All PHP 5.5 users are encouraged to upgrade to this version. For source downloads of PHP 5.5.31 please visit our downloads page, Windows binaries can be found on windows.php.net/download/. The list of changes is recorded in the ChangeLog.
Full View / NID: 57574 / Submitted by: The Zilla of Zuron
The PHP development team announces the immediate availability of PHP 5.6.17. This is a security release. Several security bugs were fixed in this release. All PHP 5.6 users are encouraged to upgrade to this version. For source downloads of PHP 5.6.17 please visit our downloads page, Windows binaries can be found on windows.php.net/download/. The list of changes is recorded in the ChangeLog.
Full View / NID: 57573 / Submitted by: The Zilla of Zuron
7 JANUARY 2016: The PostgreSQL Global Development Group announces the release of PostgreSQL 9.5. This release adds UPSERT capability, Row Level Security, and multiple Big Data features, which will broaden the user base for the world's most advanced database. With these new capabilities, PostgreSQL will be the best choice for even more applications for startups, large corporations, and government agencies.
Annie Prévot, CIO of the CNAF, the French Child Benefits Office, said, "The CNAF is providing services for 11 million persons and distributing 73 billion Euros every year, through 26 types of social benefit schemes. This service is essential to the population and it relies on an information system that must be absolutely efficient and reliable. The CNAF's information system is satisfyingly based on the PostgreSQL database management system."
A most-requested feature by application developers for several years, "UPSERT" is shorthand for "INSERT, ON CONFLICT UPDATE", allowing new and updated rows to be treated the same. UPSERT simplifies web and mobile application development by enabling the database to handle conflicts between concurrent data changes. This feature also removes the last significant barrier to migrating legacy MySQL applications to PostgreSQL.
Developed over the last two years by Heroku programmer Peter Geoghegan, PostgreSQL's implementation of UPSERT is significantly more flexible and powerful than those offered by other relational databases. The new ON CONFLICT clause permits ignoring the new data, or updating different columns or relations in ways which will support complex ETL (Extract, Transform, Load) toolchains for bulk data loading. And, like all of PostgreSQL, it is designed to be absolutely concurrency-safe and to integrate with all other PostgreSQL features, including Logical Replication.
Row Level Security
PostgreSQL continues to expand database security capabilities with its new Row Level Security (RLS) feature. RLS implements true per-row and per-column data access control which integrates with external label-based security stacks such as SE Linux. PostgreSQL is already known as "the most secure by default." RLS cements its position as the best choice for applications with strong data security requirements, such as compliance with PCI, the European Data Protection Directive, and healthcare data protection standards.
RLS is the culmination of five years of security features added to PostgreSQL, including extensive work by KaiGai Kohei of NEC, Stephen Frost of Crunchy Data, and Dean Rasheed. Through it, database administrators can set security "policies" which filter which rows particular users are allowed to update or view. Data security implemented this way is resistant to SQL injection exploits and other application-level security holes.
Big Data Features
PostgreSQL 9.5 includes multiple new features for bigger databases, and for integrating with other Big Data systems. These features ensure that PostgreSQL continues to have a strong role in the rapidly growing open source Big Data marketplace. Among them are:
BRIN Indexing: This new type of index supports creating tiny, but effective indexes for very large, "naturally ordered" tables. For example, tables containing logging data with billions of rows could be indexed and searched in 5% of the time required by standard BTree indexes.
Faster Sorts: PostgreSQL now sorts text and NUMERIC data faster, using an algorithm called "abbreviated keys". This makes some queries which need to sort large amounts of data 2X to 12X faster, and can speed up index creation by 20X.
CUBE, ROLLUP and GROUPING SETS: These new standard SQL clauses let users produce reports with multiple levels of summarization in one query instead of requiring several. CUBE will also enable tightly integrating PostgreSQL with more Online Analytic Processing (OLAP) reporting tools such as Tableau.
Foreign Data Wrappers (FDWs): These already allow using PostgreSQL as a query engine for other Big Data systems such as Hadoop and Cassandra. Version 9.5 adds IMPORT FOREIGN SCHEMA and JOIN pushdown making query connections to external databases both easier to set up and more efficient.
TABLESAMPLE: This SQL clause allows grabbing a quick statistical sample of huge tables, without the need for expensive sorting.
"The new BRIN index in PostgreSQL 9.5 is a powerful new feature which enables PostgreSQL to manage and index volumes of data that were impractical or impossible in the past. It allows scalability of data and performance beyond what was considered previously attainable with traditional relational databases and makes PostgreSQL a perfect solution for Big Data analytics," said Boyan Botev, Lead Database Administrator, Premier, Inc.
PostgreSQL Press Team
Phone: +1 (347) 674-7759
PostgreSQL is the world's most advanced database system, with a global community of thousands of users and contributors and dozens of companies and organizations. The PostgreSQL Project builds on over 25 years of engineering, starting at the University of California, Berkeley, and has an unmatched pace of development today. PostgreSQL's mature feature set not only matches top proprietary database systems, but exceeds them in advanced database features, extensibility, security and stability. Learn more about PostgreSQL and participate in our community at: http://www.postgresql.org.
Full View / NID: 57572 / Submitted by: The Zilla of Zuron
2ndQuadrant is pleased to announce the availability of pglogical, the next generation in replication systems for PostgreSQL.
pglogical offers Logical Replication as a PostgreSQL extension, which provides the flexibility of trigger-based replication with the efficiency of log-based replication. This ground-breaking new technology has benefits for many key use cases, including:
- UPGRADE Upgrade PostgreSQL from 9.4 to 9.5, without downtime
- SCALE OUT Copy all or a selection of database tables to other nodes in a cluster
- AGGREGATE Accumulate changes from sharded database servers into a Data Warehouse
- INTEGRATE Feed database changes in real-time to other systems
- PROTECT Provide backup or high availability for clusters, replacing earlier technologies
Existing PostgreSQL users will find the efficiency of pglogical particularly exciting with preliminary testing demonstrating a significant increase in transaction throughput (without lag) over other replication methods. For example, pglogical performed up to 5 times faster than Slony and Londiste3 on OLTP workloads using
For more details and access to binary packages for both the current stable release PostgreSQL 9.4 and the soon to be announced PostgreSQL 9.5 version, visit http://2ndquadrant.com/pglogical/
Full View / NID: 57517 / Submitted by: The Zilla of Zuron
The MicroOLAP team is proud to introduce Database Designer for PostgreSQL with full support for PosgreSQL 9.5, an comprehensive CASE tool with intuitive graphical interface allowing you to
- build a clear and effective database structure visually,
- see the complete picture (diagram) representing all the tables, references between them, views, stored procedures and other objects,
- easily generate a physical database on a server,
- modify it according to any changes you made to the diagram using fast ALTER statements,
- import already existing diagram from a server,
- export diagram to common graphic formats or as SQL script,
- create detailed printings and reports.
This minor release introduces support for upcoming PostgreSQL 9.5 and provides new SSH tunneling facility out of the box. Several bugs were fixed as well.
You're welcome to download the Database Designer for PostgreSQL 1.11.0 right now at: http://microolap.com/products/database/postgresql-designer/download/
Please don't hesitate to ask any questions or report bugs with our Support Ticketing system available at
- [!] PostgreSQL 9.5 support added
- [!] Brand new SSH tunneling introduced
- [!] BRIN indexes support added
- [!] SPGIST indexes support added
- [*] "Cannot populate environment settings" message now more descriptive
- [-] "Default value for domain contains newline character if edited with advanced SQL Editor" bug fixed
- [-] "Rare Access Violation error during application close" bug fixed
- [-] "Secutiry type value incorrect in Stored Routine Manager" bug fixed
- [-] "SSL connection options ignored sometimes" bug fixed
- [-] "Stored routine Window function option may have incorrect value after reopening model" bug fixed
- [-] Rare EExternalException errors fixed
Full View / NID: 57518 / Submitted by: The Zilla of Zuron
The JDBC team is proud to announce that after substantial effort by Stephen Nelson, and Vladimir Sitnikov that the project has been converted to a Maven project.
Maven enables working on the code in your favourite IDE much easier.
Release notes can be found here
Full View / NID: 57470 / Submitted by: The Zilla of Zuron
2ndQuadrant is pleased to announce the release of the RC1 version of 2UDA (2ndQuadrant Unified Data Analytics). 2UDA is a data analytics application suite that unifies databases, spreadsheets, data mining and visualisation in one seamless desktop installer.
This new release continues to provide easy installation of three open source applications for visual data analysis: PostgreSQL 9.5 RC1, Orange 3.2. and LibraOffice 5.0, which together offer a powerful combination of database, data visualization and spreadsheet in a single, easy-to-use package.
Following the initial release of 2UDA Beta 1 back in October and subsequent release of Beta 2 in November, the development team have continued to make lots of improvements, creating a highly stable product and fixing all of the bugs discovered to date.
Significant improvements to Orange address the requests for additional features and now include:
A 'Report' button that can prepare reports of performed analyses.
Data loading from Google Sheets URLs
New widgets added: Distance Transformation, Random Forest
Regression, Regression Tree, Regression Tree Graph.
For more details on all the new features and enhancements, refer to the release notes.
We are particularly appreciative of the people trialling 2UDA and providing valuable feedback to the development team, for both the beta 1 release and more recently beta 2.
This is helping us build a robust software package ahead of GA in January 2016. We encourage everyone to continue to test 2UDA as new versions are released and give us your feedback.
2UDA RC1 is available to download at http://2ndquadrant.com/2uda
You’ll also find more details about the 2UDA project, including a tutorial to download.
Release notes can be viewed at http://packages.2ndquadrant.com/2UDA/ReleaseNotes_9.5-RC1_20151218.txt
Full View / NID: 57437 / Submitted by: The Zilla of Zuron
The PostgreSQL Global Development Group announces that the first release candidate is available for download. This release should fix all outstanding issues with PostgreSQL 9.5, and be identical to the final release, pending bug fixes. All users intending to upgrade to PostgreSQL 9.5 should download and try PostgreSQL 9.5 RC1 now.
Changes Since Beta2
All outstanding issues and known bugs in version 9.5 have been fixed in this release. As such, any issues you encounter are new and should be reported to us. Fixes since Beta2 include:
- Fixed issues in multxact truncation behavior
- Prevent incorrect trigger invocation in UPSERT
- Fixed password handling by multiprocess vacuumdb
- Made Foreign join pushdown work with EvalPlanQual
- Fixed bug in track_commit_timestamp
- Drop policies with objects during DROP OWNED
- Make pg_rewind work if both servers are on the same timeline
If you reported an issue while testing PostgreSQL 9.5, please download RC1 and test whether that issue has been fixed. If you have not yet tested version 9.5, now is the time for you to help out PostgreSQL development.
This is the first release candidate of 9.5, indicating that it is expected to be identical to the final release. If new major issues are found, the PostgreSQL project will release additional release candidates. Otherwise, 9.5.0 will be released in early January. For more information, and suggestions on how to test the release candidate, see the Beta Testing page.
Full documentation and release notes of the new version is available online and also installs with PostgreSQL. Also see the What's New page for details on some features.
Full View / NID: 57422 / Submitted by: The Zilla of Zuron
SQL Maestro Group announces the release of PostgreSQL PHP Generator 15.12, a powerful GUI frontend for Windows that allows you to generate feature-rich CRUD web applications for your PostgreSQL database.
The new version is immediately available at
Top 15 new features:
- New modern look and feel.
- 100% responsive design.
- PHP 7 support.
- Top side drop-down menus.
- Enhanced Filter Builder.
- Multi-column sorting.
- Keyboard shortcuts.
- A number of new and updated controls.
- 18 color themes.
- Font-based icons.
- Event management enhancements.
- Less preprocessor syntax for user-defined styles.
- HTML filter.
- New and updated data access drivers.
- PHP Generator UI improvements.
There are also some other useful things. Full press release is available at the SQL Maestro Group website.
Full View / NID: 57389 / Submitted by: The Zilla of Zuron
Paris, December 07 2015
DALIBO is proud to present the third release of PoWA, the PostgreSQL Workload
Realtime traffic analysis and dynamic graphs
PoWA is a workload analyzer that gives a clear view of the activity of
your PostgreSQL servers with a query runtime graph and a block hit/read graph
along with a chart of time-consuming queries over the specified time period.
If you zoom anywhere in one of the graphs, the chart will adjust and show you
which queries were running at that time. If you click on a specific query, you
will get additional graphs such as read/write time, number of rows affected,
local and shared hit, etc.
Better predicate analyzer
The pg_qualstats extension stores
new counters. It's now possible to know the most executed predicates in
relation to all the related queries. It also tracks non-normalized queries so
that it’s possible to execute an EXPLAIN of any query tracked by pg_stat_statements.
Database global optimization
PoWA is now able to use statistics about every predicate used by any query
executed on a database to suggest the smallest index set that optimizes every one of those predicates.
In particular, the heuristics place heavy emphasis in consolidating many
indexes into one by giving preference to definitions spanning multiple
columns. This can provide new information about the actual load and correlation
between predicates that are traditionally hard to discover for the DBA.
Index suggestion check
Thanks to the HypoPG extension, the benefits of the
suggested index creations can automatically be checked by running the queries
against hypothetical indexes.
You can see instantly if the suggested index is relevant and how much it'll
improve the query.
DALIBO would like to thank the users and developers who contributed to this
PoWA is an open project available under the PostgreSQL License. Any
contribution to build a better tool is welcome. You just have to send your
ideas, patches or features requests using the GitHub tools or to firstname.lastname@example.org
For PoWA 3.0.0:
For the stats extensions:
PoWA is PostgreSQL Workload Analyzer that gathers performance stats and
provides real-time charts and graph to help monitor and tune your PostgreSQL
Code & Demo at dalibo.github.io/powa
DALIBO is the leading PostgreSQL company in France, providing support,
trainings and consulting to its customers since 2005. The company contributes
to the PostgreSQL community in various ways, including : code, articles,
translations, free conferences and workshops.
Check out DALIBO's open source projects at dalibo.github.io
Full View / NID: 57230 / Submitted by: The Zilla of Zuron