TrustRadius: an HG Insights company

EDB Postgres Advanced Server

Score10 out of 10

6 Reviews and Ratings

Get a Demo

What is EDB Postgres Advanced Server?

The EDB Postgres Advanced Server is an advanced deployment of the PostgreSQL relational database with greater features and Oracle compatibility, from EnterpriseDB headquartered in Bedford, Massachusetts.

Categories & Use Cases

Reviews

What users are saying about EDB Postgres Advanced Server.
View all reviews

Robust and Somewhat Daunting But Worth the Effort

Incentivized
Jonah DempcyView profile
Web & Mobile Developer in Engineering at Bluefire Productions (1-10 employees employees)

Pros

  • Developer tools including debugging, JSON and XML support, libraries for preferred languages and good examples all facilitated integration and development. Robust features for developers.
  • Security is top notch and supports far beyond what we required for our project, which is a good thing.
  • Performance, throttling, monitoring and optimization are all top notch and helped us keep response times low and save on bandwidth and hosting costs.

Cons

  • Documentation is excellent but spread out across many resources and can take a while to wade through—would benefit from having more intro level, getting started guides for various languages.
  • Ruby support is excellent but more Ruby examples and beginner-level documentation would be nice.
  • It is sometimes hard to find a community of users on StackOverflow so a larger community, and a dedicated forum with active members to answer questions and work through issues would be nice.

Return on Investment

  • Postgres Plus Advanced Server is quite complex and may take longer to implement certain things than simply using PostgreSQL depending on developer familiarity with the platform.
  • Getting up to speed can be daunting so again, there is an upfront cost in time spent learning the platform, besides the potential for extra time spent on a feature-by-feature basis.
  • The cost of Postgres Plus Advanced Server should be weighed against simply using PostgreSQL to decide which is the best solution for your business needs.

Alternatives Considered

Heroku and MySQL

Other Software Used

Dropbox for Business, Google Analytics, Google Drive

PostgreSQL Plus Advanced Server says yes to NoSQL

Incentivized
Jamey HansonView profile
Senior Software Engineer in Information Technology at Freedom Consulting Group, Inc. (51-200 employees employees)

Pros

  • PPAS Oracle compatibility, especially the PL/SQL syntax, has made migrating database-tier code very simple. Most Oracle packages do not need to be changed at all and those that do are generally for simple reasons like a reserved word in PPAS that is allowed in Oracle.
  • PPAS xDB, the multi-master replication tool, is simple and - most important - does not break with network or other interruptions. We have been able to configure and forget, which our customers could never do with other multi-master tools.
  • Most people had no idea that PPAS and PostgreSQL have full CRUD support for JSON. They think you need a specialized product and/or that JSON is read-only. Every organization that I have worked with is evaluating adding JSON to their relational model.

Cons

  • There are too many custom add-ons that should be part of the default installation. For example, PostGIS - the geospatial tool, foreign-data-wrappers, XML & HSTORE data types, UUIDs and other pieces are not included by default.
  • The marketing and related material is too focussed on technology and not enough on capability. For example, you would not know that full CRUD on JSON is supported unless you read all the material - that is a big deal, but they seem to miss it.
  • The backup and recovery tools are not as good as Oracle's and they should be improved.

Return on Investment

  • Simplified Oracle conversions because most of the PL/SQL does not need to be changed. This has allowed organizations that we support to do much of the conversion work themselves.
  • Allowed use of a single tool with mixed data types. For instance, no need to use a JSON-only product or a full-text-search tool because those are built in to PPAS.
  • Multiple customers added geo-spatial capabilities to their applications because PostGIS is simple and included.

Other Software Used

NetApp SnapMirror