MYSQL vs POSTGRESQL vs SQL SERVER | LET'S CHOOSE THE BEST DATABASE

hey everyone in this video we'll be taking a look at the three most popular relational databases mysql versus postgresql versus sql server our database developers will share their experience to help you make a wise choice on this channel we share our best practices delivering insights in the tech industry subscribe now not to miss our new videos mysql is a definite leader among sql solutions used by google linkedin amazon netflix and twitter our next competitor is postgresql known for supporting a lot of data types and rich functionality and finally comes sql server unlike postgresql and mysql sql server is a commercial solution let's take a look at their functionality let's start our review by analyzing their defragmentation capabilities it means unifying the updated database by assigning indexes revisiting the structure and creating new pages mysql and sql server offer more of the defragmentation methods that postgresql does they consume less cpu and provide more flexible settings two data queries let's take a look at how the system's cache and process user requests mysql and sql server offer a scalable buffer pool to pull cache postgresql isolates processes by treating them as a separate os process if your priority is to save resources and storage we recommend choosing mysql or sql server if you prefer clear organization postgresql is better three temporary tables they allow storing intermediate results from complex procedures to improve database performance mysql offers limited functionality for temporary tables postgresql and sql server offer a lot more functionality you can divide temporary tables into local and global and configure them with flexible variables if we develop software that runs a lot of complex processes we go for either postgresql or sql server 4. indexes they are used to locate data without searching for a particular row mysql organized indexes in tables and clusters the search isn't highly flexible postgresql offers a flexible search however the early versions don't include automated index updates sql server offers rich automated functionality for index management 5. memory optimized tables such a table is stored in active memory and on the disk space in a simplified way mysql supports the memory stored table but it can't participate in transactions and its security is highly vulnerable actually we also recommend comparing mysql in mongodb we have a guide on the topic check out the description box postgresql doesn't support in-memory database creation sql server uses an optimistic strategy to handle memory optimized tables which means they can participate in transactions along with ordinary tables actually memory optimized tables are best set up in mysql it's basically their native approach we don't think it's an essential database feature but still a good way to improve performance do you agree drop your comment under the video 6. ecosystem mysql is part of the oracle ecosystem it's the biggest sql database on the market with a large open source community you will easily find tools for database management monitoring optimization and learning the postgresql community offers a lot of tools for software scaling and optimization the integrations allow developers to perform clustering integrating ai and cover many other essential features sql server is highly compatible with windows and all microsoft os and tools sql server ecosystem is oriented towards large infrastructures 7. popularity mysql is the most demanded database on the market which means finding competent teams learning resources reusable libraries and ready add-ons will be easy as a conclusion when we prioritize flexibility cost efficiency and innovation we choose open source solutions like mysql or postgresql for enterprise projects we go for sql server for its extensive infrastructure and professional management tools this video was prepared by the jelviks team we provide software development ui ux design and it consulting services need experts help find our contacts in the description box on this channel we share our experience and insights actually we are sharing our surprising experience of using cassandra and mongodb soon so make sure you subscribe not to miss it thank you for watching the video don't forget to like it and hit the bell button you

Channel: Jelvix

Views: 39,627

Rating: 4.5006709 out of 5

Keywords: mysql vs posgresql, sql server vs mysql, my sql vs sql server, my sql vs postgresql, my sql vs postgre sql, mysql, mysql vs postresql vs sql server, mysql vs sql server, posgresql vs sql server, postgresql vs mysql, sql, choose database, sql server, postgresql, podatabasql, sql databases, best database, best sql database, sql comparison, mysql review, postgresql review, sql server review, mysql tutorial, sql server tutorial, postgresql tutorial, sql tutorial

Id: loZ5L_NmCG8

Length: 5min 31sec (331 seconds)

Published: Thu Aug 20 2020

Reddit Comments

[u/Sasha-Jelvix]

In this video, we are taking a look at the three most popular relational databases: MySQL vs PostgreSQL vs SQL server.