Introducing
The Slant team built an AI & it’s awesome
Find the best product instantly
Add to Chrome
Add to Edge
Add to Firefox
Add to Opera
Add to Brave
Add to Safari
Try it now
4.7 star rating
0
What is the best alternative to MariaDB?
Ad
Ad
PostgreSQL
All
11
Experiences
Pros
9
Cons
1
Specs
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
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
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
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
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
Multiple node packages available
There are many packages (like Sequelize) that integrate deeply with the features Postgres offers.
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
Open Source, powerful and on par with other paid RDBMS'
It is a powerful, open source product that has all the bells and whistles when compared with its costly, proprietary counterparts.
See More
Specs
Platforms:
Windows, Linux, Mac, BSD
Technology:
C
JSON?:
Yes
Hide
See All
Experiences
Get it
here
352
33
MySQL
All
5
Experiences
Pros
3
Cons
1
Specs
Top
Pro
Scalable
MySQL is made to handle a lot of data and to be used in large applications. This makes it extremely scalable and fast, even under a lot of workload.
See More
Top
Con
Error messages usually are not very detailed
When you are trying to do something in MySQL and something goes wrong it will simply give you an error message with an error code. Which does not say much about what went wrong unless you look it up online. This can be a little cumbersome during development.
See More
Top
Pro
Multiple third-party tools that help working with MySQL
Since MySQL is one of the most popular relational databases, maybe the most popular, there exist many third-party tools and applications that help developers to use MySQL in their development.
See More
Top
Pro
Easy to start working with
Because of it's popularity there are a lot of tutorials and guides out there that help developers install and work with MySQL. The installation process itself is not very hard and there are multiple powerful GUI tools that make it extremely easy to work with MySQL for a beginner.
See More
Specs
Technology:
C/C++
Hide
Get it
here
108
32
SQLite
All
11
Experiences
Pros
8
Cons
2
Specs
Top
Con
No multi user
Lacks multi-user capabilities, see SQLite vs. MySQL vs. PostgreSQL: A Comparison of Relational Databases. Also see: Appropriate Uses For SQLite.
See More
Top
Pro
Small
SQLite is also only 350KiB in size.
See More
Top
Con
Some SQL features are missing
SQLite is made to be extremely lightweight and portable, but it still uses SQL. However, some SQL features such as RIGHT OUTER JOIN and FOR EACH STATEMENT are missing.
See More
Top
Pro
Great language support
SQLite has bindings for a large number of programming languages, including BASIC, Delphi, C, C#, C++, Clipper//Harbour, Common Lisp, Curl, D, Free Pascal, Haskell, Java, JavaScript, Livecode, Lua, newLisp, Objective-C (on OS X and iOS), OCaml, Perl, PHP, Pike, PureBasic, Python, R, REALbasic, REBOL, Ruby, Scheme, Smalltalk, Tcl, Visual Basic.
See More
Top
Pro
Self-contained
SQLite is largely self-contained. It requires very minimal support from external libraries or from the operating system.
See More
Top
Pro
Portable
An SQLite database is a single ordinary disk file that can be located anywhere in the directory hierarchy. It works by sending requests to a single file where all the data is kept instead of communicating with a hosted database which gives access to an interface by making use of sockets and ports. The file format used is also cross-platform, so can easily be migrated to various machines. This makes SQLite extremely portable throughout different applications, all that's needed to transfer the whole database is to make a copy of the file.
See More
Top
Pro
Great for testing and first stages of development 
Because of it's ability to scale and with the portability that a single-file database gives you without losing much of the power and features that SQL gives developers, it's a great choice for testing applications and for the early stages of development when the workload and the data that needs to be stored is not that large.
See More
Top
Pro
Not unnecessarily fiddly
See More
Top
Pro
Reliable
With less complication, there is less to go wrong.
See More
Top
Pro
Zero configuration
There is literally no configuration required to get SQL lite up and running. This is mainly due to SQLite being serverless, there is no separate server process to install, setup, configure, initialize, manage, and troubleshoot.
See More
Specs
Platforms:
Windows, Linux, Mac, Android, IPhone
Technology:
C
Hide
See All
Experiences
Free
185
41
ArangoDB
All
7
Experiences
Pros
6
Specs
Top
Pro
Document and graph-orientend
You can model your data as documents or as a graph - no data model lock-in. You can even combine both models and use them in a single AQL query.
See More
Top
Pro
Supports joins
Unlike many NoSQL databases, ArangoDB does support joins in AQL queries.
See More
Top
Pro
JavaScript-API
You can extend ArangoDB using JavaScript that runs directly on the Server (Google V8). You can build data-centric microservices that aggregate, validate, transform or enrich data (It's up to you, plain JavaScript) and provide those via a custom API route.
See More
Top
Pro
Transaction save
You can use ACID Transactions for short and small data retrieval and/or modification operations in ArangoDB.
See More
Top
Pro
Easy cluster setup
See More
Top
Pro
Powerful Java Driver (Sync & Async)
ArangoDB has a very good Java Driver for synchronous and asynchronous. In addition the team there is working on a Spring Data integration.
See More
Specs
Platforms:
Windows, Linux, Mac
Technology:
C++
Hide
See All
Experiences
Get it
here
36
13
Oracle Database
All
10
Experiences
Pros
7
Cons
3
Top
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.
See More
Top
Con
Proprietary
See More
Top
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.
See More
Top
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.
See More
Top
Pro
Stable
See More
Top
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.
See More
Top
Pro
Secure
See More
Top
Pro
Scalable
See More
Top
Pro
Reduced downtime during upgrades
Oracle Database has parallel upgrading for high available applications. Updates are made in parallel without keeping the database down.
See More
Top
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.
See More
Hide
See All
Experiences
Get it
here
36
13
SQL Server Express
All
7
Experiences
Pros
4
Cons
2
Specs
Top
Con
Proprietary
See More
Top
Pro
Rich developer tools
SQL Server Express has deep integration with Visual Studio, Visual Web Developer and SQL Server Management allowing for ease-of-use and rich table and query designers. It may be the best choice for someone who develops in the Microsoft environment.
See More
Top
Con
Hardware limitations
Maximum number of cores: 4 Maximum memory utilized per instance: 1GB Maximum size: 10GB This hardware could be limiting with some high profile apps and sites.
See More
Top
Pro
Easily manage SQL Server instances
"Manage SQL Server Express databases with SQL Server Management Studio Express. Connect to local SQL Server Express databases and manage objects with full Object Explorer integration. Write, execute, and test queries by using visual query plans, and access management and maintenance options."
See More
Top
Pro
Free
With a variety of versions to choose from the SQL Server Express version is free of charge. It is capable of upgrading to higher tiers, but that requires a fee.
See More
Top
Pro
Easy backup and restore
Can be deployed to all editions of SQL Server and Microsoft Azure SQL Database
See More
Specs
Platforms:
Windows, Linux, Docker
Hide
See All
Experiences
Get it
here
32
12
RethinkDB
All
10
Experiences
Pros
7
Cons
2
Specs
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
Con
Cannot run queries from its CLI
See More
Top
Pro
Changefeeds (change listeners)
You can listen to changes and trigger code based on these changes.
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
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
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
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
Horizontal scalability
RethinkDB is scalable horizontally. It has support for sharding, parallel queries and MVCC concurrency.
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
Specs
Platforms:
Windows, Linux, Mac
Technology:
C++, Python
JSON?:
Yes
Hide
See All
Experiences
Get it
here
120
44
PostgreSQL
All
6
Experiences
Pros
4
Cons
1
Specs
Top
Pro
JSON datatype
JSON data can be stored as a column with optional indexes. 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
Top
Con
pgAdmin 4
The newest version of pgAdmin, written in Python and jQuery with Bootstrap, using the Flask framework, is not an improvement, it's bloated and not very intuitive. Some alternatives can be found here Sadly also in the installers for older versions like PostgreSQL 9.6 the original pgAdmin was replaced by this version.
See More
Top
Pro
Advance access capabilities
Great security and inbuilt access management. Possible to configure row level access.
See More
Top
Pro
Open source license
PostgreSQL is released under the PostgreSQL License, a liberal Open Source license, similar to the BSD or MIT licenses. A mirror of the source code can be found on GitHub
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
Specs
Platforms:
Windows, Linux, Mac, BSD
Technology:
C
Hide
Free / paid
6
0
Redis
All
4
Experiences
Pros
4
Top
Pro
Redis is written in ANSI C and therefore doesn't have a VM
See More
Top
Pro
Good support
Redis has great docs, an active mailing list, and a github community.
See More
Top
Pro
Redis uses the BSD license
This means that it is able to be used in a commercial product if one wants.
See More
Top
Pro
There are numerous client libraries and frameworks to make redis more powerful
For Node.JS for example you can get something similar to what Parse.com was offering by using Node ORM.
See More
Hide
Get it
here
59
20
Built By the Slant team
Find the best product instantly.
4.7 star rating
Add to Chrome
Add to Edge
Add to Firefox
Add to Opera
Add to Brave
Add to Safari
Try it now - it's free
{}
undefined
url next
price drop