InfoQ Homepage Relational Databases Content on InfoQ
-
MySQL Introduces Javascript Support in Preview
Oracle recently announced that the MySQL database server now supports JavaScript functions and procedures. JavaScript for stored routines is currently in preview and only available in the MySQL Enterprise Edition and MySQL Heatwave.
-
Amazon Aurora Introduces Long-Awaited RDS Data API to Simplify Serverless Workloads
Recently, AWS introduced a new Data API for Aurora Serverless v2 and Aurora provisioned database instances. Currently available for PostgreSQL clusters only, the Data API doesn't require persistent connections to a database cluster, addressing a long-awaited need among developers to simplify serverless deployments.
-
Zendesk Moves from DynamoDB to MySQL and S3 to Save over 80% in Costs
Zendesk reduced its data storage costs by over 80% by migrating from DynamoDB to a tiered storage solution using MySQL and S3. The company considered different storage technologies and decided to combine the relational database and the object store to strike a balance between querybility and scalability while keeping the costs down.
-
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.
-
Amazon RDS Now Supports IBM Db2
During the recent re:Invent conference, AWS announced that Amazon RDS now offers support for IBM Db2, including both the Standard Edition and Advanced Edition. Db2 becomes the sixth engine supported by this managed database service, joining PostgreSQL, MySQL, MariaDB, SQL Server, and Oracle.
-
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.
-
Recap of AWS re:Invent 2023: Amazon Q, Frugal Architectures, Database Upgrades
The 12th edition of re:Invent has just ended in Las Vegas. As expected, artificial intelligence was a key topic of the conference, with Amazon Bedrock and Amazon Q, a new type of generative AI-powered assistant, the main focus of Adam Selipsky’s keynote.
-
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.
-
Elastic Jobs in Azure SQL: Microsoft Entra ID, Secure Connectivity and Scalability Updates
Azure SQL Database Elastic Jobs preview faces a refresh, introducing customer-requested features and additions including Microsoft Entra ID support, Service-managed Private Link for secure connections, Azure Alerts integration for job status monitoring, and enhanced scalability of Job Agent's tier.
-
MySQL 8.2 Introduces Transparent Read/Write Splitting
Oracle has recently announced the general availability of MySQL 8.2, which includes support for Read/Write Splitting. This long-awaited feature has been introduced in the latest innovation release and helps optimize database performance and scalability.
-
Visual Studio 2022 17.8 Preview 3: Structured Diagnostics, SQL Server Data Tools Upgrade and More
Microsoft released Visual Studio 2022 17.8 Preview 3. This version is focused mainly on addressing community feedback and resolved almost 100 tickets. Additionally, there are some new features: an “Update on Close” option, Unreal Engine macro specifier suggestions, structured diagnostics, and an upgrade in SQL Server Data Tools.
-
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.