PostgreSQL News

Syndicate content
PostgreSQL news
Updated: 24 weeks 4 days ago

ByteDesigner version 2.3 is available

11 January, 2015 - 03:00

NipData, the provider of data modeling, presentation and integration software, is very pleased to announce the release of ByteDesigner 2.3.

See the entire news here: http://www.nipdata.com/news/

ByteDesigner is the emerging enterprise tool for designing databases at all levels of an organization, using the same concepts found in tools costing thousands of dollars!

Its a powerful database design tool, with advanced SQL Editor, and support for all major RDBMS, that can design complex systems.

Online documentation is found here: http://www.nipdata.com/faq/byte-designer-manual.html

Supported platforms (13): Linux (Intel and PowerPC), Solaris(Intel and Sparc), Windows (Intel),
Mac OS X(Intel and PowerPC)
for both 32 and 64 bit.

Databases supported (9): Oracle, ODBC, SQL92, MySQL, PostgreSQL, DB2, FireBird, MS SQL, SQLBase

DBD::Pg 3.5.0 released

7 January, 2015 - 03:00

The latest version of DBD::Pg, the Perl driver for Postgres, has been released. This version includes a much improved ping() method, and support for the new backslash-escaped placeholders, which will make working with things such as JSON much easier. The latest version can always be found on CPAN.

MicroOLAP Database Designer meets PostgreSQL 9.4

23 December, 2014 - 03:00

The MicroOLAP team is proud to introduce Database Designer for PostgreSQL with full support for PosgreSQL 9.4, 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 release introduces support for the latest v9.4 SQL grammar. Among other important features JSONB type support were added. Modify Engine allows creating indexes CONCURRENTLY. Several non critical bugs fixed. Download

You're welcome to download the Database Designer for PostgreSQL 1.10.3 right now at: http://microolap.com/products/database/postgresql-designer/download/

Feedback

Please don't hesitate to ask any questions or report bugs with our Support Ticketing system available at http://www.microolap.com/support/

Full changelog:
  • [!] PostgreSQL 9.4 support added
  • [+] Allow creating indexes CONCURRENTLY using Modify script
  • [+] JSONB type support added
  • [*] Primary column removed from Column Manager
  • [*] Support for ENUM types improved in Column Manager
  • [*] uuid[] type added to editors
  • [-] "Quote Default Value option not saved in Column Manager" bug fixed

Bucardo 5.3.0 released

22 December, 2014 - 03:00

Bucardo, a multiple source, multiple target replication system, has released version 5.3.0. The 'makedelta' system has been improved, and allows setting of makedelta at the database level. Bucardo can be downloaded from the Bucardo wiki

Database .NET 14.0 released

19 December, 2014 - 03:00

I am happy to announce the new major release of Database .NET 14.0, an innovative, powerful and intuitive multiple database management tool, With it you can Browse objects, Design tables, Edit rows, Export data and Run queries with a consistent interface.

Free, All-In-One, Portable, Single executable file and Multi-language.

Major New features from version 12.7 to 14.0:

  • Compatible with PostgreSQL 9.4
  • Compatible with Microsoft Windows 10
  • Updated to Npgsql.dll 2.2.3
  • Additional Features for all users (Autocomplete/Query Builder/SQL Profiler/Database Diagram/Cell and Form Editor)
  • Added Binding Procedure and Function parameters
  • Added Binding SQL variables
  • Added (De)Compression and (De)Encoding strings
  • Added [ADV] Advanced Browsing Options
  • Added [ADV] Advanced Edit Options
  • Added [ADV] Advanced Search Options
  • Added Column Properties
  • Added Exporting and Displaying Hexadecimal string
  • Added Restoring last object location
  • And more...
The new version is immediately available for download.

PostgreSQL 9.4 Increases Flexibility, Scalability and Performance

18 December, 2014 - 03:00

18 DECEMBER 2014: The PostgreSQL Global Development Group announces the release of PostgreSQL 9.4, the latest version of the world's leading open source database system. This release adds many new features which enhance PostgreSQL's flexibility, scalability and performance for many different types of database users, including improvements to JSON support, replication and index performance.

Flexibility

With the new JSONB data type for PostgreSQL, users no longer have to choose between relational and non-relational data stores: they can have both at the same time. JSONB supports fast lookups and simple expression search queries using Generalized Inverted Indexes (GIN). Multiple new support functions enable users to extract and manipulate JSON data, with a performance which matches or surpasses the most popular document databases. With JSONB, table data can be easily integrated with document data for a fully integrated database environment.

"JSONB brings PostgreSQL to the JavaScript development community by allowing JSON data to be stored and queried natively. Node.js and other server-side JavaScript frameworks can benefit from the safety and robustness of PostgreSQL, while still storing data in the schema-less format that they prefer," said Matt Soldo, Product Manager, Heroku Postgres.

Scalability

In 9.4, Logical Decoding supplies a new API for reading, filtering and manipulating the PostgreSQL replication stream. This interface is the foundation for new replication tools, such as Bi-Directional Replication, which supports the creation of multi-master PostgreSQL clusters. Other improvements in the replication system, such as replication slots and time-delayed replicas, improve management and utility of replica servers.

"The main reason behind our immediate adoption of PostgreSQL 9.4 in production is the new Logical Decoding feature," said Marco Favale, Cartographic Production Manager of Navionics. "The ability to write custom and flexible output plugins will allow us to transparently collect changes on selected tables and replicate changes where we like, by removing heavier - and more complex to manage - trigger based replication solutions."

"Zalando relies on the stability and performance of hundreds of PostgreSQL database servers to continuously serve millions of customers all around Europe," said Valentine Gogichashvili, Team Lead Database Operations at Zalando Technologies. "We are excited to run time-delayed standby servers which work out of the box, and will evaluate the new bi-directional replication tools as soon as they are released."

Performance

Version 9.4 also introduces multiple performance improvements which will allow users to get even more out of each PostgreSQL server. These include:

  • Improvements to GIN indexes, making them up to 50% smaller and up to 3X faster.
  • Concurrently updatable Materialized Views for faster, more up-to-date reporting.
  • Rapidly reload the database cache on restart using pg_prewarm.
  • Faster parallel writing to the PostgreSQL transaction log.
  • Support for Linux Huge Pages for servers with large memory.

"We will definitely benefit from concurrent refresh of materialised views, delayed standby servers (which will make our disaster recovery even more robust) as well as the usual performance improvements every new release carries on," added Marco Favale.

Links About PostgreSQL

PostgreSQL is the leading open source 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 on our web page.

FOSDEM PGDay 2015 and Devroom - Schedule posted and registration open

9 December, 2014 - 03:00

We have finished the schedule for FOSDEM PGDay and the PostgreSQL Devroom at FOSDEM 2015 - our apologies for the delay in processing!

You will find a number of great talks both on PostgreSQL usage and development from great speakers. And of course, it will as usual feature the Hallway Track, where you can network with fellow PostgreSQL users!

We have also opened registration. Number of seats are limited, and as we sold out last year, we recommend that you make your reservation as soon as possible. Registration is €50 for all attendees for the PGDay on Friday. No registration is necessary if you only want to attend the Devroom at FOSDEM on Saturday.

Finally, we'd like to remind you that our rate with the conference hotel (Marriott Brussels) will expire on Dec 15th. Therefore, we recommend that you book your accommodations as soon as possible!

We hope to see you in Brussels in January!

PostgreSQL 9.4 RC1 Released

20 November, 2014 - 03:00

The PostgreSQL Global Development Group has released 9.4 RC 1, the first release candiate for the next version of PostgreSQL. This release should be identical to the final version of PostgreSQL 9.4, excepting any fixes for bugs found in the next two weeks. Please download, test, and report what you find.

For a full listing of the features in version 9.4, please see the release notes. Additional descriptions and notes on the new features are available on the 9.4 Features Wiki Page.

We depend on our community to help test the next version in order to guarantee that it is high-performance and bug-free. Please download PostgreSQL 9.4 RC 1 and try it with your workloads and applications as soon as you can, and give feedback to the PostgreSQL developers. Features and APIs in this release candidate should be identical to 9.4.0, allowing you to build and test your applications against it. More information on how to test and report issues

Get the PostgreSQL 9.4 RC 1, including binaries and installers for Windows, Linux and Mac from our download page.

Full documentation of the new version is available online, and also installs with PostgreSQL.

PostgreSQL PHP Generator 14.10 released

5 November, 2014 - 03:00

SQL Maestro Group announces the release of PostgreSQL PHP Generator 14.10, 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:
http://www.sqlmaestro.com/products/postgresql/phpgenerator/

Online demo: http://demo.sqlmaestro.com/

Top 10 new features:
  1. New and updated controls.
  2. Enhanced JavaScript API.
  3. New security-related features.
  4. Extended template management.
  5. Multi-group menus.
  6. New application-level events.
  7. Custom CSS and JavaScript.
  8. Usability improvements.
  9. PHP Generator UI enhancements.
  10. Support for PHP 5.6 and other core features.

There are also some other useful things. Full press release is available at the SQL Maestro Group website.

POWA 1.2 is out !

28 October, 2014 - 03:00

DALIBO is proud to present a new release of POWA, a performance tool for PostgreSQL.

Realtime traffic analysis and dynamic graphs

POWA is a workload analyzer that gives a clear view of the current activity of your PostgreSQL servers with a query runtime graph and a block hit/read graph along with a chart of time consuming requests 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.

A bunch of PL functions are also available to access and manage the stats.

New metrics and a better UI

This release includes some new features and some fixes since the first public release.

The core is responsible of statistics gathering. It relies on pg_stat_statements. As a first change, in order to avoid storing useless informations, DEALLOCATE and BEGIN statements are now ignored by the core. The snapshot timestamps were fixed. In order to ease backups and diagnostics, now PoWA history tables are now marked as "to be dumped" by pg_dump. Performance for "per database aggregated stats" were also improved. And last thing, some more metrics were made available throught the SQL API : temporary data, I/O time, average runtime.

The UI was also improved. In addition to displaying the new available metrics, several features were added. First, the UI follows the selected time interval from page to page. The displayed metrics are now human readable. Also, the query metrics are now displayed on each query page. Each page now has a different title, regarding its context. In order to get a better display area, the original database selector as been removed. A menu entry now permits the user to navigate between databases. Several bugs were fixed, like the empty graph bug. Note that the configuration file has changed since the previous release.

For the complete list of changes, please checkout the release notes

For complete installation and upgrading instructions, please checkout the documentation

Credits

DALIBO would like to thank the users and developers who contributed to this release, especially Christopher Liu, menardorama, Victor D, Justin Miller, Arthur Lutz.

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, features requests or patches using the GitHub tools or directly to powa@dalibo.com

Links

Download : http://dalibo.github.io/powa/

Demo : http://demo-powa.dalibo.com (login/pass = powa/demo)

About POWA

PoWA is PostgreSQL Workload Analyzer that gathers performance stats and provides real-time charts and graph to help monitor and tune your PostgreSQL servers. It is similar to Oracle AWR or SQL Server MDW.

Code & Demo at http://dalibo.github.io/powa/

About DALIBO

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 http://dalibo.github.io