What are the easiest database engines to scale?

Question

3

Options
Considered

0

User
Recs.

Feb 25, 2017

Last
Updated

Here’s the Deal

3 Options Considered

What are the easiest database engines to scale	Price	Platforms	JSON?
-- PostgreSQL	-	Windows, Linux, Mac, BSD	Yes
-- RethinkDB	-	-	-
-- MariaDB	-	-	-

See Full List

I Recommend...

Help millions of people make better decisions.

Each month, over 2.8 million people use Slant to find the best products and share their knowledge. Pick the tags you’re passionate about to get a personalized feed and begin contributing your knowledge.

Answer 1

PostgreSQL

Top Pro

Fully ACID compliant

PostgreSQL is known to have a very holistic approach to robustness and data integrity which is reflected by it being fully ACID compliant. PostgreSQL has always been strict about making sure data is valid before allowing it into the database, and there is no way for a client to bypass those checks. Depending on your requirements, ACID compliance might be important. See More

Top Con

Not suited for small apps

Because of it's complexity and power, it may be an overkill to use PostgreSQL in small applications that will not make use of it's full power. See More

Specs

Platforms:Windows, Linux, Mac, BSD

JSON?:Yes

Top Pro

Multiple node packages available

There are many packages (like Sequelize) that integrate deeply with the features Postgres offers. See More

Top Pro

High performance

PostgreSQL performance increases with each release, this is also proven by many benchmark tests. Notable performance features include: As PostgreSQL only supports one storage engine, it has been able to integrate and optimise it and with the rest of the database. This has resulted in multiple benefits such as the ability to allow different transaction types to co-exist efficiently without the need to select storage engine types once for each table ahead of time. On the fly data compression resulting in less IO required for reading. Asynchronous + synchronous Replication. PostgreSQL supports a asynchronous API for use by client applications. It is reported to increase performance by up to 40% and is not supported by MySQL. Designed to scale very well with large numbers of cores at high concurrency levels. See More

Top Pro

Support Perl and Python for coding stored procedures

Postgres supports popular languages for coding stored procedures, such as Perl and Python. So, you can fairly easy transform just DB-server to reliable Service with complex business logic. See More

Top Pro

Actively developed

Regular fixes and features are released See More

Top Pro

Support for geographic objects

PostgreSQL can be extended to have geographic object support through PostGIS and allows for location queries to be run through SQL. See More

Top Pro

Strong community

PostgreSQL has a strong community backing it, with guides, tutorials and support for any kind of problem a developer may have. See More

Top Pro

Support for JSON data type

JSON data can be stored as a column with optional indexes. In 9.4 (upcoming at the time of this writing), JSONB will be a binary version of JSON that will save space. It's like the best of the NO-SQL world without having to give up ACID and Relationships. This means that cascading deletes can be done in a single Transaction across multiple JSON documents. See More

See All

Answer 2

RethinkDB

Top Pro

Horizontal scalability

RethinkDB is scalable horizontally. It has support for sharding, parallel queries and MVCC concurrency. See More

Top Con

No user accounts

This is just the database, you need to setup your own auth and user accounts (such as using Auth0). See More

Top 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. See More

Top 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. See More

Top 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. See More

Top Pro

Changefeeds (change listeners)

You can listen to changes and trigger code based on these changes. See More

Top 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. See More

Top 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. See More

See All

Answer 3

MariaDB

Top Pro

More cutting edge features

e.g. GIS since 5.3 See More

Top Pro

Truly open development community

All development decisions for MariaDB can be reviewed and debated on a public mailing list or in the public bug tracker. Contributing to MariaDB is easy and the patch flow is fully transparent and public. But it's not all about the code contribution either - MariaDB also has very active documentation efforts and other related things that help developers in their day-to-day database administration. See More

Top Pro

Dynamic column support

MariaDB has dynamic column support which allows for some NoSQL type functionality. So one database interface can provide both SQL and NoSQL for different software development needs. See More

See All

What are the easiest database engines to scale?

3 Options Considered

PostgreSQL

My Recommendation for PostgreSQL

My Recommendation for PostgreSQL

Fully ACID compliant

Not suited for small apps

Multiple node packages available

High performance

Support Perl and Python for coding stored procedures

Actively developed

Support for geographic objects

Strong community

Support for JSON data type

RethinkDB

My Recommendation for RethinkDB

My Recommendation for RethinkDB

Horizontal scalability

No user accounts

CLI and web administration tools

Auto master promotion

Powerful query language

Changefeeds (change listeners)

Easy install

Ease of cluster setup

MariaDB

My Recommendation for MariaDB

My Recommendation for MariaDB

More cutting edge features

Truly open development community

Dynamic column support

Don't see your favorite option? Add it.

One sec!