One of the hardest parts in building architecture for your project is to choose the DB.
The most important criteria are: Community Support, Performance, Replication, Supported Data Types, Indexes, Security etc.
In today's post I want to add few links with comparing two most popular relational databases - MySQL and PostgreSQL:
hackr: https://hackr.io/blog/postgresql-vs-mysql
guru99: https://www.guru99.com/postgresql-vs-mysql-difference.html
fivetran: https://www.fivetran.com/blog/postgresql-vs-mysql
Official sites with documentations:
MySQL
PostgreSQL
For more useful info - subscribe Tech Read channel.
Likes and shares are welcome.
#database #mysql #postgresql
The most important criteria are: Community Support, Performance, Replication, Supported Data Types, Indexes, Security etc.
In today's post I want to add few links with comparing two most popular relational databases - MySQL and PostgreSQL:
hackr: https://hackr.io/blog/postgresql-vs-mysql
guru99: https://www.guru99.com/postgresql-vs-mysql-difference.html
fivetran: https://www.fivetran.com/blog/postgresql-vs-mysql
Official sites with documentations:
MySQL
PostgreSQL
For more useful info - subscribe Tech Read channel.
Likes and shares are welcome.
#database #mysql #postgresql
Hackr.io
PostgreSQL vs MySQL | Which RDBMS Is Best? (2024)
PostgreSQL vs MySQL, which RDBMS is best in 2024? Check out our head-to-head, inc. key features, differences, similarities, real-world use cases, and more.
Indexes are the essential part of most of the databases. These data structures are used to optimize the performance of database queries. But duplicate, redundant, and unused indexes can dramatically reduce performance.
In the article Duplicate, Redundant, and Invisible Indexes by Percona you’ll find small tips about finding such indexes in MySQL and I hope reduce the time of some queries.
For more useful info - subscribe to Tech Read channel.
Likes, shares and recommendations are welcome.
#databases #mysql #indexes
In the article Duplicate, Redundant, and Invisible Indexes by Percona you’ll find small tips about finding such indexes in MySQL and I hope reduce the time of some queries.
For more useful info - subscribe to Tech Read channel.
Likes, shares and recommendations are welcome.
#databases #mysql #indexes
Percona Database Performance Blog
How to Find Duplicate, Unused, and Invisible Indexes in MySQL
This tutorial shows you how to find and remove duplicate, invisible, and unused indexes in MySQL so you can improve the performance of your mySQL database.