PostgreSQL news
- Intelligent Converters released PostgreSQL-to-MySQL and MySQL-to-PostgreSQL converters
When thinking about open-source relational databases, many people face dilemma how to choose between two the most popular systems: MySQL and PostgreSQL. Both of them are cross-platform, time proven solutions having a lot of users ranged from individuals and small business to huge corporations. In order to resolve this issue Intelligent Converters released solutions to migrate MySQL databases to PostgreSQL server and vice versa. Both products have high performance due to direct connection to data source and destination databases (they do not use ODBC or any other middleware software). Command line support allows to script, automate and schedule the conversion process. Intelligent Converters invites both end-users and media people to try PostgreSQL to MySQL and backward conversion using free demo version of the products:
[HTML_REMOVED]http://www.intelligent-converters.com/pgs2sql.htm[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED]http://www.intelligent-converters.com/sql2pgs.htm[HTML_REMOVED][HTML_REMOVED]
Demo version allows to convert only five records for each database table, all other features are in place.
[HTML_REMOVED]Features[HTML_REMOVED][HTML_REMOVED] [HTML_REMOVED] [HTML_REMOVED]All versions of PostgreSQL are supported[HTML_REMOVED] [HTML_REMOVED]All versions of Unix and Windows MySQL are supported[HTML_REMOVED] [HTML_REMOVED]Fast conversion engine (about 10,000 records per second of average P-IV system)[HTML_REMOVED] [HTML_REMOVED]Option to merge data into an existing database[HTML_REMOVED] [HTML_REMOVED]Option to convert individual tables[HTML_REMOVED] [HTML_REMOVED]Converts indexes with all necessary attributes[HTML_REMOVED] [HTML_REMOVED]Command line support[HTML_REMOVED] [HTML_REMOVED]Stores conversion settings into profile[HTML_REMOVED] [HTML_REMOVED]Support for multibyte character sets[HTML_REMOVED] [HTML_REMOVED]Easy-to-use wizard-style interface[HTML_REMOVED] [HTML_REMOVED]Full install/uninstall support[HTML_REMOVED] [HTML_REMOVED]Unlimited 24/7 support service[HTML_REMOVED] [HTML_REMOVED]1-year subscription for updates[HTML_REMOVED] [HTML_REMOVED]
More information about PostgreSQL-to-MYSQL and MySQL-to-PostgreSQL can be found here:
[HTML_REMOVED]
- PostgreSQL 9.2 Beta 1 Available for Testing
The PostgreSQL Global Development Group announces the beta release of PostgreSQL 9.2, which will include major increases in performance and both vertical and horizontal scalability. The PostgreSQL Project asks all users to download and begin testing 9.2 Beta as soon as possible.
Major performance and scalability advances in this version include:
- Index-only scans, allowing users to avoid inefficient scans of base tables
- Enhanced read-only workload scaling to 64 cores and over 300,000 queries per second
- Improvements to data write speeds, including group commit
- Reductions in CPU power consumption
- Cascading replication, supporting geographically distributed standby databases
PostgreSQL 9.2 will also offer many new features for application developers, including:
- JSON data support, enabling hybrid document-relational databases
- Range types, supporting new types of calendar, time-series and analytic applications
- Multiple improvements to ALTER and other statements, easing runtime database updates
For a full listing of the features in version 9.2 Beta, please see the release notes.
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.2 Beta and try it with your workloads and applications as soon as you can, and give feedback to the PostgreSQL developers. More information on how to test and report issues
Get PostgreSQL 9.2 beta, 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.
- AnySQL Maestro 12.5 released
SQL Maestro Group announces the release of AnySQL Maestro 12.5, a powerful tool for managing any database engine accessible via ODBC driver or OLE DB provider (PostgreSQL, MySQL, SQL Server, Oracle, Access, etc).
The new version is immediately available at
http://www.sqlmaestro.com/products/anysql/maestro/.AnySQL Maestro comes in both Freeware and Professional editions.
Top 10 new features:
- Report Designer.
- Support for auto increment columns for MS SQL Server and MS Access.
- SQL Editors: Unicode support, text change markers, and improved code folding appearance.
- Enhanced performance of the SQL Script Editor tool.
- Improved Script Runner.
- Inline images in the data grid.
- Displaying BLOB data as PDF.
- Creation of views from Visual Query Builder.
- Updated Data Input form.
- Spanish translation.
There are also some other useful things. Full press release is available at the SQL Maestro Group website.
- PostgreSQL Magazine #01 is out !
The PGMag team is very pleased to announce the release of the first issue of PostgreSQL Magazine.
This issue #01 is brought to you thanks to the collective work of dozen of people. Writers, Editors, Reviewers. Kudos to them all !
Here's a quick view of the ToC :
- PostgreSQL 9.1 : 10 awesome new features
- NoSQL : The Key Value store everyone ignored
- Interview : Stefan Kaltenbrunner
- Opinion : Funding PostgreSQL Features
- Waiting for 9.2 : Cascading Streaming Replication
- Tips & Tricks : PostgreSQL in Mac OS X Lion
The magazine is available online and on paper. You can either :
Finally, I would like to thank our benefactorsБ─╕ Fotolia.com has offered us a free subscription plan to access their stock photo database. We also received fundings from PostgreSQL Europe (PGEU) and Software in the Public Interest (SPI). Thanks a lot to them !
- Bull Announces the Formation of Database Migration Business Unit
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 AnyDAC Spring 2012 (v 5.0.7) released
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 2.0.0 Released
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 :
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
- Postgres Enterprise Manager 2.1 is released
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
- .Net and Mono lightweight ORM ServiceStack.OrmLite supports PostgreSQL
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.
- phpPgAdmin 5.0.4 released
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