Need advice about which tool to choose?Ask the StackShare community!
RethinkDB vs Vertica: What are the differences?
What is RethinkDB? JSON. Scales to multiple machines with very little effort. Open source. RethinkDB is built to store JSON documents, and scale to multiple machines with very little effort. It has a pleasant query language that supports really useful queries like table joins and group by, and is easy to setup and learn.
What is Vertica? Engineering experiences that amaze. Vertica provides a best-in-class, unified analytics platform that will forever be independent from underlying infrastructure.
RethinkDB and Vertica can be primarily classified as "Databases" tools.
Some of the features offered by RethinkDB are:
- JSON data model and immediate consistency.
- Distributed joins, subqueries, aggregation, atomic updates.
- Secondary, compound, and arbitrarily computed indexes.
On the other hand, Vertica provides the following key features:
- Analyze All of Your Data. No longer move data or settle for siloed views
- Achieve Scale and Performance
- Fear of growing data volumes and users is a thing of the past
RethinkDB is an open source tool with 22.5K GitHub stars and 1.75K GitHub forks. Here's a link to RethinkDB's open source repository on GitHub.
According to the StackShare community, RethinkDB has a broader approval, being mentioned in 53 company stacks & 166 developers stacks; compared to Vertica, which is listed in 3 company stacks and 3 developer stacks.
Pros of RethinkDB
- Powerful query language48
- Excellent dashboard46
- JSON42
- Distributed database41
- Open source38
- Reactive25
- Atomic updates16
- Joins15
- MVCC concurrency9
- Hadoop-style map/reduce9
- Geospatial support4
- Real-time, open-source, scalable4
- YC Company2
- A NoSQL DB with joins2
- Great Admin UI2
- Changefeeds: no polling needed to get updates2
- Fast, easily scalable, great customer support2
Pros of Vertica
- Shared nothing or shared everything architecture3
- Reduce costs as reduced hardware is required1
- Offers users the freedom to choose deployment mode1
- Flexible architecture suits nearly any project1
- End-to-End ML Workflow Support1
- All You Need for IoT, Clickstream or Geospatial1
- Freedom from Underlying Storage1
- Pre-Aggregation for Cubes (LAPS)1
- Automatic Data Marts (Flatten Tables)1
- Near-Real-Time Analytics in pure Column Store1
- Fully automated Database Designer tool1
- Query-Optimized Storage1
- Vertica is the only product which offers partition prun1
- Partition pruning and predicate push down on Parquet1