SQL

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

car speedometer
datacenter servers warehouse database

Neon sign > handshake / deal / agreement / partnership / team / merger

Aerospike partners with Starburst to jump on the SQL bandwagon

Aerospike is jumping on the trend for NoSQL database providers to allow users to query data with popular SQL-based business intelligence and analytics tools, to reach a broader customer base.

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.

networking abstract

CockroachDB’s 22.1 update aims to help prototype faster, scale on demand

The latest update from the distributed SQL database is expected to aid enterprise engineering teams to prototype faster, automate more operations, and maintain peak performance during massive transaction spikes across geographies with...

JavaWorld > Persistence [series] > coding / programming / software development

What is JDBC? Introduction to Java Database Connectivity

Get an overview of JDBC's architecture, then learn how to connect to a database and handle SQL queries and responses with PreparedStatements, transactions, connection pooling, and more.

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.

weird science 2017universe

Postgres everywhere

SQLite is embedded everywhere. Will Postgres follow suit?

mainframe servers in the cloud

Beyond SQL: 8 new languages for data querying

SQL has dominated data querying for decades. Newer query languages offer more elegance, simplicity, and flexibility for modern use cases.

architecture / modular structure / grid / matrix / network

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.

connected earth connections

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.

mechanic wrench fix engine repair

Overhauling Apache Kylin for the cloud

Kylin was built to query massive relational tables with sub-second response times. A new, fully distributed query engine steps up performance of both cubing and queries.

elephant eye close up lurking menacing postgresql

PostgreSQL 14 brings performance boosts

Query pipelining, query parallelism, and other optimizations help speed heavy, high-connection, and distributed workloads.

cloud computing binary rain

PlanetScale review: Horizontally scalable MySQL in the cloud

Vitess-powered PlanetScale scales to hold as much data as you need, but is currently limited to a single cluster.

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.

Load More