Relational Databases
Relational Databases | News, how-tos, features, reviews, and videos
Oracle debuts MySQL HeatWave Lakehouse to take on rivals
The new lakehouse service, designed to quickly load and query up to 400TB of data, will compete with offerings from Oracle rivals that have also jumped on the lakehouse concept, including Snowflake, Google, AWS and Microsoft Azure.
PostgreSQL 15 streamlines workload management, improves performance
The new features of the most popular open-source database include improved sort and compression, the MERGE command, and other workload management tools.
Materialize offers early release of its streaming database as a service
The startup's managed, distributed database service is designed to run queries against real-time data in a more cost-efficient manner than batch processing systems.
Oracle MySQL HeatWave comes to AWS
Oracle’s MySQL database service supporting mixed analytical, transaction processing, and machine learning workloads is now available on Amazon Web Services.
Visualizing the Hacker News API with HCL and SQL
Use Steampipe and GitHub Actions to create a ‘dashboard as code’ for exploring thousands of Hacker News stories, right up to the current hour.
Why database design choices matter to developers
Rather than punt database design decisions to a cloud service or third-party provider, understand what you want to achieve and how best to deliver on that goal.
Yugabyte adds Voyager migration service to its 2.15 database update
With the latest update, the company claims it is the first and only distributed SQL database to offer all three PostgreSQL isolation levels.
7 key new features in SingleStoreDB
SingleStoreDB unifies transactions and analytics in the same engine to power real-time, data-intensive applications. Here’s what’s new.
Apache Doris just 'graduated': Why care about this SQL data warehouse
The open source, massively parallel processing (MPP) analytical database will take on the likes of ClickHouse, MariaDB, Apache Druid, Apache Pinot, and hyperscaler services such as Google BigQuery, Amazon RedShift and Microsoft...
How MongoDB's NoSQL database is encroaching on relational database turf
Updates announced at the company’s annual MongoDB World conference this week include new analytics capabilities, a data lake for its Atlas database as a service, and the ability to query encrypted data.
Tired of searching Slack, GitHub, and Google Drive separately? Do it all at once in SQL
When APIs are automatically database tables, it’s easy to combine search results from diverse APIs.
Review: YugabyteDB does PostgreSQL proud
YugabyteDB 2.13 is a highly scalable, distributed version of PostgreSQL that combines compelling ideas from Google Cloud Spanner and Amazon Aurora—and serves as a Cassandra-compatible database too.
Why Google Cloud is battling AWS, Azure, in the red-hot PostgreSQL market
Google Cloud's AlloyDB for PostgreSQL has moved into public preview, and as a Postgres-compatible, fully managed DBaaS (database-as-a-service), will take on offerings from AWS and Microsoft in the hot PostgreSQL market.
Do your AWS deployments match your Terraform definitions? Use SQL to find out.
For belt-and-suspenders security and compliance, use SQL to query your Terraform files in the same way you query your AWS, Azure, or GCP services.
The 9 most important new features in YugabyteDB
YugabyteDB 2.13 brings materialized views, local reads for performance, region-local backups, and much more, extending the geo-distribution capabilities of the database.
JSONB in PostgreSQL today and tomorrow
PostgreSQL was the first relational DBMS to introduce JSON support, and its JSONB index search capability is unique. More is on the way.
What is OLTP? The backbone of ecommerce
Online transaction processing systems are purpose-built to handle large numbers of transactions by large numbers of concurrent users, while guaranteeing the integrity of the data.
How SQL can unify access to APIs
PostgreSQL foreign data wrappers are a great way to expose APIs to SQL. And SQL is a great way to reason over the data.
