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
Development
Open Source
Web
Databases
What are the best open-source relational databases for high performance web applications?
6
Options
Considered
83
User
Recs.
Dec 14, 2021
Last
Updated
Related Questions
Activity
Have feedback or ideas?
Join our community
on Discord
Ad
6
Options
Considered
Best open-source relational databases for high performance web applications
Price
Technology
Platforms
75
PostgreSQL
Free / paid
C
Windows, Linux, Mac, BSD
--
MariaDB
-
C, C++, Perl, Bash
Windows, Linux, macOS, BSD
--
RxDB
0
-
-
--
MySQL
-
C/C++
-
--
Presto
Free
Java
Mac, Linux
See Full List
75
PostgreSQL
My Rec
ommendation
for
PostgreSQL
My Recommendation for
PostgreSQL
All
17
Pros
16
Specs
Top
Pro
•••
Transactional DDL
See More
Specs
Technology:
C
Platforms:
Windows, Linux, Mac, BSD
JSON?:
Yes
Top
Pro
•••
Great support for constraints
PostgreSQL supports the following constraint types: Not-Null Unique Primary Key Foreign Key CHECK
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.
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
•••
Easily extendable
Postgres is highly extendable programmatically through custom procedures that are called "stored procedures". These functions give you the ability to simplify the execution of repeated and/or complex operations.
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
•••
Permissive Open-Source License
PostgreSQL is released under the PostgreSQL License, a liberal Open Source license, similar to the BSD or MIT licenses.
See More
Top
Pro
•••
Many third-party tools are available
Because of it's popularity and regardless of it's extremely powerful features, Postgres has a lot of third-party apps and tools that make it easy to develop and manage applications built with it.
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
•••
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
•••
Actively developed
Regular fixes and features are released
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
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
•••
Supports CTEs
CTE (Common Table Expression), is a feature that lets you define temporary tables that exist just for one query. Think variables, but for sub queries. Very useful for structuring complex queries in a more comprehensible way.
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
•••
Multiple node packages available
There are many packages (like Sequelize) that integrate deeply with the features Postgres offers.
See More
Hide
See All
Free / paid
Recommend
38
9
--
MariaDB
My Rec
ommendation
for
MariaDB
My Recommendation for
MariaDB
All
7
Pros
5
Cons
1
Specs
Top
Con
•••
no clustering support
See More
Top
Pro
•••
Great speed
Mysql has always been faster than Postgres but when the creators of MySQL sold it to Oracle and then continued development on a fork called MariaDB, they surpassed Oracle who didn't maintain MySQL for over a year and improved it well beyond what Oracle currently has done.
See More
Specs
Technology:
C, C++, Perl, Bash
Platforms:
Windows, Linux, macOS, BSD
Top
Pro
•••
Easy replication
See More
Top
Pro
•••
Flexibility
MariaDB/Mysql has enormous flexibility in that it enables you to swap out engines for your needs, it autoincrements and send back key with INSERTS. It takes into consideration alot of basic concerns that may not be ACID compliant but are more in line with day-to-day business logic and modern api development.
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
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
Hide
See All
Get it
here
Recommend
7
6
--
RxDB
My Rec
ommendation
for
RxDB
My Recommendation for
RxDB
All
1
Pros
1
Top
Pro
•••
You can subscribe to queries
You can get an observable from queries instead of manually handling events.
See More
Hide
0
Recommend
7
--
MySQL
My Rec
ommendation
for
MySQL
My Recommendation for
MySQL
All
6
Pros
4
Cons
1
Specs
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
•••
Compatible with a lot of frameworks and languages
See More
Specs
Technology:
C/C++
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
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
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
Hide
See All
Get it
here
Recommend
6
7
--
Presto
My Rec
ommendation
for
Presto
My Recommendation for
Presto
All
2
Pros
1
Specs
Top
Pro
•••
Connectors
Lots of connectors to other databases like PostgreSQL, MySQL, Mongo, SQL Server etc.
See More
Specs
Technology:
Java
Platforms:
Mac, Linux
Hide
Free
Recommend
1
--
Cubrid
My Rec
ommendation
for
Cubrid
My Recommendation for
Cubrid
All
3
Pros
2
Specs
Top
Pro
•••
Sharding support
Database sharding can be used to spread the load on the database.
See More
Specs
Technology:
C
Platforms:
Windows, Linux, Docker
Top
Pro
•••
Fault tolerant
See More
Hide
See All
Free
Recommend
1
1
Don't see your favorite option? Add it.
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
One sec!
Are you sure that you want to abandon your hard work?
Delete Work
Continue working
{}
undefined
url next
price drop