 |
VOOZH | about |
|
VOOZH | about |
The relational data model, which organizes data in tables of rows and columns, predominates in database management tools. Today there are other data models, including NoSQL and NewSQL, but relational database management systems (RDBMSs) remain dominant for storing and managing data worldwide.
This article compares and contrasts three of the most widely implemented open-source RDBMSs: SQLite, MySQL, and PostgreSQL. Specifically, it will explore the data types that each RDBMS uses, their advantages and disadvantages, and situations where they are best optimized.
Thanks for learning with the DigitalOcean Community. Check out our offerings for compute, storage, networking, and managed databases.
This curriculum introduces open-source cloud computing to a general audience along with the skills necessary to deploy applications and websites securely to the cloud.
Browse Series: 39 tutorials
Former Technical Writer at DigitalOcean. Focused on SysAdmin topics including Debian 11, Ubuntu 22.04, Ubuntu 20.04, Databases, SQL and PostgreSQL.
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
nosql comparison link is broken
I question the claim that MySQL is “The most popular and commonly used RDBMS”. It depends on what you mean by “popular and commonly used”, but SQLite is used almost everywhere these days. I honestly don’t know how to do anything on my computer or phone today that doesn’t use SQLite. It’s in iOS and Android, it’s in Firefox and Chrome, it’s in OS X (and used by every OS X application, indirectly, and several of them directly) and Linux. It’s used by Dropbox and Skype and Lightroom and Airbus and pretty much every major software company in the world.
MySQL is very popular for web apps, but SQLite is very popular for basically everything else.
I would like to point out that the JSON and hstore datatypes in PostgreSQL aren’t mentioned, and are extremely useful.
Please rename “Glossary” to “Table of Contents”
There was an interesting poll recently. It appears that Postgres is currently more popular among developers than MySQL http://www.databasefriends.co/2014/03/favorite-relational-database.html
Postgres JSON data type is a huge advantage over MySQL.
The date-time type of MySQL doesn’t store the time zone. In PostrgeSQL, it does.
It seems you forgot the link where it says
Note: To learn more about Database Management Systems, check out our article: Understanding Databases.
Otherwise thanks for the great overview!
I’d love to see this comparison when using a hosted solution like Amazon’s RDS. The reason I say this is that the complexity issues with postgres go away, and I believe you’re left with all of the benefits of postgres, and very few of the downsides.
“understanding databases” link is broken
Full documentation for every DigitalOcean product.
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
