This article discusses PostgreSQL as a JSON datastore in a world of document storage systems. JSON based datastores have been gaining popularity in the past years. Following on the increasing popularity of MongoDB, CouchDB, RethinkDB, ToroDB and others are focusing on storing and retrieving JSON documents as seamlessly as possible...Is PostgreSQL going to be your next JSON database?...we answer it
Npgsql 2.2.0 comes as a feature packed release. The release adds VS Data Designer support, several Entity Framework-specific improvements and support for the Postgres 9.4 feature, the JSONB datatype.
PostgreSQL 9.4 Beta comes with the much-anticipated "binary JSON" type, JSONB. This new storage format for document data is higher-performance and comes with indexing, functions and operators for manipulating JSON data.
Amazon RDS adds PostgreSQL to the list of databases supported by the service. The launch supports Postgres version 9.3.1 with plans to support new versions as they become available.
PostgreSQL 9.3 comes with Fast Fail-over and streaming-only Remastering as well as many developer-focussed features such as materialized views, auto-updateable views, many features for JSON data-type and more.
Chris Travers recently published a series of articles titled “Building SOLID Databases”. He explains several ideas on how to apply some of the common OOP principles such as Single Responsibility Principle, Interface Segregation, Dependency Inversion to improve data models and database code.
San Francisco based Stripe has announced MoSQL, a tool for making reporting from MongoDB much easier via a live-replicating PostgreSQL database. MoSQL is based on MongoRiver, their companion product for monitoring MongoDB data updates in near-realtime.
Heroku Dataclips 2.0 are a new way of sharing data - much like GitHub Gists. Exposing results of running SQL statements agains Postgres databases, Dataclips render in HTML, IFrames, CSV, XLS and JSON. Supporting revisions and versioning as well as forking they work as self-updating stand-alone data views or as simple HTTP based data APIs.
PostgreSQL and Neo4J, a relational and a graph database respectively, are among the latest data stores taking the route to the cloud.
Until now, Postgres was only available to Heroku customers for use with Heroku platform apps. This new service can be used from anywhere and with any Postgres client. Apps can connect from Heroku, Google App Engine, Microsoft Azure, Cloud Foundry, EC2, or from your local computer while PostgreSQL is supported by most modern programming languages - including Perl, Python, Ruby, Scala ...
VMware is adding support for PostgreSQL to CloudFoundry, it's open source PAAS solution.