InfoQ Homepage SQL Content on InfoQ
-
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.
-
PlanetScale's Challenge to Oracle: Forking MySQL and Introducing Vector Search
PlanetScale recently announced the intention to fork MySQL adding vector search. While PostgreSQL has been the default open-source choice for vector search, the company behind the Vitess database wants to release a version of MySQL and PlanetScale with vector support.
-
Google Improves Cloud Spanner: More Compute and Storage without Price Increase
Google recently announced various improvements to Cloud Spanner, its distributed, decoupled relational database service with a “50% increase in throughput and 2.5 times the storage per node than before” without a price change.
-
Pinterest Revamps Its Asynchronous Computing Platform with Kubernetes and Apache Helix
Pinterest created the next-generation asynchronous computing platform, Pacer, to replace the older solution, Pinlater, which the company outgrew, resulting in scalability and reliability challenges. The new architecture leverages Kubernetes for scheduling job-execution workers and Apache Helix for cluster management.
-
MySQL Changes Versioning Model, Adds Innovation and LTS Releases
Oracle recently announced a change in the versioning model for MySQL, introducing the MySQL Innovation and Long-Term Supported releases. The first innovation release is MySQL 8.1.0 , which includes InnoDB cluster read replicas.
-
Visual Studio 2022 17.7 Preview 3 with Productivity Updates
Microsoft has released the third preview of Visual Studio 2022 version 17.7. Preview 3 brings a range of improvements and features aimed at enhancing developer productivity and helping maintain clean code. Preview 3 is focused on a new tool called # includes cleanup for C++ developers. The latest version is already available for download.
-
Google Releases Cloud SQL Enterprise Plus for MySQL and PostgreSQL
Google Cloud recently announced the Cloud SQL Enterprise Plus edition for MySQL and PostgreSQL of the managed database service. The new edition provides performance optimizations for read and write operations, improved machine types and configurations, and an integrated SSD–backed data cache option.
-
Distributed PostgreSQL Benchmarks: Azure Cosmos DB, CockroachDB, and YugabyteDB
Microsoft recently discussed the results of distributed PostgreSQL benchmarks, comparing transaction processing and price performance for Azure Cosmos DB for PostgreSQL, CockroachDB, and Yugabyte. With different implementation trade-offs, the results show a higher throughput for Azure Cosmos DB but highlight the challenges of benchmarking distributed databases.
-
How LinkedIn Serves over 4.8 Million Member Profiles per Second
LinkedIn introduced Couchbase as a centralized caching tier for scaling member profile reads to handle increasing traffic that has outgrown their existing database cluster. The new solution achieved over 99% hit rate, helped reduce tail latencies by more than 60% and costs by 10% annually.
-
Meta Switches to MySQL Raft to Improve Reliability and Operational Simplicity
Meta is rolling out MySQL Raft in its data centers to replace its current MySQL semisynchronous databases. The new consensus engine helps operation and allows MySQL servers to take responsibility for promotions and membership.
-
AWS Introduces Athena Provisioned Capacity
AWS recently announced a new feature Provisioned Capacity for Athena, that allows users to run SQL queries on fully-managed compute capacity for a fixed price and no long-term commitments.
-
Google Cloud Spanner Introduces Configurable Read-Only Replicas and Zero-Downtime Move Service
Google recently announced new regional and multi-regional capabilities for Cloud Spanner. The distributed SQL database now supports configurable read-only replicas and introduced a "zero-downtime" instance move service.
-
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.