MySQL vs PostgreSQL?


Warning: count(): Parameter must be an array or an object that implements Countable in /home/styllloz/public_html/qa-theme/donut-theme/qa-donut-layer.php on line 274
0 like 0 dislike
14 views
Briefly about the project:
sampling of a large number of conditions
— a lot of inserts
— high load
— no room for error

MySQL or PostgreSQL?
A comprehensive solution?
Other options?
NoSQL?
by | 14 views

7 Answers

0 like 0 dislike
By Far The Postresql. From mysql after the appearance in the ninth version of the replication out of the box was gone plus the latest mysql.
\r
Postgra much more advanced database, to list its capabilities is endless, and here are a couple of things that are very, very helpful.
— Indexes on expression
— Partial indexes
— Non-blocking index updates
— Super fast removing and adding columns in tables of any size
— The experience many times less of deadlocks under heavy loads
— Multiple types of indexes
— The number of types is huge, plus user-defined types
— More precisely meets ANSI standard is much stricter and applies to the input data
cheques, rules, Treherne functions
— Full-text search module (muscular only for myisam and nervously smokes on the sidelines)!
— Transactional ddl!
— Ability to write procedures in almost any language, a powerful internal language PL/pgSQL (in the muscle squalor with a bunch of restrictions)
— Runs much better on multicore systems
— Advanced optimizer
\r
and much more more.
by
0 like 0 dislike
image
by
0 like 0 dislike
by
0 like 0 dislike
The AdWords system was initially implemented on top of the MySQL database engine. After the system had been launched, management decided to use a commercial database (Oracle) instead. The system became much slower, so eventually it was returned to MySQL [3]
by
0 like 0 dislike
according to libastral, today I will respond to noSQL, but tomorrow everything can change.
\r
Describe the problem and should not make us refer to this library.
by
0 like 0 dislike
PostreSQL is an object — relational database.
MySQL is a relational database.
\r
View than it threatens you.
\r
The basic syntax of the queries odinokoi. Therefore we can establish two bases and test.
\r
Also note that MySQL can be used in different type of tables (MyISAM, InnoDB etc.)
I personally worked with both databases, PostreSQL seemed to me more convenient in terms of implementation logic of the return data at the database.
by
0 like 0 dislike
Each database has its own +
and it is only necessary to use them properly.
\r
there is a bike that Google is working on mascula, Facebook and also many more who are not complaining.
\r
also there are plenty of examples when a site with 1000 visitors could not cope on mosque, but with pogresan flew.
\r
so I am for the smart use of any tool, be it hammer the hammer to have assumed that their next project will do and dunno on django and they do not care one database to another jump not far away
by
110,608 questions
257,186 answers
0 comments
27,942 users