Relational Databases

Relational Databases | News, how-tos, features, reviews, and videos

Computerworld's 100 Best Places to Work in IT [2017] - Welcome to the Club
elephant desert tusk ivory postgresql

Circuit board abstract vector background

How vectorization improves database performance

Although a serious engineering challenge, database vectorization delivers orders-of-magnitude performance boosts for a real-time analytics engine such as StarRocks. Here’s how we did it.

mechanic wrench fix engine repair

10 more essential MySQL performance tuning tips

Schema design, indexes, queries, configs, I/O... what could go wrong? Follow these 10 essential tips to keep your MySQL servers humming.

easy simple pixel hand computer pointer

Postgres is eating relational

It’s hard to compete with easy. PostgreSQL has a lot of great qualities, but being easy to use seals the deal for companies and consultants.

dock on lake at sunset

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.

networking abstract

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.

datacenter servers warehouse database

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.

apples oranges slices mixture puzzle balance opposites fruit  savatore gersace flickr

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.

Binary stream passing over rows of monitors, each also displaying binary streams.

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.

A network of linked question marks.

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.

database abstract network innovation

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.

car speedometer

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.

datacenter servers warehouse database

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...

mongodb primary

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.

A lost businessman wanders amid conflicting directional signs through the fog.

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.

the elephant queen

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.

Google Cloud

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.

mismatched shoes

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.

world globe global network nodes programming

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.

Load More