Serverless Aurora MySQL has been around for awhile, but this is the first release of serverless Aurora for PostgreSQL.
In related news, the Aurora development team just won the 2019 ACM SIGMOD Systems Award.
Best storage practices for running production workloads on hosted databases with Amazon RDS or Amazon EC2
The title says it all; highly recommended reading.
A case study of modernizing a legacy data warehouse on AWS, using Redshift, including lessons learned.
From Udemy Engineering, a brief overview of how column stores like Redshift differ from traditional relational databases. The author discusses how to design a database to take advantage of Redhsift’s fundamental architecture.
An overview of improving table scans by paying attention to your attributes.
EnterpriseDB staff make major contributions to the PostgreSQL code base.
In a related development, Michael Stonebraker, the original architect of what is now PostgreSQL, will serve as a technical adviser to the company.
A cool new feature in the next release of PostgreSQL.
“This feature is known in various other DBMS as ‘calculated columns’, ‘virtual columns’, or ‘generated columns’.”
Pretty clever idea: reduce the size of the key used in sorting by hashing it. Probably not specific to PostgreSQL.
“Does anyone really know what time it is?”
A primer on all the various ways of representing time in PostgreSQL.
Amazon Aurora Supports Cloning Across AWS Accounts (2017-07-02)
AWS RDS for PostgreSQL Supports New Minor Versions (2017-07-03)
PostgreSQL versions 11.4, 10.9, 9.6.14, 9.5.18, and 9.4.23 are now available for RDS.
DBeaver 6.1.2 (Released 2019-07-07)
pgAdmin 4.10 (Released 2019-07-04)
Practices and Architecture
Summary of an interview with Martin Kleppmann, author of Designing Data-Intensive Applications, which is becoming an influential book in the field.
A brief primer with helpful graphics.