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

Your Technical Computer Information Resource!  
     
  Server Applications Technical Updates [Page: 1 of 97] @ TACKtech Corp.  

07.04.2014 - MicroOLAP Database Designer for PostgreSQL v1.10.0 is out



View PostgreSQL-Press related news.

The MicroOLAP team is proud to introduce Database Designer for PostgreSQL v1.10.0, 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 as well as improved support for inheritance functionality. Modify Engine allows mark constraints as NOT VALID. Several non critical bugs fixed.

Download

You're welcome to download the Database Designer for PostgreSQL 1.10.0 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:

  • [!] SQL Executor and Validator support v9.4 grammar now
  • [!] Support for table inheritance improved dramatically
  • [+] "Always make PK columns first" option introduced in Diagram Options
  • [+] Allow CHECK constraints to be declared NOT VALID in Modify script
  • [+] Allow FOREIGN KEY constraints to be declared NOT VALID in Modify script
  • [+] Shortcut for "Save As.." and "Export" menu items added
  • [+] SQL keywords are properly highlighted according to 9.4 version
  • [*] Comments now shown at Preview tab of Table Editor by default
  • [*] Handling of incorrect file paths improved in Generate and Modify Database
  • [*] Merging of reversed user types with existing in model improved during Reverse Engineering
  • [-] "Changing domain schema doesn't affect table representation where domain used" bug fixed
  • [-] "Changing some options in the Model Options doesn't activate OK & Apply buttons" bug fixed
  • [-] "Column default values containing backslashes are corrupted after reloading model" bug fixed
  • [-] "Leak proof option doesn't shown in the Function editor after reopen" bug fixed
  • [-] "LEAKPROOF attribute causes syntax error in the SQL Executor" bug fixed
Full View / NID: 49569 / Submitted by: The Zilla of Zuron

07.03.2014 - PHP 5.6.0RC2 is available



View PHP related news. The PHP development team announces the immediate availability of the second release candidate of PHP 5.6. As we entered the feature freeze with beta1, this is a bugfix-only release. All users of PHP are encouraged to test this version carefully, and report any bugs in the bug tracking system. THIS IS A DEVELOPMENT PREVIEW - DO NOT USE IT IN PRODUCTION! For more information about the new features you can check out the work-in-progress documentation or you can read the full list of changes in the NEWS file contained in the release archive. For source downloads of PHP 5.6.0RC2 please visit the download page. Windows binaries can be found on windows.php.net/qa/. Our third Release Candidate should show up on the 17th of July. Thank you for helping us make PHP better.
Full View / NID: 49565 / Submitted by: The Zilla of Zuron

07.01.2014 - PGConf.EU 2014 Now Open for Registration



View PostgreSQL-Press related news.

PostgreSQL Conference Europe 2014 in Madrid, Spain, on October 21st - 24th, is now open for registration!

PGConf.EU is the largest PostgreSQL dedicated conference in the world, with three packed days of sessions ranging from beginner level to advanced sessions about database internals, and more than 250 attendees.

The 2014 edition is now open for registration to all attendees. Register before September 15 and receive 20% Early Bird discount! We recommend attendees to register as early as possible, since the conference often sells out!

There will be a full day of training sessions on October 21st, the day before the main conference, held by well known teachers from the PostgreSQL community. These sessions are ordered at registration, and are also available for order now. The training sessions are held in smaller groups, and may sell out quickly, so we suggest that anybody who wish to attend the training register early!

To register, access the registration form on the website.

We'd also like to remind you that our call for papers is still open, where we are looking for even more interesting presentations for the conference. Speakers of the conference receive free attendance, so make sure to submit your ideas!

We look forward to seeing you in Madrid!

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

06.27.2014 - PHP 5.5.14 is released



View PHP related news. The PHP Development Team announces the immediate availability of PHP 5.5.14. This release fixes several bugs against PHP 5.5.13. Also, this release fixes a total of 8 CVEs, half of them concerning the FileInfo extension.All PHP users are encouraged to upgrade to this new version.Please, note that this release also fixes a backward compatibility issue that has been detected in the PHP 5.5.13 release. Still, the fix in PHP 5.5.14 may break some very rare situations. As this tiny compatibility break involves security, and as security is our primary concern, we had to fix it. This concerns bug 67072. For more information about this bug and its actual resolution, please visit our upgrading guide. We apologize for any inconvenience you may have experienced with this behavior.For source downloads of PHP 5.5.14, 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: 49529 / Submitted by: The Zilla of Zuron

06.26.2014 - PgBackMan 1.0.0 released



View PostgreSQL-Press related news.

Oslo, Norway - June 26,2014

We are proud to announce the first release available to the public of PgBackMan - PostgreSQL backup manager.

About PgBackMan

PgBackMan is a tool for managing PostgreSQL logical backups created with pg_dump and pg_dumpall.

It is designed to manage backups from thousands of databases running in multiple PostgreSQL nodes, and it supports a multiple backup server topology.

The PgBackMan code is distributed under the GNU General Public License 3 and it is written in Python and PL/PgSQL. It has been developed and tested by members of the Database Operations Group at the Center for Information Technology at the University of Oslo.

Main Features

  • Central database with metadata information.
  • PgBackMan shell for interaction with the system.
  • Management of multiple backup servers.
  • Management of multiple PostgreSQL servers.
  • Management of thousands of backups dumps through a catalogue.
  • Manual and scheduled backups.
  • Management of retention policies for backups.
  • Fully detailed backup reports.
  • Multiple predefined database backup types, CLUSTER,FULL,SCHEMA,DATA.
  • Full backup of role information for a database.
  • Full backup of database configuration for a database.
  • Automatic definitions of backups for all databases running in a PgSQL node.
  • Automatic restore procedures.
  • Autonomous pgbackman_dump program that functions even if the central database with metadata information is not available.
  • Handling of error situations.
Full View / NID: 49518 / Submitted by: The Zilla of Zuron

06.26.2014 - PHP 5.4.30 Released



View PHP related news. The PHP development team announces the immediate availability of PHP 5.4.30. Over 20 bugs were fixed in this release, including the following security issues: CVE-2014-3981, CVE-2014-0207, CVE-2014-3478, CVE-2014-3479, CVE-2014-3480, CVE-2014-3487, CVE-2014-4049, CVE-2014-3515. All PHP 5.4 users are encouraged to upgrade to this version. Please, note that this release also fixes a backward compatibility issue that has been detected in the PHP 5.4.29 release. Still, the fix in PHP 5.4.30 may break some very rare situations. As this tiny compatibility break involves security, and as security is our primary concern, we had to fix it. This concerns bug 67072. For more information about this bug and its actual resolution, please refer to our upgrading guide, section 4a. We apologize for any inconvenience you may have experienced with this behavior.For source downloads of PHP 5.4.30 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: 49517 / Submitted by: The Zilla of Zuron

06.23.2014 - Bucardo 5 released



View PostgreSQL-Press related news.

Version 5 of Bucardo, a multi-source, multi-target replication system for PostgreSQL has been released. You can find more information about the release here:

http://blog.endpoint.com/2014/06/bucardo-5-multimaster-postgres-released.html

For more information on how to download Bucardo, please visit:

http://bucardo.org/wiki/Bucardo

Checksums for the tarball:

d87d109c1cba300d074603b2dd4d1019302acdfd Bucardo-5.0.0.tar.gz f4e68f473a4669d465d0d8f23910d4b3 Bucardo-5.0.0.tar.gz

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

06.19.2014 - PHP 5.6.0RC1 is available



View PHP related news. The PHP development team announces the immediate availability of the first release candidate of PHP 5.6. As we entered the feature freeze with beta1, this is a bugfix-only release. All users of PHP are encouraged to test this version carefully, and report any bugs in the bug tracking system. THIS IS A DEVELOPMENT PREVIEW - DO NOT USE IT IN PRODUCTION! For more information about the new features you can check out the work-in-progress documentation or you can read the full list of changes in the NEWS file contained in the release archive. For source downloads of PHP 5.6.0RC1 please visit the download page. Windows binaries can be found on windows.php.net/qa/. Our second Release Candidate should show up on the 3rd of July. Thank you for helping us make PHP better.
Full View / NID: 49456 / Submitted by: The Zilla of Zuron

06.05.2014 - PHP 5.6.0beta4 Released



View PHP related news. The PHP development team announces the immediate availability of PHP 5.6.0beta4. As we entered the feature freeze with beta1, this is a bugfix-only release. All users of PHP are encouraged to test this version carefully, and report any bugs in the bug tracking system. The beta phase is officially closed with this release. A couple of RCs are to be expected, until we are confident that the release is stable enough for the final release. For that, we really need your help in testing and reporting any problems that you encounter. THIS IS A DEVELOPMENT PREVIEW - DO NOT USE IT IN PRODUCTION! For more information about the new features you can check out the work-in-progress documentation or you can read the full list of changes in the NEWS file contained in the release archive. For source downloads of PHP 5.6.0beta4 please visit the download page. Windows binaries can be found on windows.php.net/qa/. Our first Release Candidate should show up on the 19th of June. Thank you for helping us make PHP better.
Full View / NID: 48317 / Submitted by: The Zilla of Zuron

06.05.2014 - Postgres Open 2014 Early Bird Tickets and Tutorials on Sale!



View PostgreSQL-Press related news.

The 2014 Postgres Open Program Committee is pleased to announce the opening of Early Bird Tickets and Tutorial Registration sales.

Early Bird Tickets: Book early through July 6, 2014 to save $200 on your registration! Postgres Open has received such strong support from our community sponsors that we’re retaining our ticket prices from 2013 - no increase this year.

Conference Tutorials: We’ve brought in some new presenters and topics this year for our tutorial sessions held Wednesday, September 17th.

  • Adv. SQL + Functions - Joe Conway, Stephen Frost
  • Intro to PostGIS Core and Popular Add-ons - Regina Obe, Leo Hsu (a 2 part/full day session)
  • Writing and Using Extensions - Dimitri Fontaine

In addition, Heroku is offering a free platform tutorial covering dynos and their environment, buildpacks, deployment, releases, HTTP routing, add-ons, and of course Postgres.

Early Bird Tickets and All Tutorials can be purchased here: https://postgresopen.org/2014/tickets/

The CfP has been extended through Sunday June 8th: We’ve received some impressive submissions thus far, however a few of you have asked for some extra time, as such we’re giving you until this Sunday June 8. https://postgresopen.org/2014/callforpapers/

We look forward updating you in the coming weeks and with more speaker info and the presentations schedule for Postgres Open 2014!

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

06.05.2014 - Admin4 V2.1.4 featuring PostgreSQL module released



View PostgreSQL-Press related news.

The new Admin4 release is the first to contain a greatly enhanced PostgreSQL module. It includes:

  • Object browser with Favourites
  • Query tool with Snippets, sql text fragments stored for frequent usage
  • Data tool for table data modification, with Presets to remember frequently used data retrieval filters.

Favourites, Snippets and Presets are stored centrally in the database, making them available for roaming usage. Your day-to-day code snippets, standard filters and frequently used objects are right there no matter which workstation you're using to maintain the database.

Download it here from sourceforge, it's free (Apache2 licensed). Contributors/testers for this fresh project are welcome!

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

05.29.2014 - PHP 5.5.13 Released



View PHP related news. The PHP Development Team announces the immediate availability of PHP 5.5.13. This release fixes several bugs in PHP 5.5.12, and addresses two CVEs in Fileinfo (CVE-2014-0238 and CVE-2014-0237).All PHP users are encouraged to upgrade to this new version.For source downloads of PHP 5.5.13, 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: 48264 / Submitted by: The Zilla of Zuron

05.29.2014 - PHP 5.5.13 is available



View PHP related news. The PHP Development Team announces the immediate availability of PHP 5.5.13. This release fixes several bugs in PHP 5.5.12, and addresses two CVEs in Fileinfo (CVE-2014-0238 and CVE-2014-0237).All PHP users are encouraged to upgrade to this new version.For source downloads of PHP 5.5.13, 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: 48245 / Submitted by: The Zilla of Zuron

05.29.2014 - PHP 5.4.29 Released



View PHP related news. The PHP development team announces the immediate availability of PHP 5.4.29. 16 bugs were fixed in this release, including two security issues in fileinfo extension. All PHP 5.4 users are encouraged to upgrade to this version. For source downloads of PHP 5.4.29 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: 48244 / Submitted by: The Zilla of Zuron

05.27.2014 - PHP Next Generation



View PHP related news. When we aren't looking for pictures of kittens on the internet, internals developers are nearly always looking for ways to improve PHP, a few developers have a focus on performance.Over the last year, some research into the possibility of introducing JIT compilation capabilities to PHP has been conducted.During this research, the realization was made that in order to achieve optimal performance from PHP, some internal API's should be changed.This necessitated the birth of the phpng branch, initially authored by Dmitry Stogov, Xinchen Hui, and Nikita Popov. This branch does not include JIT capabilities, but rather seeks to solve those problems that prohibit the current, and any future implementation of a JIT capable executor achieving optimal performance by improving memory usage and cleaning up some core API's.By making these improvements, the phpng branch gives us a considerable performance gain in real world applications, for example a 20% increase in throughput for Wordpress. The door may well now be open for a JIT capable compiler that can perform as we expect, but it's necessary to say that these changes stand strong on their own, without requiring a JIT capable compiler in the future to validate them.The name "Next Generation" was optimistically presumptuous; in reality phpng is an internal project that we are working on, it is not a production ready branch that anyone should deploy, or judge as they would a release of PHP.The work on phpng, the doors it opens, the conversations it has started, the collaboration it is inspiring, are all worth getting excited about. But, we need to stay grounded, honest, and open; and say that there is much work to do in order to make the "Next Generation" a reality, this is only the start.
Full View / NID: 48222 / Submitted by: The Zilla of Zuron

05.26.2014 - PostgreSQL Maestro 14.5 released



View PostgreSQL-Press related news.

SQL Maestro Group announces the release of PostgreSQL Maestro 14.5, a powerful Windows GUI solution for PostgreSQL database server administration and database development.

The new version is immediately available for download.

Top 10 new features:

  1. PostgreSQL 9.4 compatibility.
  2. Support for materialized views.
  3. Support for range types.
  4. Enhanced Function Editor.
  5. Updatable views generation.
  6. SQL Editor: support for DML statements with the RETURNING clause.
  7. Data import from several files to a single table.
  8. Advanced Column Builder for text files with fixed column width.
  9. Data export to the JSON format.
  10. Some performance and usability improvements.

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

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

05.25.2014 - DBD::Pg 3.2.1 released



View PostgreSQL-Press related news.

Version 3.2.1 of DBD::Pg, the Perl interface to Postgres, has just been released. For more information and to download please visit:

http://search.cpan.org/dist/DBD-Pg/

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

05.16.2014 - PostgreSQL 9.4 beta1 on Debian/Ubuntu



View PostgreSQL-Press related news.

Yesterday saw the first beta release of the new PostgreSQL version 9.4. Along with the sources, we uploaded binary packages to Debian experimental and apt.postgresql.org, so there's now packages ready to be tested on Debian wheezy, squeeze, testing/unstable, and Ubuntu trusty, saucy, precise, and lucid.

If you are using one of the release distributions of Debian or Ubuntu, add this to your /etc/apt/sources.list.d/pgdg.list to have 9.4 available:

deb http://apt.postgresql.org/pub/repos/apt/ codename-pgdg main 9.4

On Debian jessie and sid, install the packages from experimental.

Happy testing!

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

05.15.2014 - PHP 5.6.0beta3 Released



View PHP related news. The PHP development team announces the immediate availability of PHP 5.6.0beta3. As we entered the feature freeze with beta1, this is is a bugfix-only release. All users of PHP are encouraged to test this version carefully, and report any bugs in the bug tracking system. THIS IS A DEVELOPMENT PREVIEW - DO NOT USE IT IN PRODUCTION!For more information about the new features you can check out the work-in-progress documentation or you can read the full list of changes in the NEWS file contained in the release archive. For source downloads of PHP 5.6.0beta3 please visit the download page. Windows binaries can be found on windows.php.net/qa/. Our fourth and final beta should show up on the 29th of May. Thank you for helping us make PHP better.
Full View / NID: 48131 / Submitted by: The Zilla of Zuron

05.15.2014 - PostgreSQL 9.4 Beta 1 Released



View PostgreSQL-Press related news.

The PostgreSQL Global Development Group announced that the first beta release of PostgreSQL 9.4, the latest version of the world's leading open source database, is available today. This beta contains previews of all of the features which will be available in version 9.4, and is ready for testing by the worldwide PostgreSQL community. Please download, test, and report what you find.

Major Features

The new major features available for testing in this beta include:

  • JSONB: 9.4 includes the new JSONB "binary JSON" type. This new storage format for document data is higher-performance, and comes with indexing, functions and operators for manipulating JSON data.
  • Replication: The new Data Change Streaming API allows decoding and transformation of the replication stream. This lays the foundation for new replication tools that support high-speed and more flexible replication and scale-out solutions.
  • Materialized Views with "Refresh Concurrently", which permit fast-response background summary reports for complex data.
  • ALTER SYSTEM SET, which enables modifications to postgresql.conf from the SQL command line and from remote clients, easing administration tasks.

These features expand the capabilities of PostgreSQL, and introduce new syntax, APIs, and management interfaces.

Additional Features

There are many other features in the 9.4 beta, all of which need testing by you:

  • Dynamic Background Workers
  • Replication Slots
  • Write Scalability improvements
  • Aggregate performance improvements
  • Reductions in WAL volume
  • GIN indexes up to 50% smaller and faster
  • Updatable security barrier views
  • New array manipulation and table functions
  • Time-delayed standbys
  • MVCC system catalog updates
  • Decrease lock level for some ALTER TABLE commands
  • Backup throttling
  • WITHIN GROUP

There have also been many internal changes in the inner workings of the Write Ahead Log (WAL), GIN indexes, replication, aggregation, and management of the system catalogs. The means we need you to help us find any new bugs that we may have introduced in these areas before the full release of 9.4.

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

Test 9.4 Beta 1 Now

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 Beta 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 Beta 1 will not change substantially before final release, so it is now safe to start building applications against the new features. More information on how to test and report issues

Get the PostgreSQL 9.4 Beta 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.

Full View / NID: 48128 / Submitted by: The Zilla of Zuron
  Most Viewed  
  Quick Links  
  Top Affiliates  
.......