InfoQ Homepage Postgres Content on InfoQ
-
Yugabyte Cloud: a Managed Distributed SQL Database
At the recent Distributed SQL Summit, Yugabyte announced the general availability of Yugabyte Cloud, a database-as-a-service version of the Postgres compatible YugabyteDB.
-
Amazon Aurora Supports PostgreSQL 13
AWS has recently announced that Amazon Aurora supports major version 13 of PostgreSQL. The compatibility with the latest major PostgreSQL version adds improvements such higher performing partitioned table queries and deduplication of B-tree index entries.
-
Google Logica Aims to Make SQL Queries More Reusable and Readable
Logica is a Datalog-like declarative logic programming language for database querying. It supports the creation of reusable abstractions to build complex queries and compiles to SQL, thus making it suitable for wide application.
-
Netflix Embraces GraphQL Microservices for Rapid Application Development
Netflix engineering recently published a blog post detailing how Netflix embraced GraphQL microservices for rapid application development. In this post, Dane Avilla, a senior software engineer at Netflix, describes their key learnings in the process and how GraphQL lends itself well for proof-of-concept development.
-
Designing for Failure in the BBC's Analytics Platform
Last week at InfoQ Live, Blanca Garcia-Gil, principal systems engineer at BBC, gave a session on Evolving Analytics in the Data Platform. During this session, Garcia-Gil focused on how her team prepared and designed for two types of failure - "known unknowns" and "unknown unknowns."
-
AWS Announces Amazon Aurora Supports PostgreSQL 12
AWS has recently announced that Amazon Aurora, a MySQL and PostgreSQL-compatible relational Database built for the Cloud, now supports major version 12 of PostgreSQL.
-
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.