InfoQ Homepage Postgres Content on InfoQ
-
Expedia Uses WebSockets and Kafka to Query Near Real-Time Streaming Data
Expedia created a solution to support querying the clickstream data from their platform in near-real time to enable their product and engineering teams to explore live data while working on new and enhancing existing data-driven functional use cases. The team used a combination of WebSockets, Apache Kafka, and PostgreSQL to allow streaming query results continuously to users’ browsers.
-
Automated Horizontal Scaling with Amazon Aurora Limitless Database
AWS recently announced the preview of Amazon Aurora Limitless Database, a new capability supporting automated horizontal scaling to process millions of write transactions per second and manage petabytes of data in a single Aurora database.
-
OCI Database: Oracle Embraces PostgreSQL
Oracle has recently announced the general availability of OCI Database with PostgreSQL version 14.9. With the first managed PostgreSQL service available on Oracle Cloud, all cloud providers now offer a PostgreSQL-compatible managed option.
-
Git-for-Data, Version-Controlled Database Dolt Gets PostgreSQL-Flavor
DoltgreSQL builds on top of the version-controlled database Dolt to provide Git-like log, diff, branch, and merge functionality for your Postgres database schema and data.
-
Google AlloyDB Omni: PostgreSQL-Compatible Database for On-Premises and VMware Cloud Foundation
Google Cloud recently announced the general availability of AlloyDB Omni, a downloadable version of the PostgreSQL-compatible database service AlloyDB. The new version is designed to run on-premises, has built-in support for generative AI, and will be available on VMware Cloud Foundation.
-
Timescale Introduces Dynamic PostgreSQL, an Alternative to Serverless Databases
Timescale recently introduced Dynamic PostgreSQL, a new cloud-managed option to scale the database capacity within a predefined vCPU range. Promoted as “buy the base and rent the peak”, the new option scales the capacity according to the load, trying to address the unpredictability and variability of serverless options.
-
Goldsky’s Streaming-First Architecture for Blockchain Data with Flink, Redpanda and Kubernetes
Goldsky created a platform for the real-time processing of blockchain data. The platform allows clients to extract data from blockchains into their own databases to support product features, but without running the data pipeline infrastructure. The event-driven architecture (EDA) of Goldsky leverages Apache Flink, Redpanda, Kubernetes, and cloud provider services.
-
Amazon RDS for PostgreSQL Now Supports pgactive for Active-Active Replication
AWS recently announced the general availability of pgactive on RDS for PostgreSQL. The replication extension for PostgreSQL supports asynchronous active-active replication for streaming data between database instances, enhancing resiliency and flexibility.
-
Cloudflare Hyperdrive: Access PostgreSQL Databases Globally
During the recent "Birthday Week 2023", Cloudflare announced the open beta of Hyperdrive, a new service that uses Cloudflare global network to speed up queries to existing databases. The service currently supports PostgreSQL-compatible databases, with support for MySQL expected soon.
-
High Performance Functions in Rust on RDS PostgreSQL
AWS announced the general availability of the Rust procedural language handler, PL/Rust, for Amazon Relational Database Service (RDS) instances running versions 13 and 14 of PostgreSQL. This builds on the previous release in May 2023 that enabled the functionality only for instances running PostgreSQL version 15.
-
Google Cloud Unveils AlloyDB AI: Transforming PostgreSQL with Advanced Vector Embeddings and AI
During the recent Google Cloud Next, Google announced AlloyDB AI in preview as an integral part of AlloyDB for PostgreSQL, allowing developers to build generative (gen) Artificial Intelligence (AI) applications leveraging large language models (LLMs) with their real-time operational data through built-in, end-to-end support for vector embeddings.
-
Inside InfluxDB 3.0: Exploring InfluxDB’s Scalable and Decoupled Architecture
InfluxData recently unveiled the system architecture for InfluxDB 3.0, its newest time-series DB. Its architecture encompasses four major components responsible for data ingestion, querying, compaction, and garbage collection and includes two main storage types. The architecture caters to operating the DB on-premise and natively on major cloud providers.
-
Amazon Aurora PostgreSQL Adds pgvector to Support Embeddings from Generative AI
AWS recently announced that the PostgreSQL-compatible edition of Amazon Aurora now supports pgvector for vector storage and similarity search. Aurora is the latest managed PostgreSQL database supporting the open-source extension to store and search embeddings from machine learning models.
-
Google Releases Cloud SQL Enterprise Plus for MySQL and PostgreSQL
Google Cloud recently announced the Cloud SQL Enterprise Plus edition for MySQL and PostgreSQL of the managed database service. The new edition provides performance optimizations for read and write operations, improved machine types and configurations, and an integrated SSD–backed data cache option.
-
Enhancing AI Capabilities: Google Cloud Integrates Vector Search in Managed Databases
Google Cloud recently added support for the pgvector on Cloud SQL for PostgreSQL and AlloyDB for PostgreSQL. The extension brings vector search operations to the managed databases, allowing developers to store vector embeddings generated by large language models (LLMs) and perform similarity searches.