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
Backend Development
Databases
Web Development
SQL
NoSQL
What is the best database for backend web development?
6
Options
Considered
17
User
Recs.
Sep 10, 2023
Last
Updated
Related Questions
Activity
Have feedback or ideas?
Join our community
on Discord
Ad
5
Options
Considered
Best database for backend web development
Price
Technology
Platforms
--
MariaDB
Free
C, C++, Perl, Bash
Windows, Linux, macOS, BSD
--
PostgreSQL
Free / paid
C
Windows, Linux, Mac, BSD
--
Redis
-
-
-
--
MySQL
-
C/C++
-
--
Fauna
-
-
-
See Full List
--
MariaDB
My Rec
ommendation
for
MariaDB
My Recommendation for
MariaDB
All
4
Pros
3
Specs
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
Specs
Technology:
C, C++, Perl, Bash
Platforms:
Windows, Linux, macOS, BSD
Top
Pro
•••
Speed
Although PostgreSQL is the better database, MariaDB is speedier.
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
Free
Recommend
7
--
PostgreSQL
My Rec
ommendation
for
PostgreSQL
My Recommendation for
PostgreSQL
All
7
Experiences
1
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
RickZeeland's Experience
Postgresql is a robust and ACID compliant relational database. The free version is fully functional and offers excellent performance.
See More
Specs
Technology:
C
Platforms:
Windows, Linux, Mac, BSD
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
Hide
See All
Free / paid
Recommend
6
--
Redis
My Rec
ommendation
for
Redis
My Recommendation for
Redis
Hide
Get it
here
Recommend
1
--
MySQL
My Rec
ommendation
for
MySQL
My Recommendation for
MySQL
All
5
Pros
3
Cons
1
Specs
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
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
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
•••
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
1
--
Fauna
My Rec
ommendation
for
Fauna
My Recommendation for
Fauna
Hide
Get it
here
Recommend
1
Don't see your favorite option? Add it.
--
Node JS
My Rec
ommendation
for
Node JS
My Recommendation for
Node JS
Recommend
1
See flagged products
Hide flagged products
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