ClickHouse

ClickHouse

5.0 out of 5 stars
WinSQL

WinSQL

Synametrics Technologies
+
+

Related Products

  • Google Cloud BigQuery
    4.5 out of 5 stars 2,027 Ratings
    Visit Website for Google Cloud BigQuery
  • DbVisualizer
    4.8 out of 5 stars 593 Ratings
    Visit Website for DbVisualizer
  • Google Cloud SQL
    4.5 out of 5 stars 554 Ratings
    Visit Website for Google Cloud SQL
  • RaimaDB
    4.8 out of 5 stars 12 Ratings
    Visit Website for RaimaDB
  • Couchbase
    4.4 out of 5 stars 417 Ratings
    Visit Website for Couchbase
  • BidJS
    4.5 out of 5 stars 37 Ratings
    Visit Website for BidJS
  • Crelate
    4.5 out of 5 stars 699 Ratings
    Visit Website for Crelate
  • Muzaic
    5.0 out of 5 stars 2 Ratings
    Visit Website for Muzaic
  • ClickLearn
    4.4 out of 5 stars 67 Ratings
    Visit Website for ClickLearn
  • Arryved
    4.7 out of 5 stars 46 Ratings
    Visit Website for Arryved

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

WinSQL is a powerful universal database management tool that is used by 90 percent of Fortune 500 companies and more than a million programmers and DBAs around the globe. WinSQL is a generic querying tool that connects to any relational database (RDBMS) for which an Open Database Connectivity (ODBC) driver is available, virtually all RDBMS on the market today. Connect to a variety of databases, including: heavy duty vendors Oracle, MS SQL Server, DB2, Sybase, Informix to lightweight backends like MS Access, DBase, and Text File. Generate royalty-free executables that can be used by your business users to run queries. These can be either static or dynamic queries that pull fresh data from the back-end. Export or simply open any query results into MS Excel with just a click of your mouse. You can even import an existing Excel spreadsheet to a database table by simply dragging an *.XSL file in the catalog tree.

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 Supported
Mac Not Supported
Linux Not Supported
Cloud Not Supported
On-Premises Not Supported
iPhone Not Supported
iPad Not Supported
Android Not Supported
Chromebook Not Supported

Audience

Companies of all sizes

Audience

Database administrators (DBAs) and programmers

Support

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

Support

Phone Support Supported
24/7 Live Support Not Supported
Online 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

$99.00/year/user
Lite : Free Standard : $99 Professional : $249
Free Version Supported
Free Trial 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 Supported
Live Online Not Supported
In Person Supported

Company Information

ClickHouse
Founded: 2021
United States
clickhouse.com

Company Information

Synametrics Technologies
Founded: 2002
United States
web.synametrics.com/winsql.htm

Alternatives

Alternatives

RazorSQL

RazorSQL

1.0 out of 5 stars
DBeaver Community

DBeaver Community

DBeaver Corp.
5.0 out of 5 stars
DbVisualizer

DbVisualizer

4.8 out of 5 stars
CelerData Cloud

CelerData Cloud

CelerData

Categories

Categories

Database Features

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

Integrations

Acryl Data Supported
Airtool Supported
Apache Superset Supported
BI Book Supported
CelerData Cloud Supported
DbVisualizer Supported
Embeddable Supported
FastReport Mono Supported
Galaxy Supported
Gravity Data Supported
Hosted Graphite Supported
Kestra Supported
Langflow Supported
Mongrel Supported
NudgeBee Supported
PeerDB Supported
Prometheus Supported
SQL Supported
SayData Supported
VisuaLeaf Supported

Integrations

Acryl Data Not Supported
Airtool Not Supported
Apache Superset Not Supported
BI Book Not Supported
CelerData Cloud Not Supported
DbVisualizer Not Supported
Embeddable Not Supported
FastReport Mono Not Supported
Galaxy Not Supported
Gravity Data Not Supported
Hosted Graphite Not Supported
Kestra Not Supported
Langflow Not Supported
Mongrel Not Supported
NudgeBee Not Supported
PeerDB Not Supported
Prometheus Not Supported
SQL Not Supported
SayData Not Supported
VisuaLeaf Not Supported
Claim ClickHouse and update features and information
Claim ClickHouse and update features and information
Claim WinSQL and update features and information
Claim WinSQL and update features and information