Presto

Presto

Presto Foundation
+
+

Related Products

  • Google Cloud BigQuery
    2,027 Ratings
    Visit Website
  • DbVisualizer
    593 Ratings
    Visit Website
  • Google Cloud SQL
    554 Ratings
    Visit Website
  • Couchbase
    417 Ratings
    Visit Website
  • RaimaDB
    12 Ratings
    Visit Website
  • BidJS
    37 Ratings
    Visit Website
  • Crelate
    699 Ratings
    Visit Website
  • Muzaic
    2 Ratings
    Visit Website
  • ClickLearn
    67 Ratings
    Visit Website
  • Arryved
    46 Ratings
    Visit Website

About

ClickHouse is a fast open-source OLAP database management system. It is column-oriented and allows to generate analytical reports using SQL queries in real-time. ClickHouse's performance exceeds comparable column-oriented database management systems currently available on the market. It processes hundreds of millions to more than a billion rows and tens of gigabytes of data per single server per second. ClickHouse uses all available hardware to its full potential to process each query as fast as possible. Peak processing performance for a single query stands at more than 2 terabytes per second (after decompression, only used columns). In distributed setup reads are automatically balanced among healthy replicas to avoid increasing latency. ClickHouse supports multi-master asynchronous replication and can be deployed across multiple datacenters. All nodes are equal, which allows avoiding having single points of failure.

About

Presto is an open source distributed SQL query engine for running interactive analytic queries against data sources of all sizes ranging from gigabytes to petabytes. For data engineers who struggle with managing multiple query languages and interfaces to siloed databases and storage, Presto is the fast and reliable engine that provides one simple ANSI SQL interface for all your data analytics and your open lakehouse. Different engines for different workloads means you will have to re-platform down the road. With Presto, you get 1 familar ANSI SQL language and 1 engine for your data analytics so you don't need to graduate to another lakehouse engine. Presto can be used for interactive and batch workloads, small and large amounts of data, and scales from a few to thousands of users. Presto gives you one simple ANSI SQL interface for all of your data in various siloed data systems, helping you join your data ecosystem together.

Platforms Supported

Windows Not Supported
Mac Not Supported
Linux Not Supported
Cloud Supported
On-Premises Supported
iPhone Not Supported
iPad Not Supported
Android Not Supported
Chromebook Not Supported

Platforms Supported

Windows Not Supported
Mac Not Supported
Linux Not Supported
Cloud Supported
On-Premises Not Supported
iPhone Not Supported
iPad Not Supported
Android Not Supported
Chromebook Not Supported

Audience

Companies of all sizes

Audience

All types of businesses and organizations in need of a powerful Database Virtualization solution

Support

Phone Support Not Supported
24/7 Live Support Not Supported
Online Not Supported

Support

Phone Support Not Supported
24/7 Live Support Not Supported
Online Not Supported

API

Offers API Not Supported

API

Offers API Not Supported

Screenshots and Videos

Screenshots and Videos

Pricing

No information available.
Free Version Supported
Free Trial Not Supported

Pricing

Free, open-source software
Free Version Not Supported
Free Trial Not Supported

Reviews/Ratings

Overall 5.0 / 5
ease 3.0 / 5
features 4.0 / 5
design 5.0 / 5
support 5.0 / 5

Reviews/Ratings

Overall 0.0 / 5
ease 0.0 / 5
features 0.0 / 5
design 0.0 / 5
support 0.0 / 5

This software hasn't been reviewed yet. Be the first to provide a review:

Review this Software

Pros & Cons from Real Users

Pros

  • ClickHouse is really really fast. I can say that it is THE fastest I've came across. It has lots of native integration options S3, Kafka, SQLite, PostgreSQL and so on. Its SQL capabilities are top notch. And it is 100% free!

Cons

  • - Updates and deletes are eventual. - Hard to setup a cluster. - Does not have ACID.

Training

Documentation Not Supported
Webinars Not Supported
Live Online Not Supported
In Person Not Supported

Training

Documentation Supported
Webinars Not Supported
Live Online Not Supported
In Person Not Supported

Company Information

ClickHouse
Founded: 2021
United States
clickhouse.com

Company Information

Presto Foundation
Founded: 2019
United States
prestodb.io

Alternatives

Alternatives

Denodo

Denodo

Denodo Technologies
Apache Drill

Apache Drill

The Apache Software Foundation
CelerData Cloud

CelerData Cloud

CelerData

Categories

Categories

Relational Database Features

ACID Compliance Supported
Data Failure Recovery Supported
Multi-Platform Supported
Referential Integrity Supported
SQL DDL Support Supported
SQL DML Support Supported
System Catalog Supported
Unicode Support Supported

Integrations

Acryl Data Supported
Apache Superset Supported
AtomicJar Supported
Embeddable Supported
GrowthBook Supported
IBM watsonx.data Supported
Metabase Supported
PopSQL Supported
Preset Supported
SQL Supported
Zing Data Supported
rakam Supported
Airtool Supported
DataGrip Supported
Enrich.sh Supported
ILLA Cloud Supported
Kamatera Supported
Matik Not Supported
MindsDB Supported
Sequel Supported

Integrations

Acryl Data Supported
Apache Superset Supported
AtomicJar Supported
Embeddable Supported
GrowthBook Supported
IBM watsonx.data Supported
Metabase Supported
PopSQL Supported
Preset Supported
SQL Supported
Zing Data Supported
rakam Supported
Airtool Not Supported
DataGrip Not Supported
Enrich.sh Not Supported
ILLA Cloud Not Supported
Kamatera Not Supported
Matik Supported
MindsDB Not Supported
Sequel Not Supported
Claim ClickHouse and update features and information
Claim ClickHouse and update features and information
Claim Presto and update features and information
Claim Presto and update features and information