Jump to content

Posts Tagged ‘postgres plus advanced server’


Are Oracle Price Increases Affecting Your Budget?

Monday, August 3rd, 2009 by Sean Crowley

Today EnterpriseDB introduced a program to show you just how easy it is to migrate from Oracle to Postgres Plus Advanced Server AND save a considerable amount of money at the same time.

Companies such as Sony Online Entertainment and FTD have already enjoyed considerable savings by migrating from Oracle to Postgres Plus Advanced Server using our Oracle compatibility technology.  In fact, the technology is so reputable that IBM recently licensed it for use in DB2.

We created the Oracle Migration Assessment Program after Oracle recently raised prices on database modules by as much as 40 percent. This comes on the heels of license increases of up to 20 percent in 2008.  An Oracle Migration Assessment report from EnterpriseDB scans, analyzes, categorizes, details, and scores the work necessary to move your Oracle database to the open source based, Oracle compatible, and reasonably priced Postgres Plus Advanced Server.

The program enables enterprises to migrate their applications running on Oracle to Postgres Plus Advanced Server, a PostgreSQL-based database containing an Oracle compatibility layer, with no disruption to operations, and delivers ongoing cost savings of 80 percent or more.

Your Oracle Migration Assessment is performed by an experienced Oracle engineer who will work with your staff to provide you an accurate and reliable report on the viability of migrating your Oracle database complete with time and cost estimates.  You can have our migration experts assist you or have us do all the work.  We also have a full suite of tools, documentation, training, and best practices to guide you through doing the switch yourself.

Interested in trying out our new program?  Read more about it here, or contact us to schedule your Oracle Migration Assessment today.

Are Oracle Price Increases Affecting Your Budget?



Features We Do Want

Monday, June 29th, 2009 by Jim Mlodgenski

One of the cool new features in the recent Postgres Plus Advanced Server release is the EDB*Wrap functionality. This fills a need in the ISV community coming from both the PostgreSQL world as well as Oracle by allowing developers to obfuscate their stored procedure code. Interestingly, this marks the second feature along with Optimizer Hints part of Postgres Plus that is “officially” designated as features the PostgreSQL community does not want.

http://wiki.postgresql.org/wiki/Todo#Features_We_Do_Not_Want

The open source dweeb in me agrees with the community’s philosophies that PostgreSQL’s optimizer should be made smarter and the obfuscation is not 100% effective, but both features fill a business need. For EDB*Wrap, the business need is to make it difficult for people to see the source code of a stored procedure when it is sent as a plain text file.

So while it is not 100% effective, when an ISV shipping their stored procedure code encounters a malicious user who has the ability to turn:

$__EDBwrapped__$
UTF8
d86XAumhB/6bQTdJStisuVDG2FE3+vUz2Bjq2neAax7iG8Vg2++x1stc0gN3pCDO1+jnOc7orT9X
4sepJrX8Vn2nEf58u+V6f5UWLj43i2hDCO9iPyEa08jA8CuTFq0dL+B0DK5ymSL2MIrRMOz/eGn0
XEaU9TgaraXbIJhlNtCf
$__EDBwrapped__$

Into:
CREATE FUNCTION foo() RETURNS integer AS $$
BEGIN
RETURN 1;
END;
$$ LANGUAGE plpgsql;

That same user can also decompile their main application and their whole application becomes “open source” to the bad guy. In the commercial world, it is hard to hold back features customers are requesting because of a corner case you can manage through other means.

Features We Do Want



General Availability of Postgres Plus Advanced Server v8.3 Release 2 (8.3 R2)

Tuesday, June 16th, 2009 by Sean Crowley

EnterpriseDB is excited to announce the immediate General Availability of Postgres Plus Advanced Server v8.3 Release 2 (8.3 R2).

This customer-driven release continues to build beyond the features and performance found in the community version of PostgreSQL while decreasing the risk and cost in time, money, and re-training to switch to an affordable open source database technology. The new capabilities focus on deeper Oracle compatibility, even easier migrations from other databases, and performance and scalability unmatched by any PostgreSQL database. Additionally, there are multiple component maintenance upgrades and over 200 minor fixes and enhancements.

What’s in it for you? Some of the release highlights include:

  • Deeper Oracle support for objects, packages, transaction management, and migration reduces the risk and cost of adopting open source database technology by allowing you to better leverage your investment in Oracle skills and lower the cost of migrating and adopting a world class open source database built on PostgreSQL
  • Infinite Cache improves performance up to 5 times faster than the PostgreSQL community version while reducing costs for massive scalability across your existing commodity hardware footprint
  • LDAP and PAM Security support allow easier application customization while EDB*Wrap protects sensitive or proprietary code
  • New / updated documentation

Download 8.3 R2 now for Linux, Windows or Mac. For all the details inside the release, see the Release Notes at the same link above or check out the documentation.

The award-winning Postgres Plus products based on PostgreSQL come available with industry leading services such as 24×7 technical support, expert-delivered training for DBAs and application developers, pre-packaged services, and professional consulting.

General Availability of Postgres Plus Advanced Server v8.3 Release 2 (8.3 R2)