Database consolidation, hardware upgrades, mergers and acquisitions, and the decision to virtualize server hardware all drive the decision to migrate data into new systems to stay competitive. Bull HN Information Systems (Bull) announces the formation of a Database Migration Business Unit ( www.postgresmigrations.com ) offering comprehensive solutions to migrate legacy and other relational databases to open source PostgreSQL, including consulting, implementation and optimization services for both infrastructure and applications. The business unit's formation leverages Bull's more than 40 years of experience with major, enterprise-level database migrations worldwide.

According to National Sales Director Jim Ulrey, "Bull has a long history in database technologies and their applications. We primarily work with PostgreSQL in order to deliver major savings in licensing and support fees to our customers, and have had great success with both proprietary relational database migrations and legacy non-relational database migrations. This includes large customers with both high-performance and availability demands.

"We understand that data is the lifeblood of today's business. Therefore, when it comes to mission critical projects like data migration, companies require an experienced partner like Bull--one that can offer proven solutions, solid methodology and a seamless transition. Our new business unit is dedicated to excellence and committed to helping our clients meet their business objectives," concluded Ulrey.

About Bull, Architect of an Open World

Bull is an Information Technology company, dedicated to helping corporations and public sector organizations optimize the architecture, operations and the financial return of their Information Systems and their mission-critical related businesses. For more information, please visit www.postgresmigrations.com .

SOURCE: Bull HN Information Systems

    Integrated Communications Management 
    Patrick Riley, 603-893-6510 
    pjriley@icmarcom.com

DA-SOFT Technologies announces the immediate availability of "AnyDAC for Delphi" Spring 2012, v 5.0.7.2333.

Version Highlights

• Delphi XE2 and Mac OS X support;
• FPC 2.6.0 / Lazarus 0.9.30.4 and Windows x86/x64, Linux 86/x64 and Mac OS X support;
• UpdateOptions.UpdateJoinedFields and TADMapRule.NameMask added;
• auto-inc fields improvements;
• SQLite v 3.7.11 support;
• SQLite native Array DML support;
• SQL Server 2012 support;
• Advantage DB TADADSUtility service component;
• Advantage DB support for aliases;
• major documentation update;
• many driver and addon improvements. And more.

Please, check the detailed change log at http://www.da-soft.com/anydac/anydac-for-delphi-v-5.0.7.2333-released.html

AnyDAC for Delphi

AnyDAC is an unique set of Universal Data Access Components for developing applications on Delphi, C++Builder and Free Pascal. With its powerful common architecture AnyDAC enables native high-speed direct access to PostgreSQL, Firebird, SQLite, MySQL, MS SQL Server, Oracle, IBM DB2, SQL Anywhere, MS Access, Informix, Advantage Database and more. For complete list of features and availability, please check:

• AnyDAC home - http://www.da-soft.com/anydac/
• AnyDAC shop - http://www.da-soft.com/anydac/order.html
• AnyDAC trial - http://www.da-soft.com/anydac/download.html

AnyDAC Core Features

• Native access to PostgreSQL, Firebird, MySQL, SQL Server, Oracle, SQLite, DB2, InterBase, SQL Anywhere, Informix, Advantage Database and more. Including latest DBMS versions.
• Generic access to any database supported through dbExpress or ODBC data sources.
• Optimized for best possible performance. 2 times faster than dbGo, 25% faster than dbExpress.
• Reach API with 50 Delphi VCL components, including TADConnection, TADTransaction, TADQuery, TADStoredProc, TADTable, TADMemTable.
• Unified API for cross-database access, including unified data type mapping, SQL dialect abstraction, connection aliases.
• First-class support for many database-specific features, including backup, restore, validation, SQL scripting.
• Advanced Data Access Options, including Array DML, Live Data Window mode, full Unicode support.
• Delphi 5 to Delphi XE2, C++ Builder 5 to C++ Builder XE2, Lazarus / Free Pascal on Win32, Win64, Linux32, Linux64, Mac OS X.
• Perfect integration as back-end driver for TMS AdvGrid, RemObjects Data Abstract, Fast Report, C4D kbmMW and more.

AnyDAC Natively Supported Databases

• Workgroup - PostgreSQL, Firebird, MySQL, SQL Anywhere, Interbase, Advantage DB.
• Enterprise - Oracle, SQL Server, IBM DB2, Informix.
• Database in clouds - SQL Azure.
• Desktop - SQLite, Access, Advantage DB, BlackFish SQL, SQL CE.
• Embedded - SQLite, Firebird Embedded, MySQL Embedded, Berkeley DB.
• Bridges - dbExpress, ODBC.

-- With best regards, DA-SOFT Technologies Team

PostGIS is an extension that adds support for geographic objects to the PostgreSQL object-relational database. The version 2.0.0 is now complete and available for download here :

Download PostGIS

The development process for 2.0 has been very long, but has resulted in a release with a number of exciting new features.

• Raster data and raster/vector analysis in the database
• Topological models to handle objects with shared boundaries
• PostgreSQL typmod integration, for an automagical geometry_columns table
• 3D and 4D indexing
• Index-based high performance nearest-neighbour searching
• Many more vector functions including
• ST_Split
• ST_Node
• ST_MakeValid
• ST_OffsetCurve
• ST_ConcaveHull
• ST_AsX3D
• ST_GeomFromGeoJSON
• ST_3DDistance
• Integration with the PostgreSQL 9.1 extension system
• Improved commandline shapefile loader/dumper
• Multi-file import support in the shapefile GUI
• Multi-table export support in the shapefile GUI
• A geo-coder optimized for free US Census TIGER (2010) data
  

More Details

Surging demand drives EnterpriseDB to release a new version of Postgres Enterprise Manager with SNMP and email alerts, an audit manager and user access controls, dramatically expanding its enterprise-class feature set

BEDFORD, Mass. EnterpriseDB, the leading worldwide provider of PostgreSQL and Oracle database compatibility products and services, today announced the growing interest in Postgres among larger enterprises has driven the number of installations of its Postgres Enterprise Manager (PEM) to more than 2,000 in just six months. In response to the outpouring of interest and demand, EnterpriseDB has released Postgres Enterprise Manager 2.1 with a collection of new features designed to further address the more complex needs of managers with very large-scale Postgres deployments.

PEM 2.1 adds a series of highly configurable dashboards, new features for scheduling and organizing management tasks and enhanced alerting capabilities. The new version further eases the management of large-scale PostgreSQL deployments by giving managers the ability to control user access on a per-server basis.

Postgres Enterprise Manager was released in August to equip users with an enterprise-class tool designed for managing large-scale deployments of PostgreSQL or Postgres Plus Advanced Server. The tool provides database administrators with a single console to monitor, manage and tune multiple Postgres installments simultaneously.

“More big companies are coming to us as the reliability and performance of Postgres achieves greater recognition among the Fortune 500. We’re keeping pace by making the tools that these power users need to manage vast deployments,” Ed Boyajian, president and CEO of EnterpriseDB, said. “Combining end user feedback and input from the developer community, we developed Postgres Enterprise Manager 2.1 to give users greater insight into their installations and greater flexibility to manage them. And we will continue to innovate in keeping with our mission to provide the enterprise with a powerful database to rival traditional, proprietary databases but at a fraction of the price.”

"We've recently worked with clients who have deployed Postgres Enterprise Manager to manage their large, multi-instance deployments of Postgres," Joseph Conway, President and CEO of credativ Group LLC, said. "PEM is an excellent visual tool that greatly simplifies the management, monitoring and tuning of these instances, and clients have reported they've achieved significant time savings in a very short amount of time."

Enhanced Alerts, New Dashboards and More

Postgres Enterprise Manager 2.1 – the only management tool of its kind for PostgreSQL and Postgres Plus Advanced Server – includes the following enterprise-class enhancements:

SMTP and SNMP Alerting – The management tool may now be configured to send alerts over regular email, using Simple Mail Transfer Protocol (SMTP), or through complementary software solutions, using Simple Network Management Protocol (SNMP). PEM 2.1 further enables end users to designate the delivery mechanism on a per-alert basis and includes “flap detection” so users aren’t flooded with unnecessary alert messages. PEM 2.1 also significantly expands the ability to configure alert definitions.

Audit Manager – End users now have the power to perform bulk configurations of audit features on the servers hosting Postgres Plus Advanced Server. They can schedule when the database gathers log information, which is stored centrally. Further, users can review the logs using a new dashboard that is visually comparable to social networking tools and loads the log files on-demand as the end user scrolls.

Role-based User Designations – Administrators now have the power to define or limit visibility of specific servers using role-defined controls. Enhancing flexibility and easing overall administration, this ability gives administrators the mechanisms they need to efficiently use Postgres Enterprise Manager in multi-team environments.

Expanded Dashboards – The dashboards now use Ajax to load charts and graphs and therefore can auto-refresh on a configurable, per-item interval. End users will find enhanced navigation within the dashboards, and expanded tables in other dashboards. Users may also configure alerts directly from the dashboards by clicking on the alert name.

High-Availability Support – Administrators may link Postgres Enterprise Manager to high-availability systems so that server monitoring can be moved automatically to the standby host in the event that a server is failed over. SQL Profiler – Feature enhancements allow filtering on any field giving users insight into server activity and helping diagnose and fix poorly performing SQL statements.

Server and Agent Installers – The server installer enables the end user to install PEM database server and web services on different machines; the agent installer has been enhanced to allow users to specify alternate locations for storing certificates used for authentication.

To download Postgres Enterprise Manager, please visit our Postgres Enterprise Manager page for more details.

Connect with EnterpriseDB

Learn more about EnterpriseDB:

• Read the blog: http://blogs.enterprisedb.com
• Follow us on Twitter: http://www.twitter.com/enterprisedb
• Become a fan on Facebook: http://www.facebook.com/EnterpriseDB?ref=ts
• Join us on Google+: https://plus.google.com/108046988421677398468

About EnterpriseDB Corporation

EnterpriseDB, the Enterprise PostgreSQL Company, provides enterprise-class PostgreSQL products and PostgreSQL services to help IT organizations be successful with the world's most advanced open source database. The company's Postgres Plus products are ideally suited for transaction-intensive applications requiring superior performance, massive scalability and compatibility with proprietary database products to reduce overall database costs. EnterpriseDB has offices in North America, Europe and Asia. The company was founded in 2004 and is headquartered in Bedford, MA. For more information, please call +1-781-357-3390, or visit www.enterprisedb.com

EnterpriseDB, Postgres Plus and Postgres Enterprise Manager are trademarks of EnterpriseDB Corporation. Other names may be trademarks of their respective owners.

Media Contact

• Renee Deger
• Phone: 415-432-2439
• Email: renee.deger@lewispulse.com

ServiceStack.OrmLite is an open source configuration-free lightweight ORM for .NET and Mono. As of version 3.48 ServiceStack.OrmLite supports PostgreSQL using npgsql provider.

Read ServiceStack.OrmLite intro and Release notes to get more information.

Version 5.0.4

Released: 22th March 2011

This fourth update of the phpPgAdmin 5.0 branch brings some bug and security fixes. Details bellow.

Download

To download phpPgAdmin 5.0.4 right now, visit:

http://phppgadmin.sourceforge.net/doku.php?id=download

Changelog

Some bug fixes.

• Fix #3468882 "UPDATE single row with varchar key: empty where clause", reported by "Dirk Kraemer"
• Fix XSS in function.php, reported by Mateusz Goik
• Fix bug where renaming a tablespace was leading to an error
• Fix a bug where clicking to "Show all schemas" on schema privilege page leads back to the latest tab used in database level
• Fix a bug when executing a query from the history
• Fix bad confirmation message when droping an autovacuum table setup
• Fix bug #3429633 '"Back" link from "Browse" leads to error'
• Fix a PHP warning when Slony conf parameters are not set
• Show cancel/kill actions in process page only if role is a superuser
• Some more small code cleanup and fixes.

The phpPgAdmin team

Navicat Data Modeler is a powerful and easy-to-use database design tool for creating and manipulating data models for PostgreSQL.

Navicat Data Modeler is a standalone product allowing users to visually design database structures, perform reverse/forward engineer process, import table structures from ODBC data sources, generate SQL files and print models to files, etc.

With Navicat Data Modeler's features, users can easily create high quality data models and understand database structures.

Download URL: [HTML_REMOVED]http://www.navicat.com/en/download/download.html[HTML_REMOVED]

Google has once again selected the PostgreSQL project to take part in Summer of Code 2012. Google will be funding several students to work with mentors from our project in order to hack PostgreSQL code for the summer.

Applications for students open March 26th. Our Summer Of Code page has all the information you need about applying this year.

If you are connected with a university, please make sure that students know about this opportunity. If you are a student, please apply!

This important release introduces support for MacOSX using RAD Studio XE2, greatly improves FireMonkey support, and fixes nasty bug with rare TPSQLMonitor freezing.

Full changelog:

• [!] FireMonkey and cross platform support improved a lot
• [!] Support for custom connection parameters added to TPSQLDatabase.Params
• [+] EPGLibraryNotFoundException class introduced
• [+] TPSQLDatabase.OnException event added
• [+] TPSQLDatabase.Ping method added
• [+] TPSQLDatabase.UseSingleLineConnInfo property added
• [+] TPSQLNotify polling loop rewritten using threads
• [*] Handling of "libpq library not found" exception improved
• [*] Nag trial screen removed
• [*] OS GUI dependencies eliminated. Console application creating improved a lot
• [-] "XE and higner applications hang on close if TPSQLMonitor used" bug fixed

Download

You're welcome to download the PostgresDAC v2.8.0 right now at: http://microolap.com/products/connectivity/postgresdac/download/ or login to your private area on our site at http://microolap.com/my/downloads/

Feedback

Please don't hesitate to ask any questions or report bugs with our Support Ticketing system.

DbWrench is a database design and synchronization software.

It is designed to increase the productivity of database developers by making creating and modifying databases much easier.

It's features include:

• a graphic entity relation diagram (ERD) designer

• forward engineer database designs with automatic SQL DDL script generation

• reverse engineer and visualize existing databases

• a built in syntax highlighting SQL query editor

• runs on Windows, Mac OSX and Linux all in a single license
  

New in this release:

• 3 New ER Notations: Bachman, Barker and Information Engineering.

• Support for Scalable Vector Graphics (SVG)

• Ability to specify schemas to ignore during forward and reverse engineering

• When the generated DDL scripts rebuild a table, the script will contain an explanation of why the tables need to be rebuilt.

A free trial download is available at [HTML_REMOVED] www.dbwrench.com[HTML_REMOVED].[HTML_REMOVED][HTML_REMOVED]

Screen shots can be viewed [HTML_REMOVED] here[HTML_REMOVED].[HTML_REMOVED][HTML_REMOVED]

DbWrench is a database design and synchronization software.

It is designed to increase the productivity of database developers by making creating and modifying databases much easier.

It's features include:

• a graphic entity relation diagram (ERD) designer

• forward engineer database designs with automatic SQL DDL script generation

• reverse engineer and visualize existing databases

• a built in syntax highlighting SQL query editor

• runs on Windows, Mac OSX and Linux all in a single license
  

New in this release:

• 3 New ER Notations: Bachman, Barker and Information Engineering.

• Support for Scalable Vector Graphics (SVG)

• Ability to specify schemas to ignore during forward and reverse engineering

• When the generated DDL scripts rebuild a table, the script will contain an explanation of why the tables need to be rebuilt.

A free trial download is available at [HTML_REMOVED] www.dbwrench.com[HTML_REMOVED].[HTML_REMOVED][HTML_REMOVED]

Screen shots can be viewed [HTML_REMOVED] here[HTML_REMOVED].[HTML_REMOVED][HTML_REMOVED]