Database

Free EnterpriseDB Agile NoSQL Development

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.

The key message here for developers is one of increased productivity: developers using Postgres are no longer bound by the confines of a rigid data model -- with the ability to work with both structured and unstructured data, developers can build demanding applications utilising standardised business logic that can also evolve with agile development objectives.
NOTE: Postgres Extended Datatype Developer Kit integrates and configures multiple developer tools needed for building applications with JSON/JSON B and HStore in Postgres. The toolkit includes PostgreSQL 9.4 beta, a web server and implementations of Ruby, Ruby on Rails, Node.js, and Python. In the fall, EDB will release a version with PL/V8 providing an integrated JavaScript language.

Dr. Dobb's encourages readers to engage in spirited, healthy debate, including taking us to task.
However, Dr. Dobb's moderates all comments posted to our site, and reserves the right to modify or remove any content that it determines to be derogatory, offensive, inflammatory, vulgar, irrelevant/off-topic, racist or obvious marketing or spam. Dr. Dobb's further reserves the right to disable the profile of any commenter participating in said activities.

Video

This month's Dr. Dobb's Journal

This month,
Dr. Dobb's Journal is devoted to mobile programming. We introduce you to Apple's new Swift programming language, discuss the perils of being the third-most-popular mobile platform, revisit SQLite on Android
, and much more!