SQL
SQL | News, how-tos, features, reviews, and videos
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...
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.
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.
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...
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.
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.
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.
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.
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.
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.
PostgreSQL 14 brings performance boosts
Query pipelining, query parallelism, and other optimizations help speed heavy, high-connection, and distributed workloads.
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.
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.
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.
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.
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.
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.