InfoQ Homepage SQL Content on InfoQ
-
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.
-
Google Cloud Spanner Dialect for SQLAlchemy is Generally Available
Google Cloud recently announced the general availability of the Spanner dialect enabling SQLAlchemy applications to run on the distributed SQL database management and storage service.
-
Amazon RDS Introduces Readable Standby Instances in Multi-AZ Deployments
AWS has recently announced readable standby instances in Amazon RDS multi-AZ deployments. The new database cluster option provides high availability and durability for workloads requiring more read capacity and consistent transaction latency.
-
Amazon RDS Custom for SQL Server Is Now Generally Available
Amazon announced the general availability of Amazon RDS Custom for SQL Server. The new service supports legacy, custom, and packaged applications that have dependencies on specific configurations and third-party tools and have historically been unable to move to a fully-managed database.