InfoQ Homepage SQL Content on InfoQ
-
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.
-
AWS Introduces Amazon Redshift Serverless
As part of a trend towards serverless analytics options, AWS announced the public preview of Amazon Redshift Serverless. The latest version of the managed data warehouse service targets deployments where it is difficult to manage capacity due to variable workloads or unpredictable spikes.
-
Amazon Aurora Supports MySQL 8.0
A few days before re:Invent 2021, AWS announced the general availability of Aurora MySQL 3 with MySQL 8.0 compatibility. The latest major MySQL version adds features such as common table expressions (CTEs), role-based authentication, invisible indexes and instant DDL previously lacking on Aurora.
-
PlanetScale Introduces Managed Cloud to Scale MySQL Databases
The company behind the open-source Vitess database clustering system recently announced PlanetScale Managed Cloud, an option to run PlanetScale’s databases and management functionalities from existing public cloud accounts.
-
Microsoft Announces the General Availability of Azure Database for MySQL - Flexible Server
Microsoft recently announced the general availability (GA) of the Azure Database for MySQL - Flexible Server.
-
AWS Announces the General Availability and Open Sourcing of Babelfish for PostgreSQL
Recently, AWS announced the general availability (GA) of Babelfish for PostgreSQL. With Babelfish for Aurora PostgreSQL, customers can more easily move applications running on Microsoft SQL Server to Amazon Aurora to simplify operations and reduce costs by eliminating the licenses of SQL Server. Furthermore, the Babelfish open-source project is now available.
-
AWS Announces the Public Preview of AWS Data Exchange for Amazon Redshift
Recently AWS announced the public preview of AWS Data Exchange for Amazon Redshift. This new feature enables customers to find and subscribe to third-party data in AWS Data Exchange to query in an Amazon Redshift data warehouse.
-
How GitHub Partitioned Its Relational Database to Improve Reliability at Scale
GitHub has been working for the last couple of years on partitioning their relational database and moving the data to multiple independent clusters. This effort led to a 50% load reduction and a significant reduction of database-related incidents, explains GitHub engineer Thomas Maurer.
-
Email Classification at Slack: Designing an Eventually Consistent Custom Classifier
Slack recently published the details of how it built an email address classification engine that can determine if an email address is internal or external. Slack engineers utilized an eventually consistent near real-time representation of the data in its system and implemented a drift detection mechanism to fix erroneous data, keeping the engine's operation in order.
-
Oracle Introduces MySQL Autopilot with Machine-Learning Capabilities for MySQL Heatwave
Oracle released updates to its MySQL HeatWave service earlier this month. The new MySQL Autopilot feature uses machine learning to automate database provisioning and optimisation tasks, making recommendations and query optimisations based on each database’s usage patterns.
Streaming SQL on Apache Kafka for Real-Time Processing
Join this webinar to learn how an emerging dialect of SQL can be used for real-time processing on data in Apache Kafka. Discover why businesses are using SQL and Kafka together, the key components of an architecture for streaming SQL, popular use cases for streaming SQL, and more.