InfoQ Homepage Postgres Content on InfoQ
-
Amazon Aurora DSQL: Distributed SQL Database with Active-Active High Availability
At the recent AWS re:Invent conference in Las Vegas, Amazon announced the public preview of Aurora DSQL, a serverless, distributed SQL database featuring active-active high availability. This new PostgreSQL-compatible database option has generated significant excitement within the AWS community and was widely regarded by attendees as the standout announcement of the conference.
-
From Aurora DSQL to Amazon Nova: Highlights of re:Invent 2024
The 2024 edition of re:Invent has just ended in Las Vegas. As anticipated, AI was a key focus of the conference, with Amazon Nova and a new version of Sagemaker among the most significant highlights. However, the announcement that generated the most excitement in the community was the preview of Amazon Aurora DSQL, a serverless, distributed SQL database with active-active high availability.
-
Aurora Limitless: AWS Introduces New PostgreSQL Database with Automated Horizontal Scaling
AWS has announced the general availability of Amazon Aurora PostgreSQL Limitless Database, a relational database designed to provide automated horizontal scaling. This new option can handle millions of write transactions per second and manage petabytes of data, all within a single database environment.
-
Timescale Bolsters AI-Ready PostgreSQL with pgai Vectorizer
Timescale recently expanded its PostgreSQL AI offerings with pgai Vectorizer. This update enables developers to create, store, and manage vector embeddings alongside relational data without the need for external tools or additional infrastructure.
-
Amazon Aurora Introduces Global Database Writer Endpoint for Distributed Applications
Amazon Aurora has recently introduced a Global Database writer endpoint to streamline routing for applications in disaster-recovery scenarios. This highly available global endpoint removes the need for application code changes to reestablish connectivity following a cross-region switchover or failover operation.
-
PostgreSQL 17 Released with Improved Vacuum Process and Performance Gains
The PostgreSQL Global Development Group recently announced the general availability of PostgreSQL 17, the latest version of the popular open-source database. This release focuses on performance improvements, including a new memory management implementation for vacuum, storage access optimizations, and enhancements for high-concurrency workloads.
-
How Amazon Aurora Serverless Manages Resources and Scaling for Fleets of 10K+ Instances
AWS engineers published a paper describing the evolution and latest design of resource management and scaling for the Amazon Aurora Serverless platform. Aurora Serverless uses a combination of components at different levels to create a holistic approach for dynamically scaling and adjusting resources to satisfy the needs of customer workloads.
-
Google Introduces Free Trial for AlloyDB PostgreSQL Database
Google has announced a free trial program for AlloyDB, its fully-managed PostgreSQL-compatible database service. The trial allows users to test AlloyDB's capabilities with their own workloads for up to 30 days. AlloyDB is designed to provide high performance, scalability, and reliability, while maintaining full compatibility with open-source PostgreSQL.
-
Google Provides Extended Support for Cloud SQL MySQL and PostgreSQL End-of-Life Versions
Google Cloud has announced extended support for end-of-life Cloud SQL MySQL and PostgreSQL versions to help users maintain database operations and plan upgrades more efficiently. Starting February 1, 2025, versions such as MySQL 5.6, 5.7 and PostgreSQL 9.6 to 12 will enter an extended support phase, allowing customers to continue using these versions beyond their standard support dates.
-
Running PostgreSQL in the Browser with WebAssembly
With the recently released PGlite, a WASM build of Postgres that is packaged into a TypeScript client library, developers can run Postgres queries in the browser with no extra dependencies. PGlite is used for reactive, real-time, local-first apps.
-
Reddit Migrates Media Metadata from S3 and Other Systems into AWS Aurora Postgres
Reddit consolidated its media metadata storage into a new architecture using AWS Aurora Postgres. Previously, the company sourced media metadata from various systems, including directly from AWS S3. The new solution simplifies media metadata retrieval and handles 100k+ requests per second with latency below 5ms (p90).
-
Transactional Serverless Computing: PostgreSQL Creator Announces DBOS Cloud
The creators of DBOS have recently introduced DBOS Cloud, a transactional serverless application platform tailored for TypeScript developers. With all state information stored in a highly available DBMS, this new platform assures transactional serverless computing, offering reliable execution alongside so-called "time travel" capabilities.
-
The Guardian Creates a Newsroom Collaboration Tool Using Serverless, React and GraphQL
The Guardian created Pinboard, a discussion and asset-sharing tool integrated into a variety of content management platforms used by the company. The solution uses a range of technologies, including Typescript for coding the business logic, different serverless services for code execution, API endpoints, and GraphQL server, as well as AWS RDS (PostgreSQL) for storage.
-
Instacart Creates Real-Time Item Availability Architecture with ML and Event Processing
Instacart combined machine learning with event-based processing to create an architecture that provides customers with an indication of item availability in near real-time. The new solution helped to improve user satisfaction and retention by reducing order cancellations due to out-of-stock items. The team also created a multi-model experimentation framework to help enhance model quality.
-
AWS to Shut down Aurora Serverless v1, Their Sole Relational Database with Scaling Capacity to Zero
Recently, AWS notified existing customers running Amazon Aurora that Serverless v1 support will be discontinued, with the service scheduled to shut down within a year. The absence of scaling to zero in the newer Aurora Serverless v2 has raised concerns within the community regarding potential increased costs and the absence of a "true" serverless relational database on AWS.