InfoQ Homepage Relational Databases Content on InfoQ
-
Amazon Aurora Supports PostgreSQL 13
AWS has recently announced that Amazon Aurora supports major version 13 of PostgreSQL. The compatibility with the latest major PostgreSQL version adds improvements such higher performing partitioned table queries and deduplication of B-tree index entries.
-
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.
-
Microsoft Announces the General Availability of Azure Arc-Enabled SQL
Recently Microsoft announced the general availability as per the end of July of Azure Arc-enabled SQL, which extends the Azure SQL instances to be hosted on an edge data center or in a multi-cloud environment. An Azure Arc enabled SQL Managed Instance has near 100% compatibility with the latest SQL Server database engine.
-
Google Logica Aims to Make SQL Queries More Reusable and Readable
Logica is a Datalog-like declarative logic programming language for database querying. It supports the creation of reusable abstractions to build complex queries and compiles to SQL, thus making it suitable for wide application.
-
Google Bolsters Cloud Spanner with Point-in-Time Recovery
Google recently released a point-in-time-recovery feature for its Cloud Spanner database that aims to help protect against accidental data loss and corruption. The new point-in-time recovery (PITR) features seek to provide users more granular control over data recovery processes.
-
Microsoft Announces Azure Monitor SQL Insights for Azure SQL in Public Preview
Recently Microsoft announced Azure Monitor SQL Insights for Azure SQL in public preview. With the preview, customers will get a flexible canvas for telemetry collection, analysis, and rich custom visualization.
-
Amazon Redshift Data Sharing Now Generally Available
Amazon has recently announced the general availability of the Amazon Redshift Data Sharing functionality to share live data across Amazon Redshift clusters. This allows the use of a single data warehouse cluster for multi-cluster deployments and sharing data instantly without the need to copy or move them.
-
Hazelcast Jet 4.4 Released - the Four-Year Anniversary Release as Seen by Scott McMahon
Hazelcast Jet recently celebrated its four-year anniversary with the release of version 4.4. Besides the normal bug fixes and performance enhancements, this new version ships with new features such as the unified file connector and the first beta version of the SQL interface. InfoQ spoke to Scott McMahon, technical director of field engineering at Hazelcast, about this new release.
-
Cloud Spanner Adds Support for Liquibase
Google Cloud has recently added support for Liquibase on Cloud Spanner. The new extension allows developers to use the open-source database library to manage and automate schema changes for the globally distributed SQL database on Google Cloud.
-
Netflix Embraces GraphQL Microservices for Rapid Application Development
Netflix engineering recently published a blog post detailing how Netflix embraced GraphQL microservices for rapid application development. In this post, Dane Avilla, a senior software engineer at Netflix, describes their key learnings in the process and how GraphQL lends itself well for proof-of-concept development.
-
Designing for Failure in the BBC's Analytics Platform
Last week at InfoQ Live, Blanca Garcia-Gil, principal systems engineer at BBC, gave a session on Evolving Analytics in the Data Platform. During this session, Garcia-Gil focused on how her team prepared and designed for two types of failure - "known unknowns" and "unknown unknowns."
-
AWS Announces Amazon Aurora Supports PostgreSQL 12
AWS has recently announced that Amazon Aurora, a MySQL and PostgreSQL-compatible relational Database built for the Cloud, now supports major version 12 of PostgreSQL.
-
AWS Introduces HealthLake and Redshift ML in Preview
AWS introduced preview releases of Amazon HealthLake service and a feature for Amazon Redshift called Redshift ML during re:Invent 2020 in December. Amazon HealthLake is a data lake service that helps healthcare, health insurance, and pharmaceutical companies to derive value out of their data with the help of NLP. Redshift ML is a service that provides a gateway into SageMaker to Redshift users.
-
PASS to Cease Operations on January 15
PASS, formerly known as the Professional Association for SQL Server, will cease operations on January 15. The non-profit organization, which was known primarily for its conferences, is unable to meet its financial obligations.