BT

Facilitating the spread of knowledge and innovation in professional software development

Contribute

Topics

Choose your language

InfoQ Homepage Postgres Content on InfoQ

  • Microsoft Announces General Availability of Azure Database Services for MySQL and PostgreSQL

    Microsoft has announced the general availability of Azure Database for MySQL and Azure Database for PostgreSQL. Both these open-source database engines are now brought in their community version as a managed service, with 99.99% SLA, elastic scaling for performance, and industry-leading security and compliance to Azure.

  • Preview of New Features in MySQL 8

    MySQL is gearing up for its 8th version, expected to be released in 2018. A full 28 months since the first general release for MySQL 5.7.9, there have already been five release candidates for MySQL 8, ranging from 8.0.0 to 8.0.4. In this article we explore the best features that MySQL 8 will bring to developers when it gets a GA release.

  • Postgres 10 Features for Developers

    The 10th version of the popular RDBMS PostgresSQL was released a few weeks ago. Postgres 10 brings several new features among which some are mostly exciting for developers. 10Clouds explained in details some of these features in a blog post. We will go through the features that are mostly interesting for developers and the relatively few breaking changes.

  • A Preview of Coming Features in PostgreSQL 10

    While PostgreSQL continues to progress towards its tenth major release in September 2017, EnterpriseDB Chief Architect and PostgreSQL contributor Robert Hass compiled a list of notable features that will likely make it into PostgreSQL 10 based on its official roadmap.

  • GitLab.com Postmortem Digs into Root Causes of 18 Hour Outage

    GitLab's postmortem into the root cause of their 18 hour site outage is a detailed look at how the incident began, how it got worse before it got better, and how they plan to learn from the mistakes and improve the service.

  • Uber Engineering Moving from Postgres to MySQL

    In a recent blog post, Uber detailed why they have chosen to replace PostgreSQL with MySQL. In this article we present a high level overview of the problems they faced, how MySQL fares against them and some of the best rebuttals against the case presented by Uber.

  • Slick 3: Reactive Streams for Asynchronous Database Access in Scala

    Slick, Typesafe's database query and access library for Scala, now supports the Reactive Streams API in the just released version 3.0. This enables developers to query their databases asynchronously and non-blocking. InfoQ talked to Slich Tech-Lead Stefan Zeiger to learn more about the new features and what they've planned for the future.

  • PostgreSQL advances in the JSON datastore landscape

    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 Gets Visual Studio Data Designer Integration, JSONB Support

    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 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.

BT