InfoQ Homepage Relational Databases Content on InfoQ
-
Integrating Azure Database for MySQL - Flexible Server with Power Platform and Logic Apps
Microsoft recently announced a new set of integrations with Azure Database for MySQL – Flexible Server and the Microsoft Power Platform and Azure- making it easier to develop solutions for analyzing data, automating processes, and building apps. These new integrations include PowerBI, Logic Apps, PowerApps, and Power Automate.
-
Microsoft Claims SQL Server Performs Better on Azure Than AWS
In a recent benchmark, Microsoft claims that SQL Server on Azure Virtual Machines can be up to 57% faster and cost up to 54% less than running a similar workload on AWS EC2.
-
Infrastructure as SQL on AWS: IaSQL Enters Beta Adding Multi-Region and Transactions
The open-source service IaSQL recently announced its beta release. Designed to manage cloud infrastructure using SQL, IaSQL introduced support for AWS multi-region, new AWS services, and infrastructure changes as transactions.
-
Microsoft Announces the Preview of Serverless for Hyperscale in Azure SQL Database
Recently, Microsoft announced the preview of serverless for Hyperscale in the Azure SQL Database, which brings together the benefits of serverless and Hyperscale into a single database solution.
-
Optimized Reads and Optimized Writes Improve Amazon RDS Performances for MySQL Compatible Engines
AWS recently introduced RDS Optimized Reads and RDS Optimized Writes, which are designed to enhance the performance of MySQL and MariaDB workloads running on RDS. These new functionalities can improve query performances and provide higher write throughput but are available on a limited subset of instances and have multiple prerequisites.
-
GCP Adds Simplified Operator for Connecting Google Kubernetes Engine to Cloud SQL
Google Cloud has released a public preview of Cloud SQL Proxy Operator. The operator simplifies the process of connecting an application running in Google Kubernetes Engine with a database deployed in Cloud SQL.
-
Entity Framework 7 Brings Bulk Operations and JSON Columns
Version 7 of Entity Framework (EF) Core, Microsoft's object-to-database mapper library for .NET Framework, was released in November. The updated version brings performance updates when saving data, allows JSON column operations, enables efficient bulk operations, and contains many minor fixes and improvements. The EF7 Core is available for both .NET 7 and .NET 6.
-
PostgreSQL-Compatible AlloyDB Now Generally Available on Google Cloud
Recently Google announced the general availability (GA) of AlloyDB for PostgreSQL, a fully-managed, PostgreSQL-compatible database service providing scale-out compute and storage, integrated analytics, and AI/ML-powered management.
-
Recap of AWS re:Invent 2022
After a virtual-only event in 2020 and a reduced-size 2021 edition, re:Invent was back last week in Las Vegas with over 50,000 attendees for the 11th edition. During multiple sessions and keynotes at the largest AWS yearly conference, the cloud provider announced new services and features, with the focus more on business solutions and data options than new building blocks.
-
AWS Announces Blue/Green Deployments for MySQL on Aurora and RDS
At the beginning of the re:Invent conference, AWS announced the general availability of RDS Blue/Green Deployments, a new feature for Aurora with MySQL compatibility, RDS for MySQL, and RDS for MariaDB to perform blue/green database updates.
-
Azure SQL Trigger for Azure Functions in Public Preview
Azure recently announced the public preview of Azure SQL trigger for Azure Functions to build event-driven applications. The new functionality is currently available only for C# functions and can be triggered by changes to an Azure SQL table.
-
New Features for Azure Database for PostgreSQL Flexible Server
New features for Azure Database for PostgreSQL Flexible Server are in preview. These new features include encryption of data at rest with customer-managed keys, database authentication with Azure Active Directory, geo-redundant backups and fast restores of data, and a migration tool for moving workloads from the product’s older Single Server deployment option.
-
Interactive Query Service Amazon Athena Introduces New Engine
AWS recently announced version 3 of the engine for Amazon Athena, the serverless interactive service to query S3 data using standard SQL. The cloud provider claims that the new engine improves performance and supports new use cases thanks to over 50 new SQL functions and 30 new analytics features.
-
Microsoft Introduces Azure Cosmos DB for PostgreSQL
During the recent Ignite conference, Microsoft announced Azure Cosmos DB for PostgreSQL, a new generally available (GA) service to build cloud-native relational applications. It is a distributed relational database offering with the scale, flexibility, and performance of Azure Cosmos DB.
-
Grab Shared Its Experience in Designing Distributed Data Platform
GrabApp is an application that customers select and buy their daily needs from merchants. To be scalable and manageable the data platform and ingestion should be designed as a distributed, fault-tolerant. To design this data platform two classes of data stores are considered: OLTP and OLAP.