InfoQ Homepage SQL Content on InfoQ
-
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.
-
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.
-
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.
-
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.
-
Google Cloud Spanner Introduces Free Trial Instances and Fine-Grained Access Control
Google Cloud recently announced different improvements to their managed databases. The cloud provider introduced free trial instances and fine-grained access control for Spanner to let developers try the managed service and configure access to data at the table and column level.
-
Oracle Announces General Availability of MySQL Heatwave on AWS
Oracle recently announced the general availability (GA) of MySQL Heatwave, a service that combines OLTP, analytics, machine learning, and machine learning-based automation within a single instance on AWS.
-
Accelerated Multi-Account Auditing and Compliance in AWS with Steampipe, HCL and SQL
AWS recently examined the use of AWS Insights Mod, based on Steampipe, an open-source tool that defines over 650 queries and displays their results on 84 dashboards.
-
A New Microsoft Platform in Town: the Microsoft Intelligent Data Platform
Recently Microsoft introduced a new platform called the Microsoft Intelligent Data Platform that fully integrates their database, analytics, and governance offerings. The new platform encompasses everything already available in the Azure Data space (Azure Data Factory, Azure Data Explorer, etc.) to the Synapse Analytics products, Power BI, and the newly rebranded Purview data governance service.
-
Cloudflare D1 Provides Distributed SQLite for Cloudflare Workers
Soon to enter beta, D1 is Cloudflare's first step into the Cloud-based SQL storage arena. D1 is built on top of SQLite with the addition of a distributed replication mechanism, batch operation support, embedded compute, automatic backups and redundancy, and more.
-
Infrastructure as SQL on AWS: IaSQL is Now Open Source and SaaS
IaSQL, the company behind a service that models AWS infrastructure using SQL, has recently announced that IaSQL is available as open source and software as a service.
-
AWS Releases the Second Version of Amazon Aurora Serverless with Independent Scaling
Recently, AWS announced the general availability of the second version of Amazon Aurora Serverless, an on-demand, auto-scaling configuration for Amazon Aurora. The second version is generally available for both Aurora PostgreSQL and MySQL, featuring the independent scaling of compute and storage.
-
Improve Access Control of Google Cloud SQL with IAM Conditions and Tags
Recently, Google announced the general availability (GA) of IAM Conditions and Tags for Cloud SQL, a fully-managed relational database service for MySQL, PostgreSQL, and SQL Server.
SPONSORED BY
Live Webinar presented by Redpanda |
Q&A moderated by InfoQ
Design Patterns for Distributed Streaming Data Environments
Explore widely used patterns in distributed streaming data environments for several use cases such as high availability, disaster recovery, hybrid integration, and cloud migration. We will discuss each pattern while using Redpanda as a reference and highlighting its architecture and capabilities.