Using IRIS and Presto for high-performance and scalable SQL queries

This page summarizes the projects mentioned and recommended in the original post on dev.to

InfluxDB high-performance time series database
Collect, organize, and act on massive volumes of high-resolution data to power real-time intelligent systems.
influxdata.com
featured
CodeRabbit: AI Code Reviews for Developers
Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.
coderabbit.ai
featured
  1. presto-iris

    Presto InterSystems IRIS Connector

    # Official PrestoDB image on Docker Hub FROM prestodb/presto # From https://github.com/caretdev/presto-iris/releases # Adding presto-iris plugin into the Docker image ADD https://github.com/caretdev/presto-iris/releases/download/0.1/presto-iris-0.1-plugin.tar.gz /tmp/presto-iris/presto-iris-0.1-plugin.tar.gz # From https://github.com/intersystems-community/iris-driver-distribution # Adding IRIS JDBC driver into the Docker image ADD https://raw.githubusercontent.com/intersystems-community/iris-driver-distribution/refs/heads/main/JDBC/JDK18/com/intersystems/intersystems-jdbc/3.8.4/intersystems-jdbc-3.8.4.jar /opt/presto-server/plugin/iris/intersystems-jdbc-3.8.4.jar RUN --mount=type=bind,src=.,dst=/tmp/presto-iris \ tar -zxvf /tmp/presto-iris/presto-iris-0.1-plugin.tar.gz -C /opt/presto-server/plugin/iris/ --strip-components=1

  2. InfluxDB

    InfluxDB high-performance time series database. Collect, organize, and act on massive volumes of high-resolution data to power real-time intelligent systems.

    InfluxDB logo
  3. iris-driver-distribution

    JDBC and other drivers distribution repo

    # Official PrestoDB image on Docker Hub FROM prestodb/presto # From https://github.com/caretdev/presto-iris/releases # Adding presto-iris plugin into the Docker image ADD https://github.com/caretdev/presto-iris/releases/download/0.1/presto-iris-0.1-plugin.tar.gz /tmp/presto-iris/presto-iris-0.1-plugin.tar.gz # From https://github.com/intersystems-community/iris-driver-distribution # Adding IRIS JDBC driver into the Docker image ADD https://raw.githubusercontent.com/intersystems-community/iris-driver-distribution/refs/heads/main/JDBC/JDK18/com/intersystems/intersystems-jdbc/3.8.4/intersystems-jdbc-3.8.4.jar /opt/presto-server/plugin/iris/intersystems-jdbc-3.8.4.jar RUN --mount=type=bind,src=.,dst=/tmp/presto-iris \ tar -zxvf /tmp/presto-iris/presto-iris-0.1-plugin.tar.gz -C /opt/presto-server/plugin/iris/ --strip-components=1

  4. superset

    Apache Superset is a Data Visualization and Data Exploration Platform

  5. Presto

    The official home of the Presto distributed SQL query engine for big data

    The rise of Big Data projects, real-time self-service analytics, online query services, and social networks, among others, have enabled scenarios for massive and high-performance data queries. In response to this challenge, MPP (massively parallel processing database) technology was created, and it quickly established itself. Among the open-source MPP options, Presto (https://prestodb.io/) is the best-known option. It originated in Facebook and was utilized for data analytics, but later became open-sourced. However, since Teradata has joined the Presto community, it offers support now.

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts

  • how to get into data eng pt.2

    2 projects | /r/dataengineering | 25 Apr 2021
  • Hive: An Open-Source Data Warehouse Built on Apache Hadoop

    1 project | news.ycombinator.com | 13 Aug 2024
  • Trino: A fast distributed SQL query engine for big data analytics

    1 project | news.ycombinator.com | 9 Jul 2024
  • Trino & Iceberg Made Easy: A Ready-to-Use Playground

    3 projects | dev.to | 19 May 2024
  • Trino: Fast distributed SQL query engine for big data analytics

    1 project | news.ycombinator.com | 19 Mar 2024

Did you know that Java is
the 8th most popular programming language
based on number of references?