InfoQ Homepage Postgres Content on InfoQ
-
AWS Announces New Database Service Babelfish for Aurora PostgreSQL in Preview
During the AWS re:Invent keynote, AWS announced the new database service Babelfish for Aurora PostgreSQL in Preview. The service is a fully-managed, PostgreSQL-compatible and ACID-compliant relational database engine that runs in the Amazon cloud and is open-source.
-
Amazon Announces General Availability of Aurora Multi-Master
In a recent announcement, Amazon has publicized the general availability of Aurora Multi-Master, which allows for reading and writing on multiple database instances across several Availability Zones. Consequently, this brings high availability capabilities, as the platform no longer needs to trigger a fail-over upon failure of database instances.
-
Amazon Releases Aurora PostgreSQL Serverless to General Availability
Recently, Amazon announced the general availability of the PostgreSQL-compatible edition of Aurora Serverless.
-
Timescale Cloud: Managed Time Series Database on Azure, Google Cloud and AWS
Timescale announced the availability of Timescale Cloud, a fully managed version of their time series database on Azure, GCP, and AWS. It provides time series analysis functions, the ability to scale up and down, visualization integration with tools like Grafana and Tableau, and data encryption.
-
The Guardian’s Migration from MongoDB to PostgreSQL on Amazon RDS
The Guardian migrated their CMS’s datastore in 2018 from a self-managed MongoDB cluster to PostgreSQL on Amazon RDS for a fully managed solution. The team did an API-based migration without any downtime.
-
High Volume Space Exploration Time-Series Data Storage in PostgreSQL
The European Space Agency Science Data Center (ESDC) switched to PostgreSQL with the TimescaleDB extension for their data storage. ESDC’s diverse data includes structured, unstructured and time series metrics running to hundred of terabytes, and querying requirements across datasets with open source tools.
-
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.