Add to Chrome
Add to Edge
Add to Firefox
Add to Opera
Add to Brave
Add to SafariWhen comparing RethinkDB vs Oracle Database, the Slant community recommends RethinkDB for most people. In the question“What are the best databases to use for Node.js applications?” RethinkDB is ranked 2nd while Oracle Database is ranked 15th. The most important reason people chose RethinkDB is:
Only takes about 30 seconds to install. They also have a docker file for running it on AWS, Google Cloud or your own.
Specs
Question Ranking
Pros
Pro Easy install
Only takes about 30 seconds to install. They also have a docker file for running it on AWS, Google Cloud or your own.
Pro Changefeeds (change listeners)
You can listen to changes and trigger code based on these changes.
Pro Powerful query language
RethinkDB's ReQL is a very powerful functional query language. The functional aspects of ReQL and the straightforward implementation of the Node driver for Rethinkdb make it a natural fit for Javascript developers. You no longer have to type some obscure syntax in quotes (aka SQL), your queries are just "natural" Javascript functions in the same way you would use lodash to handle your collections.
Pro Auto master promotion
Unlike a lot of other databases where if the master is down the system is down, this one if the master is down someone else is made master so much more peer to peer.
Pro CLI and web administration tools
RethinkDB has administration tools in both CLI and GUI (web app). You can view whats going on right away by going to localhost:8080. The data explorer allows you to run queries on the db.
Pro Horizontal scalability
RethinkDB is scalable horizontally. It has support for sharding, parallel queries and MVCC concurrency.
Pro Ease of cluster setup
You can directly tell it to shard/replicate and how many shards/replicas depending on the amount of nodes. Each node doesn't need anything except one other node's ip/port in the cluster to join and maybe the auth.
Pro World wide technical support
Oracle is a large company with specialists in a lot of countries. It's very easy to find consultants and any kind of help with Oracle.
Pro Useful features for daily workflow
Some of the most important features are the partitioning option, active data guard, and security options. All of these are very useful for daily workflow.
Pro Stable
Pro Secure
Pro Scalable
Pro Reduced downtime during upgrades
Oracle Database has parallel upgrading for high available applications. Updates are made in parallel without keeping the database down.
Pro High performance parallel quesries
Oracle Database has introduced concurrent execution of union branches, which means that one set of parallel servers will execute one branch, a second set will execute another branch and so on. Instead of the old system where each branch executed one after the other.
Cons
Con Cannot run queries from its CLI
Con No user accounts
This is just the database, you need to setup your own auth and user accounts (such as using Auth0).
Con Proprietary
Con Terrible company reputation
Oracle is very (in)famous for being involved in a number of controversies. Some of them have ended up in lawsuits with other tech companies because of license disputes. The latest one is a lawsuit against Google for Google's implementation of JAVA in their Android ecosystem.
Con Ghost data
To work around ghost data you can after encrypting something, manually move everything out of the old table space and then shred those data files. To be able to get rid of ghost data automatically would be great.
