A web client for SQL-like query engines including Hive, Presto, and BigQuery, written in Node.js.
Shib is a web client application for SQL-like query engines, written in Node.js. It provides a unified interface to execute queries on Hive, Facebook Presto, and Google BigQuery, allowing users to switch between engines seamlessly. The project solves the problem of managing multiple query engine clients by offering a single configurable web UI with features like access control, setup queries, and monitoring.
Data engineers, analysts, and developers who work with big data query engines like Hive, Presto, or BigQuery and need a centralized web interface for query execution and management.
Developers choose Shib for its ability to unify access to multiple query engines in one self-hosted web application, reducing tool fragmentation. Its configurable access controls, setup queries, and monitoring integrations provide enterprise-grade features without vendor lock-in.
WebUI for query engines: Hive and Presto
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
Provides a single web interface to execute queries across Hive, Presto, and Google BigQuery, simplifying data exploration across heterogeneous engines, as detailed in the key features and configuration examples.
Offers fine-grained database and table visibility controls per engine with configurable allow/deny rules, enabling secure multi-user environments, as demonstrated in the access control section with JSON examples.
Supports pre-execution queries for UDF registration or configuration, automatable per engine via setup_queries in config.js, enhancing workflow efficiency for custom functions.
Includes RESTful endpoints for programmatic query execution and result fetching (e.g., /execute, /status, /download), facilitating automation and integration, as shown in the HTTP proxy section with curl examples.
Relies on Node.js v0.10.x, which is obsolete and unsupported, and the project has seen minimal updates since 2014 (last version v1.0.2), indicating limited maintenance and security patches.
Requires extensive manual editing of JavaScript config files for each engine, with no GUI or wizard, making setup error-prone and time-consuming, as evidenced by the lengthy configuration examples in the README.
Metadata database incompatibility between versions (e.g., v0.3 to v1.0) forces manual migration operations, adding operational overhead and risk, as specified in the migration section requiring npm run migrate.
Only supports Hive, Presto, and BigQuery, lacking modern engines like Spark SQL or Trino, and the TODO section admits reliance on community patches for expansion.