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

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

12.30.2015 - MicroOLAP Database Designer meets PostgreSQL 9.5



View PostgreSQL-Press related news.

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.

Download

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

  • [!] 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

12.23.2015 - JDBC 1207 released as a Maven project



View PostgreSQL-Press related news.

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

12.18.2015 - 2UDA RC1, released



View PostgreSQL-Press related news.

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

12.18.2015 - PostgreSQL 9.5 RC1 Released



View PostgreSQL-Press related news.

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.

Release Schedule

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.

Links

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

12.16.2015 - PostgreSQL PHP Generator 15.12 released



View PostgreSQL-Press related news.

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
http://www.sqlmaestro.com/products/postgresql/phpgenerator/.

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

Top 15 new features:

  1. New modern look and feel.
  2. 100% responsive design.
  3. PHP 7 support.
  4. Top side drop-down menus.
  5. Enhanced Filter Builder.
  6. Multi-column sorting.
  7. Keyboard shortcuts.
  8. A number of new and updated controls.
  9. 18 color themes.
  10. Font-based icons.
  11. Event management enhancements.
  12. Less preprocessor syntax for user-defined styles.
  13. HTML filter.
  14. New and updated data access drivers.
  15. 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

12.07.2015 - PoWA 3.0.0 released



View PostgreSQL-Press related news.

Paris, December 07 2015

DALIBO is proud to present the third release of PoWA, the PostgreSQL Workload Analyzer.

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.

Credits

DALIBO would like to thank the users and developers who contributed to this release.

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 powa-users@googlegroups.com

Links

For PoWA 3.0.0:

For the stats extensions:

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.

Code & Demo at 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 dalibo.github.io

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

11.30.2015 - Announcing PGConf US 2016: Apr 18 - 20, NYC - Call for Presentations Open



View PostgreSQL-Press related news.

The call for presentations for PGConf US 2016 is now open! Submissions will be allowed through January 31st, 2016. All speakers will be notified by February 15, 2016. Please note that as with our past conferences, there will be no extensions of the submission deadline. For more information and submission details, please visit http://www.pgconf.us/2016/submit/

Thanks to the support of our attendees, speakers, volunteers, and sponsors, we have had two incredibly successful PostgreSQL conferences in NYC that have grown the PostgreSQL community substantially. Hundreds of attendees representing a plethora of companies around the world have attended one or both of our previous conferences and continue to join our event. In April of 2016 we plan to keep the tradition going. With the support of the United States PostgreSQL Association, the conference organization team is planning the most informational and involved conference yet.

April 18th is dedicated to hosting trainings and summits. Trainings will occur at the conference venue and the schedule will be announced in February. We are featuring the “Second Annual Regulated Industry Summit: Finance, Government, Healthcare, and PostgreSQL" hosted at the NYC Marriott Brooklyn Bridge, which will bring together PostgreSQL contributors and enterprise developers to discuss challenges and solutions in utilizing PostgreSQL in regulated environments. For more information about the summit and how to attend, please visit http://www.pgconf.us/2016/training/

April 19th - 20th, 2016, will host two days of dedicated sessions, keynotes, and events that will allow individuals to enter and experience the PostgreSQL community at its finest. Experts from around the globe will be submitting talks and trainings in order to grow the PostgreSQL community and empower those involved. This wealth of knowledge comes from the perspectives of developers, DBAs, systems administrators, business-intelligence analysts, decision makers, and the like.

PGConf US 2016 would not be possible without the considerate support of our sponsors, which allows us to continue to produce a high-quality event while keeping registration fees low to encourage growing our community. We extend a very warm thank you to our launch sponsors:

Platinum:

Gold:

Silver:

Are you interested in joining these generous businesses in sponsoring the PostgreSQL event of 2016? We invite you to view our sponsorship prospectus slideshow at http://www.pgconf.us/static/prospectus/PGConf-US-2016-Prospectus.pdf

We look forward to seeing everyone in April to make this the best PostgreSQL conference in the United States to date!

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

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

11.26.2015 - PHP 5.6.16 is available



View PHP related news. The PHP development team announces the immediate availability of PHP 5.6.16. Several bugs have been fixed. All PHP 5.6 users are encouraged to upgrade to this version. For source downloads of PHP 5.6.16 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: 57065 / Submitted by: The Zilla of Zuron

11.16.2015 - Database .NET v17 released



View PostgreSQL-Press related news.

I am happy to announce the new major release of Database .NET v17. 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 16.1 to 17.0:

  • Compatible with PostgreSQL 9.5 beta 2 or higher
  • Updated to Npgsql.dll 2.2.7
  • Auto Completion supports for JSON functions (9.2~9.5)
  • Generate Table Data (INSERTs) as a single file
  • Clear Quick Filter on the object explorer
  • Edit Rows with Filter Expression
  • Minimize Main Window on the progress window
  • Detect when file is changed outside the environment
  • Displaying Data Types on the Form Viewer and Editor
  • Filter and Reordering columns in the results pane
  • Auto Completion for the Advanced options
  • Built-in Database Migration and Data Synchronization (Pro)
  • ...and more

The new version is immediately available for download.

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

11.16.2015 - Barman 1.5.1 released



View PostgreSQL-Press related news.

16 November 2015: 2ndQuadrant is proud to announce the release of version 1.5.1 of Barman, Backup and Recovery Manager for PostgreSQL.

This minor release introduces support for 'per-server' concurrency of maintenance operations through the 'cron' command. Internally, Barman is now able to spawn a new sub-process for WAL archive operations on a specific server. For this purpose, the 'archive-wal' command has been added to the command interface.

Minor bugs have also been fixed.

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

Links

Release notes

  • Add support for the 'archive-wal' command which performs WAL maintenance operations on a given server
  • Add support for "per-server" concurrency of the 'cron' command
  • Improved management of xlog.db errors
  • Add support for mixed compression types in WAL files (SF.net#61)
  • Bug fixes:
    • Avoid retention policy checks during the recovery
    • Avoid 'wal_level' check on PostgreSQL version < 9.0 (#3)
    • Fix backup size calculation (#5)

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: 56886 / Submitted by: The Zilla of Zuron

11.12.2015 - PostgreSQL 9.5 Beta 2 Released



View PostgreSQL-Press related news.

The PostgreSQL Global Development Group announces today that the second beta release of PostgreSQL 9.5 is available for download. This release should contain all features and APIs which will be in the final release with few, if any, changes. Users should begin testing their applications against 9.5 Beta 2 in preparation for the final release.

Changes Since Beta1

Many bugs and issues reported by our users and contributors have been fixed since the release of Beta1. These include:

  • Many documentation fixes and improvements
  • Rename PQsslAttributes() to PQsslAttributeNames()
  • Pass extra data to pgworkers for context
  • Fix other issues with parallel workers
  • Fix multiple issues with BRIN indexes
  • Fix problems with commit timestamps and replication
  • Put back ssl_renegotiation_limit, set to 0

If you reported an issue while testing PostgreSQL 9.5, please download Beta2 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. Known issues which are still open are listed on the Open Items page.

Beta Schedule

This is second beta release of version 9.5, indicating that very few user-visible feature changes are expected before final release. The PostgreSQL Project will release additional betas as required for testing, followed by one or more release candidates, until the final release in late 2015. For more information, and suggestions on how to test the betas, 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.

Links

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

11.11.2015 - Devart Released New SSIS Components for PostgreSQL



View PostgreSQL-Press related news.

Devart released a first version of SSIS Components for PostgreSQL v1.0

It deliver performance-optimized SSIS Data Flow Source, Lookup, and Destination components for PostgreSQL.

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

11.02.2015 - BDR version 0.9.3 released



View PostgreSQL-Press related news.

Version 0.9.3 is a maintenance release focused on stability. Significant improvements to BDR and UDR in this release include:

  • Fix bdr_internal_sequence_reset_cache on UDR (#132)
  • Ignore bdr.bdr_connections rows where node is dropped (#97, #50, #126)
  • Compatibility improvements for upgrading from 0.7.3

There are no compatibility-affecting changes in this release.

Visit http://2ndquadrant.com/en/resources/bdr/ for more details.

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

10.30.2015 - PHP 5.6.15 is available



View PHP related news. The PHP development team announces the immediate availability of PHP 5.6.15. Several bugs have been fixed. All PHP 5.6 users are encouraged to upgrade to this version. For source downloads of PHP 5.6.15 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: 56637 / Submitted by: The Zilla of Zuron

10.17.2015 - pgFormatter 1.5 released



View PostgreSQL-Press related news.

October 17 2015 - v1.5

Version 1.5 of pgFormatter, a free a SQL formatter/beautifier dedicated to standard SQL and PostgreSQL specifics keywords, has been officially released and is publicly available for download.

This release fixes several issues and adds support to new keywords added in PostgreSQL 9.5. There's also a major code rewrite by Hubert depesz Lubaczewski, pg_format works as previously - handles both CGI and CLI interface, but you can get directly to whatever functionality you want by using pgFormatter::* modules.

New beautified keywords are: BERNOULLI, CUBE, GROUPING SETS, SKIP LOCKED, LOGGED, POLICY, ROLLUP, TABLESAMPLE. And new functions are: jsonb_pretty, jsonb_set, pg_last_committed_xact, pg_xact_commit_timestamp.

There is also a useful hint added to documentation to be able to format you SQL code from vi by adding a simple line to .vimrc. This hint is taken from David Fetter's blog.

For the complete list of changes see the changelog.

Links & Credits

Thank to the developers who submitted patches and users who reported bugs and feature requests, especially Hubert depesz Lubaczewski, Kevin Brannen, David Fetter, Tom Burnett, Adrian Klaver, Alvaro Herrera, Niklas Schmidtmer and Pablo Alvarez de Sotomayor Posadillo.

pgFormatter is an open project. Any contribution to build a better tool is welcome. You just have to send your ideas, features requests or patches using the GitHub tools.

Links:

About pgFormatter

pgFormatter is a SQL formatter/beautifier that supports keywords from SQL-92, SQL-99, SQL-2003, SQL-2008, SQL-2011 and PostgreSQL specifics keywords. May works with any other databases too. It shares the same code with pgBadger, so any improvement made in the parser is reversed to pgBadger. Tool created and maintained by Gilles Darold.

pgFormatter can work as a console program or as a CGI. It will automatically detect his environment and output as text or as HTML following the context.

pgFormatter works on any platform and is available under the PostgreSQL licence.

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

10.16.2015 - Ora2Pg 16 released



View PostgreSQL-Press related news.

Paris, France - October 16th, 2015

Ora2Pg 16 released

Version 16.0 of Ora2Pg, a free and reliable tool used to migrate an Oracle database to PostgreSQL, has been officially released and is publicly available for download.

This major release improve PL/SQL code replacement, fixes several bugs and adds some major new features:

  • Full migration of MySQL database, it just work like with Oracle database.
  • Full migration assessment report for MySQL database.
  • New script, ora2pg_scanner, to perform a migration assessment of all Oracle and MySQL instances on a network.
  • Add technical difficulty level in migration assessment.
  • Allow migration assessment on client queries extracted from AUDIT_TRAIL (oracle) or general_log table (mysql).
  • Ora2Pg has a "made in one night" brand new Web site (still need some work) http://ora2pg.darold.net/

Example of technical difficulty level assessment output using the sakila database with some more difficulties:

Total 83.90 cost migration units means approximatively 1 man-day(s). Migration level: B-5

Here are the explanation of the migration level code:

Migration levels: A - Migration that might be run automatically B - Migration with code rewrite and a human-days cost up to 5 days C - Migration with code rewrite and a human-days cost above 5 days Technical levels: 1 = trivial: no stored functions and no triggers 2 = easy: no stored functions but with triggers, no manual rewriting 3 = simple: stored functions and/or triggers, no manual rewriting 4 = manual: no stored functions but with triggers or views with code rewriting 5 = difficult: stored functions and/or triggers with code rewriting

This is to help you to find the database that can be migrated first with small efforts (A and B) and those who need to conduct a full migration project (C).

This release has also some new useful features:

  • Export type SHOW_TABLE now shows additional information about table type (FOREIGN, EXTERNAL or PARTITIONED with the number of partition).
  • Connection's user and password can be passed through environment variables ORA2PG_USER and ORA2PG_PASSWD to avoid setting them at ora2pg command line.
  • Improve PL/SQL replacement on ADD_MONTH(), ADD_YEAR(), TRUNC(), INSTR() and remove the replacement limitation on DECODE().
  • Add detection of migration difficulties in views, was previously reserved to functions, procedures, packages and triggers.
  • Replace values in auto generated configuration file from command line options -s, -n, -u and -p when --init_project is used.
  • Adjust lot of scores following new functionalities in Ora2Pg, ex: autonomous transactions, dblink or synomyms are now more easy to migrate.

There is some new command line options to ora2pg script:

  • -m | --mysql : to be used with --init_project and -i option to inform ora2pg that we work with a MySQL format
  • -T | --temp_dir : option to be able to set a distinct temporary directory to run ora2pg in parallel.
  • --audit_user : option to set the user used in audit filter and enable migration assessment report on queries from AUDIT_TRAIL (oracle) or general_log table (mysql).
  • --dump_as_sheet and --print_header options to be able to compute a CSV file with all migration assessment from a list of oracle database.
  • --dump_as_csv option to report assessments into a csv file. It will not include comments or details, just objects names, numbers and cost.

Some change can break backward compatibility:

  • Change NULL_EQUAL_EMPTY to be disabled by default to force change in the application instead of transforming the PL/SQL.

This release adds some new configuration directives:

  • MYSQL_PIPES_AS_CONCAT: Enable it if double pipe and double ampersand (|| and &&) should not be taken as equivalent to OR and AND.
  • MYSQL_INTERNAL_EXTRACT_FORMAT: Enable it if you want EXTRACT() replacement to use the internal format returned as an integer.
  • AUDIT_USER: Set the comma separated list of user name that must be used to filter from the DBA_AUDIT_TRAIL or general_log tables.
  • REPLACE_ZERO_DATE: the "zero" date: 0000-00-00 00:00:00 is replaced by a NULL by default, use it to use the date of your choice. Useful when you have a NOT NULL constraint.
  • INDEXES_RENAMING: force renaming of all indexes using a name with tablename_columnsnames. Useful for database that have multiple time the same index name or that use the same name than a table.
  • HUMAN_DAYS_LIMIT: default to 5 days, used to set the number of human-days limit for migration of type C.

As usual there is also some bug fixes and Oracle to PostgreSQl conversion adjustments, for a complete list see the changelog.

Links & Credits

Thanks to all contributors, they are all cited in the changelog file.

Useful Links:


About Ora2Pg

Ora2Pg is an easy and reliable tool to migrate from Oracle to PostgreSQL. It is developed since 2001 and can export most of the Oracle objects (table, view, materialized view, tablespace, sequence, indexes, trigger, grant, function, procedure, package, partition, data, blob, external table, etc.).

Ora2Pg works on any platform and is available under the GPL v3 licence.

Docs, Download & Support at ora2pg.darold.net.


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

10.13.2015 - 2UDA Beta (1) Released



View PostgreSQL-Press related news.

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 latest release brings a number of enhancements based on the valuable feedback we have had from users who have downloaded a copy of the previous Alpha releases.

2UDA is a great example of the benefits derived from the 'tablesample' feature of PostgreSQL 9.5, demonstrating how large data samples can be quickly analysed through visualization.

Try the Beta version of 2UDA for yourself at http://2ndquadrant.com/2uda

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

10.13.2015 - Database Designer for PostgreSQL 1.10.6 available



View PostgreSQL-Press related news.

The MicroOLAP team is proud to introduce Database Designer for PostgreSQL with enhanced support for Windows 10 and optional anonymous statistics functionality, 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.

New release introduces enhanced support for Windows 10 and optional anonymous statistics functionality.

Download

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

  • [!] Anonymous statistics module added (optional)
  • [!] Enhanced Windows 10 support by new compiler introduced
  • [*] Performance optimizations in error logging
  • [-] "EAccessViolation (Bug B21C0000) after reference deletion" bug fixed
  • [-] "Range check error in processes information for x64 machines" bug fixed
Full View / NID: 56386 / Submitted by: The Zilla of Zuron

10.12.2015 - New version of Oracle-to-PostgreSQL converter has been released



View PostgreSQL-Press related news.

Intelligent Converters has released a new version of Oracle-to-PostgreSQL converter with the following improvements:

  • Oracle 12c support
  • option to write into log file
  • improved synchronization

Visit the product page to learn more about the new version of Oracle-to-PostgreSQL: http://www.convert-in.com/ora2pgs.htm

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

10.09.2015 - PostgreSQL RESTful API



View PostgreSQL-Press related news.

PSQL-API

Offers RESTful API access and API administration tools for the Postgres database server. Integrates all needed for fastest start. A WEB interface is used for administration. The API interface is created for HTTP applications (WEB, mobile, IoT and others) and allows CRUD operations and specified queries using secured communications (HTTPS, CORS, JWT/custom authorization rules).

Developed by Q-Bis Consult and partners, the project is open source MIT licensed.

https://github.com/QBisConsult/psql-api https://www.npmjs.com/package/psql-api

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