Make Homepage | Add To Favorites | Print Page | Submit News | Feedback | Contact | 

Your Technical Computer Information Resource!  
     
  Open Source Technical Updates [Page: 6 of 72] @ TACKtech Corp.  

03.29.2016 - PL/Java 1.5.0 announced; security note.



View PostgreSQL-Press related news.

PL/Java brings functions, triggers, and types in Java. 1.5.0 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

Security note:

Several security issues are addressed in PL/Java 1.5.0, as described in the release notes, so sites running earlier versions are encouraged to update. The release notes also describe practical mitigations to reduce risk until an update can be completed.

Platforms:

PL/Java 1.5.0 works with Java 8, 7, or 6 and all 9.x PostgreSQL versions as well as 8.4. To support projects based on older PostgreSQL forks, PL/Java 1.5.0 is also intended to build with 8.3 and 8.2, but has not been tested on those versions.

PL/Java 1.5.0 resolves reported build issues on several platforms, and new sections of the build documentation specifically cover Mac OS X, Solaris, Ubuntu, and Windows (using Visual Studio or MinGW-64). FreeBSD 10.2 or later is expected to work but has not been tested.

Changes:

PL/Java 1.5.0 brings more complete, usable, and documented capability for Java-implemented user-defined base types, composite types, and mirrors of existing PostgreSQL types, an annotation-driven SQL generator reducing the effort of writing deployment SQL by hand, and many smaller improvements and fixes detailed in the release notes. The supplied examples cover many of these features.

Availability:

PL/Java 1.5.0 is available from GitHub as a source release, which builds quickly using Maven:

Release page: https://github.com/tada/pljava/releases/tag/V1_5_0

This wiki page will add links to prebuilt packages that become available.

Many thanks to all the individuals and organizations listed in the release notes under Credits.

Full View / NID: 58754 / Submitted by: The Zilla of Zuron

03.24.2016 - PostgreSQL PHP Generator 16.3 released



View PostgreSQL-Press related news.

SQL Maestro Group announces the release of PostgreSQL PHP Generator 16.3, 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/.

Live demo and Video tour are available too.

Top 10 new features:

  1. Out-of-the-box Charts.
  2. Enhanced sidebar menus.
  3. Compact themes.
  4. Embedded Video support.
  5. Customizable success/error messages.
  6. Enhanced data export tools.
  7. Custom form titles.
  8. Event management enhancements.
  9. Detailed descriptions.
  10. PHP configuration settings.

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

Full View / NID: 58701 / Submitted by: The Zilla of Zuron

03.21.2016 - Database .NET v18 released



View PostgreSQL-Press related news.

I am happy to announce the new major release of Database .NET v18. It is an innovative, powerful and intuitive multiple database management tool, With it you can browse objects, design tables, edit rows, export data, run queries and migrate data with a consistent interface.

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

Major New features from version 17.1 to 18.0:

  • Compatible with PostgreSQL 8.4 ~ 9.5+
  • Added Visual Execution Plan for PostgreSQL 9.0+
  • Massive performance improvements
  • Added support for Cancelling executing command
  • Added Inspect Object
  • Added Dark Mode
  • Added support for Renaming Results tab
  • Single click for Browsing and Editing
  • Improved Data Import and Export
  • Improved Data Editor and Browser
  • Improved Generating Batch Scripts
  • Improved SQL Editor
  • Improved AutoComplete and IntelliSense
  • Improved SQL File Version Control
  • Improved Database Migration and Data Synchronization (Pro)
  • ...and more

The new version is immediately available for download.

Full View / NID: 58681 / Submitted by: The Zilla of Zuron

03.03.2016 - PHP 5.5.33 is available



View PHP related news. The PHP development team announces the immediate availability of PHP 5.5.33. This is a security release in which two security bugs were fixed. All PHP 5.5 users are encouraged to upgrade to this version. For source downloads of PHP 5.5.33 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: 58373 / Submitted by: The Zilla of Zuron

03.03.2016 - PHP 5.6.19 is available



View PHP related news. The PHP development team announces the immediate availability of PHP 5.6.19. This is a security release in which several security bugs were fixed. All PHP 5.6 users are encouraged to upgrade to this version. For source downloads of PHP 5.6.19 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: 58372 / Submitted by: The Zilla of Zuron

02.29.2016 - Barman 1.6.0 released



View PostgreSQL-Press related news.

29 February 2016: 2ndQuadrant is proud to announce the release of version 1.6.0 of Barman, Backup and Recovery Manager for PostgreSQL.

Major release

This major release introduces WAL streaming support, improving disaster recovery capabilities of PostgreSQL backup solutions based on Barman, by reducing Recovery Point Objective consistently to nearly 0. Currently, Barman still requires standard WAL archiving based on PostgreSQL's 'archive_command'. This limitation will be removed once Barman supports replication slots (available from PostgreSQL 9.4).

Barman 1.6.0 introduces also support to pigz compression, as well as Python-native gzip and bzip2 compression algorithms.

Bug fixes

Minor bugs have also been fixed.

For a complete list of changes, see the "Release Notes" section below.

Links

Release notes

  • Support for streaming replication connection through the 'streaming_conninfo' server option

  • Support for the 'streaming_archiver' option that allows Barman to receive WAL files through PostgreSQL's native streaming protocol. When set to 'on', it relies on 'pg_receivexlog' to receive WAL data, reducing Recovery Point Objective. Currently, WAL streaming is an additional feature (standard log archiving is still required)

  • Implement the 'receive-wal' command that, when 'streaming_archiver' is on, wraps 'pg_receivexlog' for WAL streaming. Add '--stop' option to stop receiving WAL files via streaming protocol. Add '--reset' option to reset the streaming status and restart from the current xlog in Postgres.

  • Automatic management (startup and stop) of 'receive-wal' command via 'cron' command

  • Support for the 'path_prefix' configuration option

  • Introduction of the 'archiver' option (currently fixed to 'on') which enables continuous WAL archiving for a specific server, through log shipping via PostgreSQL's 'archive_command'

  • Support for 'streaming_wals_directory' and 'errors_directory' options

  • Management of WAL duplicates in 'archive-wal' command and integration with 'check' command

  • Verify if 'pg_receivexlog' is running in 'check' command when 'streaming_archiver' is enabled

  • Verify if failed backups are present in 'check' command

  • Accept compressed WAL files in incoming directory

  • Add support for the pigz compressor (thanks to Stefano Zacchiroli)

  • Implement pygzip and pybzip2 compressors (based on an initial idea of Christoph Moench-Tegeder)

  • Creation of an implicit restore point at the end of a backup

  • Current size of the PostgreSQL data files in 'barman status'

  • Permit 'archive_mode=always' for PostgreSQL 9.5 servers (thanks to Christoph Moench-Tegeder)

  • Complete refactoring of the code responsible for connecting to PostgreSQL

  • Improve messaging of cron command regarding sub-processes

  • Native support for Python >= 3.3

  • Changes of behaviour:

    • Stop trashing WAL files during 'archive-wal' (commit:e3a1d16)
  • Bug fixes:
    • Atomic WAL file archiving (#9 and #12)
    • Propagate "-c" option to any Barman subprocess (#19)
    • Fix management of backup ID during backup deletion (#22)
    • Improve 'archive-wal' robustness and log messages (#24)
    • Improve error handling in case of missing parameters

Download

About

Barman (Backup and Recovery Manager) is an open source administration tool for disaster recovery of PostgreSQL servers written in Python. It allows your organisation to perform remote backups of multiple servers in business critical environments and help DBAs during the recovery phase. Barman's most requested features include backup catalogues, incremental backup, retention policies, remote backup and recovery, archiving and compression of WAL files and backups. Barman is distributed under GNU GPL 3.

Full View / NID: 58323 / Submitted by: The Zilla of Zuron

02.19.2016 - JDBC 1208 released



View PostgreSQL-Press related news.

Mostly bug fixes and cleanup.

See the changelog for details

Full View / NID: 58180 / Submitted by: The Zilla of Zuron

02.18.2016 - Postgres-XL 9.5 R1 Beta1 Announced



View PostgreSQL-Press related news.

The Postgres-XL community is pleased to announce Postgres-XL 9.5 R1 Beta1.

Postgres-XL is a massively parallel database built on top of, and very closely compatible with PostgreSQL 9.5 and its set of advanced features. Postgres-XL is fully open source and many parts of it will feed back directly or indirectly into later releases of PostgreSQL, as we begin to move towards a fully parallel sharded version of core PostgreSQL.

Postgres-XL is different because it supports both Business Intelligence and OLTP workloads in the same horizontally scalable server. This allows Postgres-XL to support a diverse range of workloads

  • OLTP workloads that need write-scalability as well as read-scalability
  • Business Intelligence requiring OLAP with massive parallelism
  • Operational Data Store/ Central Data Backbone
  • Distributed Key-Value store using JSONB, similar to NoSQL
  • Internet of Things applications
  • Mixed-workload environments

Star schema style SQL queries exhibit large performance gains from massively parallel processing (MPP). Many queries show fully linear performance gains, for example a 16-node XL cluster is 16 times faster than PostgreSQL on one node. Postgres-XL is able to successfully complete the complex TPC-H business intelligence benchmark, showing its capability to address much more than basic operations.

Postgres-XL’s High Availability functionality has also been enhanced in this release. Popular features such as BRIN indexes, JSONB and GIN index compression are fully supported, as are many popular extensions.

Postgres-XL is available for download here: http://www.postgres-xl.org/download/ You can go through XL’s comprehensive documentation here: http://files.postgres-xl.org/documentation/index.html

2ndQuadrant has led the development of Postgres-XL 9.5, building upon the work of many others over a long period of continuous development, with easily more than 10 man years of development. After six months of professional formal alpha-level testing and tuning, the project has now reached the next stage of maturity and we are now ready to have initial users contribute their comments and usage reports to the Postgres-XL community at postgres-xl-bugs@lists.sourceforge.net.

The research leading to these results has received funding from the European Union’s Seventh Framework Programme (FP7/2007-2015) under grant agreement n° 318633. Postgres-XL has also received support and assistance from European Space Agency's Gaia project, as well as other users in industry.

For more details, please visit: http://2ndQuadrant.com/resources/postgres-xl/

Full View / NID: 58146 / Submitted by: The Zilla of Zuron

02.15.2016 - PGConf US 2016 Schedule Posted; Registration Open



View PostgreSQL-Press related news.

The PGConf US 2016 schedule is now available:

http://www.pgconf.us/2016/schedule/

PGConf US 2016 is taking place in New York City from April 18th to April 20th at the New York Marriott Brooklyn Bridge. On April 18th, we are pleased to offer six training sessions as well as the Second Annual Regulated Industry Summit, and our usual program on April 19th and 20th.

Did you know that PostgreSQL turns 20 years old this year? We are celebrating by throwing an elephantine (in other words, a gigantic) birthday party for the community on April 19th. The birthday party will be open to the general public and we will have more details on the PGConf US website in the coming days. Come celebrate PostgreSQL turning 20 at PGConf US!

We are pleased to have Parag Goradia, Executive Director of Cloud Services Engineering at General Electric Digital as our keynote speaker at PGConf US 2016. Parag will be discussing how PostgreSQL is playing a crucial role in GE’s software strategy and is looking forward to sharing his story with the community.

And of course, we would not produce PGConf US 2016 without the awesome talks from our speakers. We had just shy of 140 submissions for 44 session slots and 6 and are delighted to present a group of speakers coming from all over the world and volunteering their time to talk about their experiences with PostgreSQL.

Some, but not all, highlights:

  • PostgreSQL deployments and strategies at enterprises such as MasterCard, Tencent, Capital One, Blackberry, MongoDB, the European Space Agency, InMobi, and more!
  • Want to see what the future of PostgreSQL holds? Come learn how PostgreSQL is developed and how it operates from Major Contributors and PostgreSQL hackers in our internals track.
  • Prefer Ruby and Java to SQL? Not a problem: our developer track has you covered so you can learn to take advantage of PostgreSQL’s robustness.

Want to attend? Our registration is open! Please visit http://www.pgconf.us/2016/tickets/ for registration information. Through February 29th 2016, we are offering a 10% discount on the Regular Admission to the global PostgreSQL community with the code PGDG

PGConf US 2016 is hosted by the United States PostgreSQL Association, a nonprofit 501(c)(3) created to support PostgreSQL in the United States through user group development, conferences, educational initiatives, and fun. There is no way we would be able to produce PGConf US 2016 without the generous support of our Platinum and Gold sponsors:

For more information, please visit http://www.pgconf.us/

We look forward to seeing you in April!

Full View / NID: 58083 / Submitted by: The Zilla of Zuron

02.12.2016 - PgConf.Russia 2016 is finished



View PostgreSQL-Press related news.

Six hundred and eight participants, including sponsors and speakers joined PGCONF.Russia 2016 on Feb.3 - Feb.5.

We invited 21 international and 49 Russian speakers for this conference taking place in Izvestia Hall, Moscow, an untypical venue in the historical city center. Though the main languge of the conference was Russian, simultaneous translation to/from English was provided.

The first day, Feb.3, was a day of 7 tutorials, while other conference activity including conventional and lightning talks, a panel discussion and a conference dinner took place at Deb.4 and Feb.5.

Now we have started publishing slides on the conference website. Video recordings will become available for the conference participants as soon as they are processed, later they will be open for public.

The PgConf.Russia 2016 team members are happy to provide this conference for the Russian and international Postgres community and will do their best to make the next year conference PgConf.Russia 2017 even more interesting. Please follow the announcements at the conference web site https://pgconf.ru/en/ .

Full View / NID: 58078 / Submitted by: The Zilla of Zuron

02.11.2016 - 2016-02-11 Security Update Release



View PostgreSQL-Press related news.

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.

Updating

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.

Links:

Full View / NID: 58045 / Submitted by: The Zilla of Zuron

02.04.2016 - PHP 5.5.32 is available



View PHP related news. 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

02.04.2016 - PHP 5.6.18 is available



View PHP related news. 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

02.04.2016 - PL/Java 1.5.0-BETA1 announced; security note.



View PostgreSQL-Press related news.

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

Security note:

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

01.20.2016 - Call for Papers, PostgreSQL and PostGIS, Session #8, April, 6th



View PostgreSQL-Press related news.

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:

PostgreSQL :

  • What's New in PostgreSQL
  • Use cases
  • Migration to PostgreSQL
  • Performance Tuning
  • Backup and Restore
  • High-Availability
  • Data Warehouse / Big Data

PostGIS :

  • 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 call-for-paper@postgresql-sessions.org

Please give us a little information about yourself and your talk, such as:

  • First Name and Last Name
  • Twitter Account (if any)
  • Company
  • 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.

About Dalibo:

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.

About Oslandia:

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

01.14.2016 - PipelineDB Enterprise Now Available



View PostgreSQL-Press related news.

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

Availability

PipelineDB Enterprise is offered under a commercial license for one and three year terms. To try PipelineDB Enterprise contact enterprise@pipelinedb.com. PipelineDB is free, open-source, and offered under the GPLv3 license. It can be downloaded from the company’s website at www.pipelinedb.com.

About PipelineDB:

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 info@pipelinedb.com for more information.

Media Contact

Jeff Ferguson President and Co-Founder jeff@pipelinedb.com

Full View / NID: 57661 / Submitted by: The Zilla of Zuron

01.12.2016 - Navicat for PostgreSQL version 11.2 - introducing Navicat Cloud Collaboration & support PostgreSQL 9.5



View PostgreSQL-Press related news.

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
    1. Create/Modify/Delete projects.
    2. Add members to project for sharing connection settings, queries and models.
    3. View Project Activity Log.
  • PostgreSQL Objects
    1. Support Foreign Server with User Mapping.
    2. Support Foreign Table.
    3. Support PostgreSQL Debugger.
    4. 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

About Navicat

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.

About PremiumSoft

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

01.09.2016 - dbMigration .NET 2.3 released



View PostgreSQL-Press related news.

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

01.08.2016 - Windows build of PostgreSQL 9.5.0 prepared by Postgres Pro



View PostgreSQL-Press related news.

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

01.07.2016 - 2UDA 9.5 Released



View PostgreSQL-Press related news.

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
  Most Viewed  
  Quick Links  
  Top Affiliates  
........