InfoQ Homepage Postgres Content on InfoQ
-
PostgreSQL Gets Better NoSQL Capabilities
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 Supports PostgreSQL
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.
-
Postgres Gets Even More Reliability, High Availability, Several Developer-Friendly Features
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.
-
SOLID Database Design With PostgreSQL
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.
-
MoSQL: Synchronizing MongoDB and PostgreSQL Made Easy
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 - The Gist of Data
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 Are Making Their Way into the Cloud
PostgreSQL and Neo4J, a relational and a graph database respectively, are among the latest data stores taking the route to the cloud.
-
Heroku Launches Postgres as a Standalone Service.
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's CloudFoundry Service Gains Support for PostgreSQL
VMware is adding support for PostgreSQL to CloudFoundry, it's open source PAAS solution.