Query tools and interfaces

7 articles

General

Amazon Athena

Amazon Athena is AWS's serverless interactive query service for analyzing Amazon S3 data with standard SQL, built on Trino (engine v3, formerly Presto), billed at $5 per TB scanned, with Glue Catalog, federated queries, and Spark support.

General

Arrow Flight SQL

Arrow Flight SQL is Apache Arrow's wire protocol for SQL database access, built on the Arrow columnar format and Flight RPC over gRPC. Introduced 2022, experimental, with JDBC/ODBC/ADBC drivers and multi-stream parallel reads far faster than JDBC.

General

DBeaver

DBeaver is a free, Java-based database tool and SQL client for developers, administrators, and analysts, supporting any database with a JDBC or ODBC driver; a free Community edition and paid PRO editions are available.

General

Java Database Connectivity

Java Database Connectivity (JDBC) is Java's standard, low-level API for communicating with relational databases, included in Java Standard Edition since 1.1 and used by tools like Spring JDBC, JPA, and jOOQ.

General

JDBC driver

A JDBC driver is a vendor-specific Java library implementing the JDBC API, allowing a Java application to connect to and issue commands against a specific database management system.

General

MySQL Workbench

MySQL Workbench is a graphical tool developed by Oracle for working with MySQL servers, providing data modeling, SQL development, server administration, and database migration in a single application.

General

Open Database Connectivity

Open Database Connectivity (ODBC) is a standard API, first released by Microsoft in 1992, that lets one application access many database systems with the same code.