InfoQ Homepage Postgres Content on InfoQ
-
Reddit Migrates Comment Backend from Python to Go Microservice to Halve Latency
Reddit has rebuilt its core backend, migrating Comments, Accounts, Posts, and Subreddits from a legacy Python monolith to Go microservices. The migration improves performance, halves critical write latency, and modernizes the platform for future scalability while preserving correctness across multiple datastores.
-
QCon SF: Database-Backed Workflow Orchestration Challenges Traditional Architecture
During QCon SF, Jeremy Edberg and Qian Li from DBOS presented a non-conventional architectural approach to workflow orchestration: treating PostgreSQL not just as a data store, but as the orchestration layer itself. Their talk addressed a persistent problem in distributed systems: workflows frequently fail, recovery mechanisms are complex, and visibility into workflow state remains challenging.
-
PlanetScale Extends Database Platform to PostgreSQL
PlanetScale has announced the general availability of its managed sharded Postgres service, built for performance and reliability on AWS or Google Cloud. The launch extends PlanetScale's offerings to PostgreSQL users, adding to the company's existing popular MySQL-based platform built on top of Vitess.
-
Pinterest Unifies Engineering Tools with New Pinconsole Platform
Pinterest has introduced PinConsole, a unified internal developer platform (IDP) that centralizes engineering workflows. Built to address fragmented tools for deployment, monitoring, and service management, PinConsole provides a consistent layer that lets engineers focus on business logic instead of infrastructure complexity.
-
Instacart Consolidates Search Infrastructure on PostgreSQL, Phasing out Elasticsearch
Instacart has redesigned its search infrastructure by replacing Elasticsearch with PostgreSQL, combining lexical and embedding-based retrieval in a single database engine. The change was driven by the cost and complexity of maintaining separate systems for search and transactional workloads. The company aimed to simplify operations, reduce overhead, and improve precision in search results.
-
Cloudflare Chooses PostgreSQL Extension over Specialized OLAP for 100K Row/Second Analytics
In a recent article from the engineering team behind the Zero Trust product suite, Cloudflare explains why it chose TimescaleDB over ClickHouse to add analytics and reporting capabilities to its internal platform. The author highlights the “phenomenal balance” between the simplicity of storing analytical data alongside configuration data and the performance of a specialized OLAP system.
-
Atlassian's 4 Million PostgreSQL Database Migration: When Standard Cloud Strategies Fail
Atlassian recently migrated 4 million Jira databases to Amazon Aurora, intending to reduce costs and improve the reliability of its Jira Cloud platform. Due to the large number of files involved and the constraints of managed services, the team developed a custom tool to orchestrate the process, as traditional cloud migration strategies were not viable.
-
Amazon Aurora DSQL Goes GA: Distributed, PostgreSQL-Compatible Serverless Database
Amazon has recently announced the general availability of Amazon Aurora DSQL, a PostgreSQL-compatible, serverless, and distributed database. The new managed service is designed to support active-active high availability and multi-region strong consistency.
-
Neon Serverless Postgres Now Generally Available as an Azure Native Integration
Microsoft and Neon launch Neon Serverless Postgres, now generally available as a native Azure integration, offering developers an innovative, scalable, and cost-effective database solution. With automatic scaling, instant provisioning, and seamless integration, it's designed for enterprises and AI startups alike, enhancing workflows and enabling efficient database management within Azure.
-
Google Enhances AlloyDB Vector Search with Inline Filtering and Enterprise Observability
Google enhanced its AlloyDB service with inline filtering and enterprise observability for vector search. This fully-managed PostgreSQL-compatible database now allows direct filtering during queries, offering improved speed and efficiency. Enhanced monitoring features provide deep insights, addressing scaling vector search operations challenges.
-
Google Cloud Launches Gen AI Toolbox for Databases
Google Cloud has announced the public beta launch of Gen AI Toolbox for Databases, an open-source server developed in collaboration with LangChain. This new tool is designed to help developers seamlessly integrate production-grade, agent-based generative AI applications with databases while ensuring secure access, scalability, and observability.
-
Databases in 2024: Growth, Change and Controversy
Andrew Pavlo’s annual retrospective on the database world has recently been released, covering trends and innovations from the past year. The opinionated report, "Databases in 2024: A Year in Review," highlights that while we may indeed be in the "golden era of databases," last year brought significant license changes, the rapid growth of DuckDB, and some surprising new releases.
-
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.