SQL

SQL | News, how-tos, features, reviews, and videos

elephant eye close up lurking menacing postgresql
cloud computing binary rain

Conceptual image of an individual user working with an extruded virtual display.

Google’s Logica language addresses SQL’s flaws

Open source logic programming language compiles to SQL and runs on Google BigQuery, with experimental support for PostgreSQL and SQLite.

speed_digital_car_lights_vehicle_fabio ballasina unsplash

Ahana Cloud for Presto review: Fast SQL queries against data lakes

Ahana Cloud for Presto turns a data lake on Amazon S3 into what is effectively a data warehouse, without moving any data. SQL queries run quickly even when joining multiple heterogeneous data sources.

fire flames

BlazingSQL review: Fast ETL for GPU-based data science

BlazingSQL builds on RAPIDS to distribute SQL query execution across GPU clusters, delivering the ETL for an all-GPU data science workflow.

metal briefcase survival kit

The most important new features in CockroachDB

CockroachDB 20.2 brings a Kubernetes operator, spatial data, a new storage engine, SQL enhancements, and much more, extending the range of workloads for which the database can be used.

bolts of light speeding through the acceleration tunnel 95535268

Solving query optimization in Presto

By combining machine learning and adaptive query execution, query optimization in Presto could become smarter and more efficient over repeated use.

elephant in the room5

The year of PostgreSQL is every year

Completely community-driven, with no centralized ownership, Postgres has been the elephant in the room for more than 30 years

data globe

How MariaDB achieves global scale with Xpand

A new MariaDB storage engine provides distributed SQL and massive scalability with a shared nothing architecture, fully distributed ACID transactions, and strong consistency

bolts of light speeding through the acceleration tunnel 95535268

Why you should use Presto for ad hoc analytics

A federated SQL query execution engine created at Facebook, Presto brings interactive querying to all of your data — no matter where it resides

A signpost with white writing on green background reads Questions and Answers

SQL lessons for NoSQL developers

Because no software developer is complete without at least a passing knowledge of the world’s most popular query language

database data center futuristic technology

Beyond NoSQL: The case for distributed SQL

What if the main problem with relational databases was the back end and not the front end?

devops

Liquibase, formerly Datical, updates database devops tools

Liquibase offers database schema change automation for Oracle and PostgreSQL in free open source and commercially licensed tools

binoculars looking watch outlook future

9 offbeat databases worth a look

Plain old MySQL or MongoDB not doing the job? See if these unique offerings meet your needs

binoculars looking watch outlook future

9 offbeat databases worth a look

Plain old MySQL or MongoDB not doing the job? See if these unique offerings meet your needs

holiday lights neurons network stream

What is Apache Spark? The big data platform that crushed Hadoop

Fast, flexible, and developer-friendly, Apache Spark is the leading platform for large-scale SQL, batch processing, stream processing, and machine learning

gear shift stick shift car automobile 5-speed

CockroachDB review: Distributed SQL shifts into high gear

CockroachDB 19.2.2 impresses with lower latency, higher throughput, greater scalability, and new fully managed CockroachCloud service

gear shift stick shift car automobile 5-speed

CockroachDB review: Distributed SQL shifts into high gear

CockroachDB 19.2.2 impresses with lower latency, higher throughput, greater scalability, and new fully managed CockroachCloud service

abstract data analytics

What is SQL? The lingua franca of data analysis

SQL is neither the fastest nor the most elegant way to talk to databases, but it is the best way we have. Here’s why

sort filter piles  rocks zen

Rockset review: Real-time SQL for operational data

One-of-a-kind database for operational analytics analyzes gigabytes to terabytes of recent, real-time, and streaming data in milliseconds

Load More