ClickHouse Description

ClickHouse is an open-source OLAP database management software that is fast and easy to use. It is column-oriented, and can generate real-time analytical reports by using SQL queries. ClickHouse's performance is superior to comparable column-oriented database management software currently on the market. It processes hundreds of millions of rows to more than a million and tens if not thousands of gigabytes per second. ClickHouse makes use of all hardware available to process every query as quickly as possible. Peak processing speed for a single query is more than 2 Terabytes per Second (after decompression, only utilized columns). To reduce latency, reads in distributed setups are automatically balanced between healthy replicas. ClickHouse supports multimaster asynchronous replication, and can be deployed across multiple datacenters. Each node is equal, which prevents single points of failure.

ClickHouse Alternatives
Google Cloud BigQuery Reviews
Google Cloud BigQuery
(3 Ratings)
ANSI SQL allows you to analyze petabytes worth of data at lightning-fast speeds with no operational overhead. Analytics at scale with 26%-34% less three-year TCO than cloud-based data warehouse alternatives. You can unleash your insights with a trusted platform that is more secure and scales with you. Multi-cloud analytics solutions that allow you to gain insights from all types of data. You can query streaming data in real-time and get the most current information about all your business processes. Machine learning is built-in and allows you to predict business outcomes quickly without having to move data. With just a few clicks, you can securely access and share the analytical insights within your organization. Easy creation of stunning dashboards and reports using popular business intelligence tools right out of the box. BigQuery's strong security, governance, and reliability controls ensure high availability and a 99.9% uptime SLA. Encrypt your data by default and with customer-managed encryption keys
Learn more
RavenDB Reviews
RavenDB
RavenDB is a pioneering NoSQL Document Database. It is fully transactional (ACID across your database and within your cluster). Our open-source distributed database has high availability and high performance, with minimal administration. It is an all-in-one database that is easy to use. This reduces the need to add on tools or support for developers to increase developer productivity and speed up your project's production. In minutes, you can create and secure a data cluster and deploy it in the cloud, on-premise, or in a hybrid environment. RavenDB offers a Database as a Service, which allows you to delegate all database operations to us, so you can concentrate on your application. RavenDB's built-in storage engine Voron can perform at speeds of up to 1,000,000 reads per second and 150,000 write per second on a single node. This allows you to improve your application's performance by using simple commodity hardware.
Learn more
Amazon DynamoDB Reviews
Amazon DynamoDB
(1 Rating)
Amazon DynamoDB, a key-value and document databank, delivers single-digit millisecond performance on any scale. It is a fully managed, multiregional, multimaster, durable database that offers built-in security, backup, restore, and in-memory cache for internet-scale apps. DynamoDB can process more than 10 trillion requests per hour and can handle peak requests of more than 20,000,000 requests per second. Many of the fastest-growing businesses in the world, such as Lyft, Redfin, and Airbnb, as well as enterprises like Samsung, Toyota and Capital One, rely on DynamoDB's scale and performance to support mission-critical workloads.
Learn more
Amazon Redshift Reviews
Amazon Redshift
Amazon Redshift is preferred by more customers than any other cloud data storage. Redshift powers analytic workloads for Fortune 500 companies and startups, as well as everything in between. Redshift has helped Lyft grow from a startup to multi-billion-dollar enterprises. It's easier than any other data warehouse to gain new insights from all of your data. Redshift allows you to query petabytes (or more) of structured and semi-structured information across your operational database, data warehouse, and data lake using standard SQL. Redshift allows you to save your queries to your S3 database using open formats such as Apache Parquet. This allows you to further analyze other analytics services like Amazon EMR and Amazon Athena. Redshift is the fastest cloud data warehouse in the world and it gets faster each year. The new RA3 instances can be used for performance-intensive workloads to achieve up to 3x the performance compared to any cloud data warehouse.
Learn more

Pricing

Free Version:
Yes

Integrations

View Integrations

Reviews - 1 Verified Review

Total
ease
features
design
support
See More Reviews Write a Review

Company Details

Company:
ClickHouse
Year Founded:
2021
Headquarters:
United States
Website:
clickhouse.com

Media

ClickHouse Screenshot 1
ClickHouse Screenshot 1
Recommended Products
Accounting Software for Small Businesses | Xero Icon
Accounting Software for Small Businesses | Xero

Save 90% for 6 months on Xero's award-winning accounting and online bookkeeping platform for businesses of all sizes and stages of growth.

Xero offers a robust ecosystem of connected apps and integrations with banks and financial institutions, enabling small businesses to access a wide range of solutions within Xero's open platform to streamline operations and manage finances. Additionally, accounting and bookkeeping firms benefit from efficient compliance tools, advanced practice management software, and a cloud-based unified accounting ledger for all clients, centralized in one place.
Get 90% off for 6 months

Product Details

Platforms
SaaS
On-Premises

ClickHouse Features and Options

Database Software

Backup and Recovery
Creation / Development
Data Migration
Data Replication
Data Search
Data Security
Database Conversion
Mobile Access
Monitoring
NOSQL
Performance Analysis
Queries
Relational Interface
Virtualization

ClickHouse User Reviews

Write a Review
  • Name: Ramazan P.
    Job Title: Solution Architect
    Length of product use: 2+ Years
    Used How Often?: Weekly
    Role: User, Administrator
    Organization Size: 20,000 or More
    Features
    Design
    Ease
    Pricing
    Support
    Likelihood to Recommend to Others
    1 2 3 4 5 6 7 8 9 10

    Best in class

    Date: Jan 08 2022

    Summary: ClickHouse is my go to database for all my projects. Although it does not support ACID, you can fire a PostgreSQL and create a link to it, then use it like a local database.

    Positive: 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!

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

    Read More...
  • Previous
  • You're on page 1
  • Next