BT

Ready for InfoQ 3.0? Try the new design and let us know what you think!

DevOps Follow 1058 Followers

High Volume Space Exploration Time-Series Data Storage in PostgreSQL

by Hrishikesh Barua Follow 18 Followers on  Oct 13, 2018 1

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.

Cloud Follow 379 Followers

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

by Steef-Jan Wiggers Follow 10 Followers on  Mar 28, 2018

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.

Development Follow 786 Followers

Preview of New Features in MySQL 8

by Alex Giamas Follow 10 Followers on  Feb 27, 2018

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.

Development Follow 786 Followers

Postgres 10 Features for Developers

by Alex Giamas Follow 10 Followers on  Dec 24, 2017

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.

Development Follow 786 Followers

A Preview of Coming Features in PostgreSQL 10

by Sergio De Simone Follow 21 Followers on  Apr 16, 2017

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.

Development Follow 786 Followers

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

by David Iffland Follow 4 Followers on  Feb 21, 2017

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.

Architecture & Design Follow 2650 Followers

Uber Engineering Moving from Postgres to MySQL

by Alex Giamas Follow 10 Followers on  Aug 12, 2016 1

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.

Followers

Slick 3: Reactive Streams for Asynchronous Database Access in Scala

by Mirko Stocker Follow 1 Followers on  May 09, 2015 5

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.

Followers

PostgreSQL advances in the JSON datastore landscape

by Alex Giamas Follow 10 Followers on  Apr 02, 2015

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

Followers

Npgsql Gets Visual Studio Data Designer Integration, JSONB Support

by Roopesh Shenoy Follow 0 Followers on  Sep 08, 2014

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.

Followers

PostgreSQL Gets Better NoSQL Capabilities

by Roopesh Shenoy Follow 0 Followers on  May 23, 2014

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.

Followers

Amazon RDS Supports PostgreSQL

by Roopesh Shenoy Follow 0 Followers on  Nov 18, 2013

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.

Followers

Postgres Gets Even More Reliability, High Availability, Several Developer-Friendly Features

by Roopesh Shenoy Follow 0 Followers on  Sep 17, 2013

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.

Followers

SOLID Database Design With PostgreSQL

by Roopesh Shenoy Follow 0 Followers on  Feb 26, 2013

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.

Followers

MoSQL: Synchronizing MongoDB and PostgreSQL Made Easy

by Jonathan Allen Follow 657 Followers on  Feb 06, 2013

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.

BT