Postgres product and Oracle database compatibility solutions company EnterpriseDB (EDB) has announced a free ready-to-code development environment on Amazon Web Services optimized for using the NoSQL capabilities in PostgreSQL to build web 2.0 applications.
Postgres Extended Datatype Developer Kit (or the very catchy PGXDK) makes it easier for developers (of any skill level) to use Postgres for the kinds of applications that until recently required a specialized NoSQL-only solution.
PostgreSQL is an open source object-relational database system with more than 15 years of active development and an architecture that has earned it an arguably strong reputation for reliability, data integrity, and correctness.
Postgres has expanded its capabilities for handling document databases, for example, with advanced support for JSON and JSONB. On key workloads, Postgres has been proven to outperform the most popular NoSQL-only solution.
The NoSQL-optimized environment comes with the core components that developers need to work with Postgres already preintegrated and preconfigured. Plus, it features a sample application with code examples to help developers get started. The free instances on Amazon's AWS position developers (so says the firm) to tap the powers of relational technology to build applications in an iterative and Agile development framework.
"Application developers need solutions that help them work faster and this Amazon AMI-based environment means they get up and running more quickly and have a much more powerful foundation to work on,” said Marc Linster, SVP of products at EnterpriseDB. “Postgres with NoSQL support has become a choice for enterprise applications because it can combine schema-less data with relational tables bridging structured and unstructured data.” NoSQL-only solutions pose a host of challenges, complexities and even serious risks to the enterprise. “By 2017, 50% of data stored in NoSQL DBMSs will be damaging to the business due to a lack of applied information governance policies and programs,” according to Gartner. Using Postgres to build applications to support unstructured data eliminates some of the challenges organisations are facing as the use of NoSQL-only solutions rise.