Mysql

MySQL is a free, open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL)

Postgresql

PostgreSQL is an open-source, object-relational database management system (ORDBMS) available for all major platforms including Linux, UNIX, Windows and OS X



Reserved word forgiving

Example

"Postgresql uses the reserved word serial as a part of the ddl in that process;mysql doesn t"

from question  

Converting Postgresql table into Mysql table

"It seems mysql is more forgiving with this than postgresql but in every case you use a reserved word you should escape it"

from question  

Exception(AbstractPostgreSQLDriver->convertException) in Doctrine is for insertion of data in postgresql (Using symfony)

Query stricter sql

Example

"Postgresql is a more mature database postgresql has a longer history postgresql is more ansi sql compliant postgresql query optimizer is significantly better;mysql has different storage engines like myisam innodb in-memory all of them are incompatible in a sense that an sql query which runs on one engine may produce a syntax error when executed on another engine"

from question  

Postgres 9.1 vs Mysql 5.6 InnoDB?

"But in mysql it is ok and in postgresql it is wrong and ask for the other fields besides site_id either in a group by clause or in a aggregation function i know that postgresql is stricter on sql than mysql so i must select the site_id in the query object of msg_published but in pure sqlalchemy i can do like this"

from question  

How to let flask-sqlalchemy's query object select columns ( or say fields )?

"I am aware that postgresql interpretation of the sql standard is stricter than mysql and that consequently this type of query won t work...and have read a number of posts on stackoverflow and elsewhere on the subject - but none of them seem to be the definitive answer on this subject"

from question  

Elegant PostgreSQL Group by for Ruby on Rails / ActiveRecord

Easier replication worse

Example

"Mysql is easier than postgresql but it doesn t really matter either way"

from question  

Recommended Django setup?

"Postgresql is also free;mysql is easier to learn due to it s friendly sql not standard compliance"

from question  

Why is MySQL used so often in web development?

"Postgresql specifically has gotten easier to manage while mysql has lost some of the simplicity that gave it an advantage without picking up enough features that really matter"

from question  

Increase JOIN Query response time by combining tables

"About replication mysql has had a replication solution much earlier than postgresql"

from question  

PostgreSQL indexes and replication techniques

"Mysql is more widely supported and a little easier to use but postgresql has some very cool features and functionality that s worth taking a gander at"

from question  

Design of the recommendation engine database?

"Does this affect postgresql harder than mysql"

from question  

Autocommit in Flask-SQLAlchemy

"I just checked the timings using mysql 5 and mysql 5 are slightly worse than postgresql"

from question  

Why are SQL aggregate functions so much slower than Python and Java (or Poor Man's OLAP)

"You might look at postgresql as i find it a bit easier to manage and maintain as i feel some aspects are more logical than mysql"

from question  

Which should I use for working with a large amount of data, MySQL or SQLite?

"Mysql postgresql tends to be easier to use and you ll find a ton of libraries uis etc to help you get started mysql postgresql offer real transactions mvcc - casssandra has lightweight transactions limited to operations on a single key with much weaker isolation atomicity guarantees"

from question  

Ecommerce/Shopping Cart (and checkout process) : use Relational or NoSQL

"Mysql mariadb is slightly worse than postgresql"

from question  

Which JDBC drivers support scroll sensitive/insensitive properly?

"However people often argue that postgresql is cleaner and easier to use that mysql"

from question  

Ideal Rails Server

"Mysql has some advantages like easy replication but postgresql is generally nicer to work with"

from question  

Can you provide some advice on setting up my database?

Robust mature complicated

Example

"Postgresql is a bit more restrictive than mysql"

from question  

PostgreSQL, Rails and :order => problem

"If you are using postgresql you can do the following;mysql is more complicated since is lacks a distinct on clause"

from question  

Django queryset get max id's for a filter

"Explain in postgresql is way more useful than in mysql"

from question  

Are the consistency/data loss/query optimization issues I read about "that bad"?

"And do investigate postgresql its geospatial features are more mature than mysql s"

from question  

Labeling data by travel time to a point

"I feel postgresql is much more mature and robust than mysql"

from question  

Why does Heroku use Postgresql?

"There is also postgresql its a bit more robust than mysql and is free just the same"

from question  

Software design problem

"I hear postgresql is more robust and doesn t crash like mysql does in these situations"

from question  

Order by RAND( ) on a HUGE table causes it to crash in MySQL. Why?

"Postgresql will always be a little bit more mature than mysql"

from question  

Erlang: Mnesia or Mysql?

"Postgresql is much more mature for this;if your app has lots of stored procs this pretty much rules out mysql"

from question  

Stored Procedures: Which is more similar to SQL Server 2000 - Postgresql or MySQL

"Mysql is very popular;postgresql i think has lot more features personal preference"

from question  

Setting up a Ruby development environment

"Mysql is not less complicated that postgresql -- they re the same thing"

from question  

The best solution for distribution website?

Serious web popular

Example

"Although many short articles on the web comparing mysql and postgresql generally tend to claim that postgresql is technically more advanced acid json support etc.. these two problems seem to be serious drawback to me"

from question  

PostgreSQL indexes and replication techniques

"While postgresql is less popular than mysql most of the serious web hosting supports it"

from question  

Python/Django and HTML/CSS/JS/jQuery on PostgreSQL/Apache?

"Postgresql supports some more security features than mysql for example integration with gssapi or kerberos for logins last i checked mysql didn t have these"

from question  

PgSQL or mySQL is more secure?

"While mysql is more famous for serious enterprise-quality database where preserving your data is critical i recommend postgresql"

from question  

Save timestamps in database

"Though mysql is more popular than postgresql but instagram is using postgresql maybe due to these reasons"

from question  

Why does Heroku use Postgresql?

"It s a shame postgresql isn t more popular than mysql since it supports exactly this feature out-of-the-box you d only have to share one sequence object between tables."

from question  

Sharing auto_increment `id` and table relations

"I suggest postgresql it s more capable has more features and better support for complex queries and datatypes than mysql and has a lot of tuning options"

from question  

In memory relational database

" one last thing to say mysql is a little bit easier to start than postgresql;postgresql is a little bit more complex because postgresql has more features"

from question  

* (no title is found for this review)

"However postgresql s sql features are far more advanced than mysql s and mysql has a tendency to silently ignore things you tell it to do - especially in a default installation and if you rely on a foreign key to be created that might be a very unpleasant surprise"

from question  

PostgreSQL or mySQL best for daily log website?

Better data database

Example

"Honestly though postgresql scales much better than mysql"

from question  

MySQL or SQL Server better for an Enterprise application?

"I was told that postgresql is a better choice than mysql for displaying hierarchical data so i installed postgresql and i m ready to go"

from question  

Count descendants in hierarchical query

"And a wiki for why postgresql is better than mysql"

from question  

Why does django community encourage the use of Postgres over Mysql?

"Generally speaking i find postgresql lends itself to 24 7 operations better than mysql"

from question  

Why does Heroku use Postgresql?

"Postgresql has better support but the support by mysql depends on the used storage engine"

from question  

PostgreSQL or mySQL best for daily log website?

"I found that postgresql 9.3 has better capabilities for json than the mysql versions i am using"

from question  

Storing heterogeneous json objects in same MySQL table?

"I d also recommend postgresql over mysql if you are going to have nested comments as postgresql does hierarchical querying better than mysql"

from question  

Comments as normal nodes in database

"With correct locking for safety reasons and heavy concurrent use postgresql performed better than mysql"

from question  

Migrating from MySQL to PostgreSQL

"An efficiently configured mysql is better than a badly configured postgresql and vice-versa"

from question  

High Frequency Database to use with ruby

"What i am hearing from our group leader is that postgresql is better than mysql when working with coordinates"

from question  

How is PostgreSQL different from MySQL?

"In my cases postgresql was better than mysql mysql do not completely support unicode"

from question  

Which database and language is better at handling Unicode?

"Postgresql is better than mysql in many ways"

from question  

Why does Heroku use Postgresql?

"Postgresql with the optional hstore module might be better than mysql at this."

from question  

How to properly query a normalized database

"Some people were saying that postgresql is better for security purposes whereas mysql is becoming more feature rich."

from question  

What is the best DBMS for the job?

"I would need a scalable database so probably postgresql would be better than mysql"

from question  

Set up a dedicated rails production server

"Then postgresql is much better than mysql"

from question  

MySQL or PostgreSQL for Hibernate + JPA2 project

"Is postgresql better than mysql for such purpose"

from question  

Database design for heavy timed data logging

"There are workloads where postgresql is better and there are workloads where mysql is better"

from question  

PostgreSQL or mySQL best for daily log website?

"Also you might take the time to compare postgresql and see if there is something about it that meets your needs as well or better than mysql"

from question  

Right DBMS for the job?

"Postgresql seem to better than mysql in terms of speed"

from question  

Set up Django DiscoverRunner to always recreate database on testing with radish

"The other question is that what i am hearing from our group leader is that postgresql is better than mysql when working with coordinates"

from question  

How is PostgreSQL different from MySQL?

"If you need spatial data capabilities postgis with postgresql is better than mysql"

from question  

Comparing Database Platforms

"I just recently switched databases to postgresql which has given me a slew of problems although i must admit i like it a lot better than mysql"

from question  

Rails Console not loading? y (Errno::ENOENT)

"I also personally believe that postgresql has better handling of complex queries that include sub-selects and the like which most mysql users used to avoid"

from question  

Migrating MySQL to PostgreSQL - what features not visible in SQL code will be important?

"Postgresql is way better than mysql in nearly every respect"

from question  

Set up a dedicated rails production server

"I really like postgresql s indexes which are far better than mysql s;postgresql is generally much better in features"

from question  

* (no title is found for this review)

"I m not familiar with mysql spatial i use postgresql with postgis"

from question  

Why is my spatial index slow?

"And postgresql does a lot of things better than mysql"

from question  

Database table with million of rows

"I personally prefer postgresql over mysql and find postgresql over mysql very scalable even with millions or even billions of rows when setup correctly"

from question  

NoSQL and meteorological data

"In your case postgresql may be a better option than mysql because your query is going to likely be against secondary indexes"

from question  

Proper database design for Big Data

"Is postgresql a better option than mysql for partitioning tables by date"

from question  

Rails 3: Would PostgreSQL be a better fit than MySQL for partitioning tables?

"Now i m not sure if i d say postgresql is generally better than mysql -- there are certainly things that mysql does much better and so it certainly has its uses -- but these are a few things i absolutely love about it"

from question  

When to choose Oracle over MySQL?

"Postgresql has better foreign key support better referential integrity transactions views subselects etc;but that doesn t mean mysql doesn t have its place"

from question  

What makes PostgreSQL more advanced than MySQL?

"On top of that postgresql gives better performance with ef than mysql"

from question  

Converting Entity to DTO along with child entities

"The only reason i was considering postgresql was that some research suggested postgresql has much better support for changing schemas along the way than mysql"

from question  

If using South, does it even matter what the underlying database is?

"Whoever tells you postgresql is not fast enough for writing does not know it;whoever tells you that mysql is not scalable enough does not know it facebook runs on mysql"

from question  

Database choice for stock data

"You should put the data somewhere else amazon rds with mysql postgresql whatever you like and then make sure the lambda is connected to the same vpc amazon internal router with the rds database"

from question  

Deploying Flask sqlalchemy apps in AWS lambda and API gateway

"I am using postgresql btw which can do more than mysql incase that changes things"

from question  

How to get distinct values in one column with multiple possible values in the other?

"Postgresql requires more tuning than mysql to achieve optimal performance"

from question  

Why is PostgreSQL so slow on Windows?

"Postgresql also supports nested tables see for example and a number of array-related features;mysql does not support nested tables but there s a set data type to consider"

from question  

Which DBMSs allow for nested relations and references?

"Postgresql gets much better performance and this is coming from a former mysql partisan"

from question  

Framework/Language for new web 2.0 sites (2008 and 2009)

"In other words is mysql better or worse than postgresql to handle unicode etc"

from question  

Which database and language is better at handling Unicode?

"Ps you can also migrate to postgresql it s smarter than mysql when choosing right indexes"

from question  

Mysql select - improve performances

"Sql support - postgresql is much better for complex sql-queries for example with lots of joins and aggregates;mysql s stored procedures didn t feel very mature"

from question  

How many of you have gone from MySQL to Postgresql? Was it worth it?

"Mongodb is fun to toy with and i ve built a few apps using mongodb myself for that reason but mongodb s almost never a better choice than postgresql mysql sql server etc"

from question  

MongoDB and PostgreSQL thoughts

"Either postgresql more proven than mysql for such huge data"

from question  

Best db for delphi and large databases

"Postgresql is also a lot better imo than mysql and is the recommended database to use with django according to a lot of the people close to django"

from question  

Django, phpmyadmin and mysql?

"My opinion is that mysql is more of a programmers dbms;whereas postgresql and others like it are database administrator s dbms"

from question  

* (no title is found for this review)

"Postgresql is much better suited for data warehousing compared to mysql"

from question  

Postgresql for OLAP

"Some say mysql is much better for bigger projects while others think just go with postgresql"

from question  

Sqlite3 vs Postgres vs Mysql - Rails

"So i ended up using a relational database anyway since only there i could use compound keys without any hacks . i performed a benchmark to compare sqlite with postgresql and mysql - 500 000 inserts of 60 kb blobs and then 50 000 selects by the whole key"

from question  

Storing and accessing a large number of relatively small files

"There are applications where maintaining the necessary data integrity using an external database sqlite mysql postgresql makes more sense"

from question  

How to access a class instance reference name?

"Also not sure which of mysql 5.7 and postgresql v11 is better for this kind of use case - this question arises as this use-case is primary and we can choose between either of the databases"

from question  

* (no title is found for this review)

"In my experience postgresql is a more solid database and performs better with many simultaneous users especially when writing to the database although harder to learn its more strict;mysql is easier to learn and may be sufficient depending on the total number of request traffic"

from question  

Records come one by one very slowly and incomplete

"After creating the above file i ran pgloader database_data.load command to load the data in tech_login_development_mysql database there is a log table is my project whose created_at and updated_at fields in the newly created postgresql database is not same as mysql database"

from question  

While migrating data in rails from mysql to postgres using pgloader the created_at and updated_at fields for each table are not consistent

Better databases reputation

Example

"If you want to use sql i strongly reccommend postgresql it seems to deal with large databases and frequent writes a lot better than mysql"

from question  

Setup for high volume of database writing

"Given postgresql s reputation for doing things better than mysql or at least as good as i daresay that postgresql would demonstrate similar performance if properly used"

from question  

Is it better to filter a resultset using a WHERE clause or using application code?

"In mysql you connect to all databases not just one at a time;postgres postgresql is much more standards compliant but postgres postgresql s uglier and more complicated especially from a ui perspective"

from question  

Choosing the right database: MySQL vs. Everything else

"For most platforms postgresql s just as easy to install as mysql but postgresql is a better database and postgresql s especially an improvement on mysql when postgresql comes to handling large amounts of data which you are doing"

from question  

MySQL v. SQLite for Python based financial web app

"When i rewrite left join by subquery it took only 111ms attached plans while googling i have found this blog post in most cases joins are also a better solution than subqueries postgresql will even internally rewrite a subquery creating a join whenever possible but this of course increases the time it takes to come up with the query plan many so question like this a left outer join can be faster than an equivalent subquery because the server might be able to optimize it better a fact that is not specific to mysql server alone"

from question  

JOIN vs SubQuery: Why subquery performance win when it should not?

"From what i read where postgresql does better than mysql multi-application databases advanced data modelling what advance data modelling means is that postgresql is far more mature at doing complex data modelling than mysql is"

from question  

AWS RDS MySql or Postgres - performance wise and cost wise?

"And postgresql has fewer experienced administrators than the big databases and mysql which i believe contributes to the reputation"

from question  

Why is PostgreSQL Harder to Manage/Maintain then other Databases

"Anyways mysql is bad and on longterm especially if you are enough good for java i suggest you to use some better db with postgresql you were really satisfied i think"

from question  

Order By Before Group By in JPA Spring Repository

"I think this issue is more common with postgresql databases than mysql databases because with postgresql there is more likely to be lagging connections this is a postgresql issue rather than gcp issue"

from question  

Unknown INTERNAL_ERROR trying to remove Google Cloud SQL postgres database

"Postgresql supports recursive queries in the form of recursive common table expressions which make querying heirarchical data easier than in mysql and also give better performance"

from question  

MySQL - Best method to handle this hierarchical data?

"As i said postgresql is far superior and i hate mucking with mysql s bizarre bugs and i think that overall postgresql performance is probably better than mysql for any even slightly complicated query"

from question  

Choosing the right database: MySQL vs. Everything else

"The simple answer is that postgresql is better for both features and security;however mysql is much more popular so is more likely to be directly supported by a random application especially web applications"

from question  

What is the best DBMS for the job?

Fewer security roles

Example

"Traditionally postgresql has had fewer security issues than mysql but they are both doing very well on that"

from question  

PgSQL or mySQL is more secure?

"I would recommend postgresql for a beginner as postgresql has far fewer surprises than mysql"

from question  

For a beginner, is there much difference between MySQL and PostgreSQL

"I d have said that postgresql is more security aware than mysql supporting roles more authentication methods ... but that the database itself has generally a very limited impact on the security of an application"

from question  

PostgreSQL's Security Compared to MySQL, etc

Slower faster powerful

Example

"I ve found that postgresql is in my expirience is slower as mysql"

from question  

Which database should I use for home project use?

"Do you find rails with postgresql is slower than mysql knowing that it produce more query on the background"

from question  

Ruby on rails active-record generated SQL on Postgres

"In most regards postgresql is slower than mysql especially when it comes to fine tuning in the end"

from question  

MySQL vs PostgreSQL for Web Applications

"Unfortunately in postgresql select count is often slower than mysql to which it often get s compared to"

from question  

Index to get row count of read-only (immutable) PostgreSQL table?

"For these ultra simple queries postgresql can be slower than mysql - postgresql has richer planner that works better on more complex queries but on trivial queries is slower"

from question  

PostgreSQL vs MySQL simple query performance

"In my personal openion mysql is slower than postgresql and mongo db"

from question  

Can we use mysql with node.js

"Postgresql is already slower than mysql up to a certain point it is actually faster when you have a ridiculously large database"

from question  

Why is PostgreSQL so slow on Windows?

"I did a simple performance test and i noticed postgresql is slower than mysql"

from question  

PostgreSQL vs MySQL simple query performance

"In general postgresql knows more tricks for how to optimize complicated queries than the mysql optimizer does but it also relies heavily on your having given the optimizer enough data to work with"

from question  

Speed of IN keyword in MySQL/PostgreSQL

"Postgresql has more established support for this but mysql has played catch up in the last year or so and has a working method of this in the latest versions"

from question  

PHP and MySQL to design map search site

"I cannot propose any db not knowing your specific needs but if you want to use a free software which excludes oracle and you re not already experienced with mysql you should try postgresql which is more powerful than mysql"

from question  

Database (and ORM) choice for an small-medium size .NET Application

"The query optimizer in postgresql is more advanced than in mysql and copes with complicated statements much better especially when it comes to sub-selects"

from question  

MySQL or PostgreSQL for Hibernate + JPA2 project

"Postgresql is picky pickier than mysql -- all fields in the select list when using distinct must be present in the order_by and group_by clauses"

from question  

Rails 3, ActiveRecord, PostgreSQL - ".uniq" command doesn't work?

"Mysql s version is apparently marginally faster than postgresql but lacks some of the more advanced spatial features therefore it s pretty much limited to finding records that match a certain range of coordinates"

from question  

PHP and MySQL to design map search site

"Mysql i am told can be optimized to do faster reads than postgresql but both are pretty ridiculously fast in terms of # transactions sec they support and it doesn t sound like that s your problem"

from question  

Which db should i select if performance of postgres is low

"According to my own experience postgresql run much faster than mysql especially handling big tables 1.4 gb lineitem table in my case"

from question  

Why it is much slower to use mysql to add primary key onto tables than postgres?

"Mysql run 4x faster than postgresql"

from question  

PostgreSQL vs MySQL simple query performance

"Postgresql is faster than mysql s innodb"

from question  

What is the best DBMS for the job?

"Postgresql is much more complete and solid and will much better support complex queries and their optimization while mysql may shine in terms of retrieval speed for extremely simple queries"

from question  

Which is better platform for large scale database

"Postgresql is much more similar to oracle than mysql is"

from question  

Migration from Oracle to MySQL or PostgreSQL

"Postgresql is worth learning and much more advanced than mysql"

from question  

Rake aborted! no such file to load -- pg (Creating postgre database in rails )

"I need this query to both work postgresql and mysql due to requirements or i will need two queries if one query can t achieve this postgresql query has more priority so far i ve tried to use .extra syntax but it didn t work so asking it here"

from question  

Django performance issue with exclude

"Now for pre-production testings is mandatory use servers running together such as activemq rabbitmq mysql postgresql due this the pc goes slower even worst if sonarqube and jmeter are running"

from question  

Jenkins: Execute a job where the project/workspace is located on other machine (LAN Network)

"Postgresql is a lot more advanced when postgresql comes to sql features;things that mysql still doesn t have and postgresql has"

from question  

Postgres 9.1 vs Mysql 5.6 InnoDB?

"Postgresql is far more powerful and scalable and doesn t have mysql s silly limitations and gotchas"

from question  

Language best for a Photo-sharing site: PHP, Python, Ruby or something else?

"If you can not switch to postgresql try using innodb;1235 this version of mysql doesn t yet support limit"

from question  

Django ListView with subquery gives This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'

"Mysql is probably more often offered by shared hosting providers postgresql is probably a little more powerful"

from question  

* (no title is found for this review)

"Postgresql has full support for utf8;mysql doesn t support the complete utf8-encoding"

from question  

Are there any issues with MySQL's i18n(indic language) support?

"Postgresql has a richer set of abilities and a better optimizer;its ability to do hash joins often makes it much faster than mysql for joins"

from question  

Which is better platform for large scale database

"Postgresql fulltext;is about 10-100x faster than mysql fulltext is a lot more powerful gist is fast on inserts updates no problem with locks in other words it s a totally decent solution"

from question  

How much more performant is Postgres than MYSQL on fulltext search?

"My problem is similar with mysql select rows with more than one occurrence but i am using postgresql"

from question  

Select rows from joined tables with more than n occurrence

"Postgresql is more suitable for large-scaled websites althought they both work on large-scale;anyway mysql is faster"

from question  

Postgres SQL or My SQL

"Postgresql supports more advanced queries it performs better on complicated queries but is harder to manage;mysql is fast easy to manage but you can run into it s limitations on advanced queries stored procedures and the like"

from question  

For a beginner, is there much difference between MySQL and PostgreSQL

"I did some benchmarking 3 years ago may be stale... which showed that on large datasets basically postgresql fulltext is 10-100x faster than mysql and xapian 10-100x faster than postgresql but not integrated"

from question  

MySQL vs PostgreSQL? Which should I choose for my Django project?

"The reason is primarily optimizer maturity postgresql can better handle the kinds of queries you re likely to run;mysql is more likely to get confused on five-way joins go bottom up when you run a subselect etc"

from question  

Real-time data warehouse for web access logs

"But sometimes postgresql is faster than mysql or mariadb now i think i m doing wrong things."

from question  

How to structure large table and its transactions in database?

"However postgresql has more advanced features like partial or functional indices if you need mysql and postgresql"

from question  

Using Primary Keys as Index

"Other dbms for example postgresql wouldn t allow this query to execute at all;saying that how it works internally within mysql is just that you get a unique record for each posts.id but random values from potentially different rows for all non-aggregated and non-grouped column"

from question  

Should I use GROUP BY when I use IN clause?

"They are sufficiently similar that i d recommend starting with mysql but learning postgresql as well"

from question  

For a beginner, is there much difference between MySQL and PostgreSQL

"If you want to use a external database i would recommend you to import the shape file in postgresql and not in mysql since it has a more powerful support for spatial data;mysql supports several geometry functions for editing and querying spatial data"

from question  

Open "shape" attribute in mysql database

Sql server error

Example

"I totally understand the error and assume that the mysql implementation is less sql conform than the postgresql implementation"

from question  

Eliminate duplicate rows in a PostgreSQL SELECT statement

"Postgresql is stricter about conversions than mysql is and generally will throw an error rather than try to convert a string to an integer if it doesn t look like one"

from question  

Postgresql insert in PDO

"Postgresql is stricter to the sql standard than mysql is"

from question  

Rails PostgreSQL problems with order statement

"Mysql is more permissive and allows the non-standard use of distinct but postgresql throws an error"

from question  

Postgresql error with Rails 3 using order("RANDOM()")

"Poor performance from mysql has more to do with it not being smart and automatically creating an optimized plan like sql server postgresql or oracle would"

from question  

UNION SELECT MySQL query, do math and display in PHP

"From how i understand it postgresql is a more correct database implementation while mysql is less correct less compliant but faster"

from question  

MySQL vs PostgreSQL for Web Applications

"The question is is mysql somehow more resistant than postgresql to sql injection attack under the perl dbi and why might this be the case"

from question  

Is MySQL more resistant to SQL injection attack than PostgreSQL (under Perl/DBI)?

"08 00 00 time is how you do a type cast in postgresql not mysql;mysql uses the sql standard cast"

from question  

How to set default time for a TIME column in table MySQL 5.7?

"Postgresql s a lot more enterprise-ready than mysql not to mention that postgresql follows the sql standard a lot better"

from question  

Which open source database is the best option for an accounting-related system?

"Postgresql pl postgresql oracle s pl sql mysql s procedural dialect are somewhat similar to that but far from being compliant with the sql psm standard;i think the closest to the sql psm standard is db2 and maybe hsqldb sql in postgresql is not the same thing as sql per sql standard"

from question  

Are PL/pgSQL and SQL in PostgreSQL both at the same level as SQL/PSM standard, instead of as SQL standard only?

"If i were able to upgrade the server s versioning of mysql to 5.5 would innodb be a safer bet than postgresql"

from question  

CakePHP Database - MyISAM, InnoDB, or Postgresql

"Postgresql is a little more strict than mysql about type conversion and does not let you implicitly cast convert between numbers and strings"

from question  

Does this behavior exist in all major databases?

"There are client-server databases that you can use locally such as mysql faircom sql server postgresql and many others"

from question  

What is the proper way to handle concurrency with SQLite3 when writing data from an API?

"Some other databases oracle db2 postgresql have the function translate for it;unfortunately mysql does not support it"

from question  

Convert/encode string to numbers

"I d recommend postgresql s sql is much more ansi-compliant than mysql - so later using oracle sql server sqlite etc should be very straight-forward"

from question  

Which database should I use for home project use?

"You d be pretty safe with postgresql or sql server for instance;mysql - requires a bit more thought"

from question  

What's the risk of corruption/data loss with constant queries

"Postgresql does not comply with the standard here and folds everything to lowercase;for mysql there is no definite answer on how it does this"

from question  

How to retrieve column names from an in memory database?

"If you care about performance more than using eloquent then with raw queries in postgresql with returning clause or sql server with output clause you can return updated records in one go;mysql unfortunately doesn t have such support on a statement level"

from question  

Eloquent update and get record back

Weak better power

Example

"In the event of having to kill the server forcefully either by kill -9 or due to power outage postgresql generally has better resilience to table corruption;full support for acid compliance and other relational db features that support for again imho and experiance are weak or lacking in mysql"

from question  

Word game server in Python, design pros and cons?

"This is a weak point that iirc postgresql can handle better but with mysql you have to work around that by reverting the changes yourself in case of rollbacks"

from question  

SQL batch update - rollback on "CREATE TABLE"?

Compliant comfortable looks

Example

"Postgresql is more sql compliant than mysql"

from question  

PostgreSQL GROUP BY different from MySQL?

"Postgresql is more compliant but if you re comfortable with mysql and you re using an orm you should probably use that"

from question  

Database (and ORM) choice for an small-medium size .NET Application

"Looks like postgresql is a little more compliant than mysql so try this instead"

from question  

Select distinct returns nil (globalize3)

License bsd situation

Example

"Postgresql license bsd is undoubtedly more simple than mysql s"

from question  

* (no title is found for this review)

"That is another i reason i avoid mysql - the license situation is simply too unclear and vague for me;postgresql is more complicated to setup in an environment where you need a true cluster with load balancing read and write statements"

from question  

Chose free database management system for .NET Web Site

Amazon different compability

Example

"While creating aws aurora instance you must have chosen between amazon aurora with mysql compatibility amazon aurora with postgresql compatibility based on this you can choose between mysql on postgresql connector for debezium"

from question  

Debezium Connector for RDS Aurora

"The aurora it is completely different database than mysql but when it comes to the compability with mysql or postgresql amazon team did a lot so that there would not be a lot of differences"

from question  

MySQL compatibility on AWS Aurora

Table ancedotal servers

Example

"This is ancedotal but the postgresql servers i ve managed have always been much less troublesome than mysql which likes to randomly crash once in a while occasionally corrupting a table on the way down"

from question  

Why does Heroku use Postgresql?

"Not only does postgresql have a far more flexible indexing than mysql but the table approaches are very different also meaning the appropriate indexing strategies are as different as the tactics are"

from question  

MySQL Postgresql / PostGIS

Others

Example

Between the two i think postgresql is more suitable for a central data warehouse;mysql doesn t allow certain sql methods such as common table expressions and window functions

from question  

Which RDMS for Tableau connections?

Postgresql is more oracle-like in syntax and in some of the features indeed it has been occasionally called poor man s oracle;mysql i am not sure what to compare to

from question  

Can an open source databases like MySQL support my web site's load?

Postgresql is more developer friendly and makes it easy to do the right thing regarding data integrity by default;if you give mysql an incorrect type it will implicitly convert it even if the conversion is incorrect

from question  

Are the consistency/data loss/query optimization issues I read about "that bad"?

So in your case the insert statement should look like this further reading mysql docs and example similar article for postgresql contains a better explanation of potential problems

from question  

How to insert date mysql python telegrambot

Using stored procedures helped out regarding structuring the project but performance actually got a little worse this was at the time stored procedures was a new feature in mysql;postgresql performs better with complex queries in my experience but writing real graph queries for it isn t really possible read here and here for why this is so

from question  

How should I store non-tree hierarchical data (i.e. any generic graph)?

Drupal 7 mysql 5.0.15 or higher with pdo postgresql 8.3 or higher

from question  

How to make Drupal work without PDO

With django it is easy to use postgresql instead of mysql so i tried it with the same query and same data in db postgresql is much faster that mysql x10 more faster while using inner join analyse shows it uses indexes unlike mysql

from question  

Slow MySQL "INNER JOIN"

If you want open source postgresql is much smarter than mysql as well

from question  

Optimising MySQL queries across hierarchical data

Cleardb mysql database does require more effort than using the default postgresql database though but this guide might help

from question  

How to configure mysql2 database in heroku

I know postgresql could be considered more mature than mysql with regards to locking thanks to mvcc - can i use row-locking or some other feature in postgresql instead of the token field

from question  

Concurrent processes working on a PostgreSQL table

B use indexes - postgresql has bigger repertoar of indexes then mysql so use it - there are gist gin indexes

from question  

Postgresql Select * from table performance vs MySql

An example of what s possible in postgresql 11 but not mysql 8 is this with t v as values 1 1 3 5 5 5 6 select v array_agg v over o groups between 1 preceding and 1 following exclude current row as current array_agg v over o groups between 1 preceding and 1 following exclude group as group array_agg v over o groups between 1 preceding and 1 following exclude ties as ties array_agg v over o groups between 1 preceding and 1 following exclude no others as no_others from t window o as order by v yielding i ve blogged about these postgresql features more in detail here

from question  

Which database has more coverage for window functions MySQL 8.0 or PostgreSQL 10?

Postgresql is older than mysql so it might have influenced them

from question  

Why the \G in SELECT * FROM table_name\G?

If you are looking for location based queries in relational databases postgresql is more matured compared to mysql

from question  

Query a location database based on the user's current location

Why postgresql is more capable than others mysql etc. on django

from question  

Why Django prefers Postgresql?

As for reliability i think that postgresql is more reliable especially when compared to mysql using myisam - innodb is a lot better here

from question  

MySQL or PostgreSQL for Hibernate + JPA2 project

Mysql is more than capable of serving your needs as well as alex s suggestion of postgresql

from question  

Upper Limit for Number of Rows In Open Source Databases?

Following the first answer it appears that postgresql is more compliant to sql standard than mysql so it needs a group by clause for each selected column you want to display with your aggregated function

from question  

How to sum through multiple has_many associations?

Does that mean perhaps rails team favor postgresql slightly more than mysql

from question  

Can Ruby on Rails 3 work with MySQL on Windows 7?

I had mentioned that in our rails application all select queries dropped below 100ms after switching to postgresql whereas some of the complex joins generated by activerecord would occasionally take as much as 15s or more with mysql 5.1 because of nested loops with inner table scans even when indices were available

from question  

MySQL not using indexes with WHERE IN clause?

If you want to use sqlite you need to store your application in your openshift_data_dir but we recommend using mysql or postgresql instead so your application can be scaled if you want your application to

from question  

Rails, Database reset on Git push

See if mysql does not have rules about which ips can talk to it i known that postgresql have this feature do not know if mysql does;check that mysql does not have something like drop iddle connections.

from question  

Hibernate loses connection

Postgresql is also open source like mysql but far more featureful and supports check constraints;one big difference is that mysql does not support check constraints which is an important part of maintaining database integrity

from question  

Oracle vs MySQL in context

Option 2 postgresql;mysql has the larger user base but fewer features

from question  

Best open source database for large web based application

I have never used postgresql myself but i think postgresql s mostly a matter of taste whether you prefer postgresql over mysql

from question  

Is a PHP, Python, PostgreSQL design suitable for a business application?

The specific reason why the error occurs is because the column sort_order is not in the result set so postgresql cannot resolve it;mysql is much more flexible and incorrect about how it handles aggregation so it allows constructs such as this order by which would cause an error in any other database

from question  

PostgreSQL: Column must appear in the GROUP BY clause or be used in an aggregate function

According to the above mario s post postgresql does not allow using the same connection for more than one thread;i am wondering if the mysql is the same plus mysql may put lock while accessing it

from question  

Create Object With Parallel Gem

I d personally recommend using postgresql as postgresql has a cidr data-type and powerful functions to go with postgresql but there s an interesting discussion on doing similar things in mysql too

from question  

Check if IP is in CIDR netmask (range)

Otherwise i recommend using postgresql over mysql since afaik is more standards compliant and has a nicer license

from question  

Alternative to SQL Server for a simple web app

Depending on what query you make like queries that match at the beginning of the column may use indices in postgresql i know for sure that they do;in mysql i m not sure

from question  

How to implement faster Search As You Type (SAYT) api in Rails 3 application

We recommend using mysql or postgresql

from question  

Running airflow tasks/dags in parallel

While mysql has a larger user base postgresql is gaining more an more popularity ever since implementing several crucial features that were missing in earlier versions

from question  

What are the open source tools and techniques to build a complete data warehouse platform?

However mysql has imo more user-friendly admin tools see mysql gui tools that you may like if you aren t familiar with the command line;if you are interested by a comparison between mysql and postgresql check mysql vs postgresql from wikivs the open comparison website

from question  

What is a good free RDBMS solution for a small web project that may grow large if successful?

Pl postgresql is actually a nice language + you can use many other languages;mysql doesn t have sequences so if you need them you have to roll your own

from question  

Are the consistency/data loss/query optimization issues I read about "that bad"?

For example pyqt is already available for python 3 as well as 2 and you can use postgresql a splendid open-source sql database engine much more standard than mysql via py-postgresql

from question  

Will Python 3 ever catch on?

Since postgresql is a lot more sane than mysql there are not that many tricks to report on

from question  

Hidden Features of PostgreSQL

Postgresql error more than one row returned by a subquery used as an expression mysql subquery returns more than 1 row

from question  

Explanation of IN operator

I am a microsoft fan but mssql server costs much more than postgresql or mysql

from question  

Best database type to store data that will be used with a blockchain?

Postgresql doesn t know float but float4 and float8 which are synonyms for real and double respectively;mysql technically knows float but that doesn t mean the db-migrate abstraction will accept is as input when run .

from question  

Using unknown data type FLOAT

Postgresql has a native boolean type where true is represented by the string literal t and false by f there are other literals but those are the most common ones;mysql doesn t have a native boolean type and uses c-style integers for booleans instead

from question  

Rails scope with where = false, work differently on heroku

Usually mssql oracle postgresql etc. this problem can be solved with the help of dense_rank function;but since mysql doesn t have window functions you can do something like this

from question  

Get 2 rows for each distinct value in column

All that said postgresql is much more acid compliant than mysql it handles fks just as you re needing and i would generally recommend it based on what you ve expressed in your post

from question  

Postgresql vs mysql in ease of scaling, and usefulness for highly relational (tons of foreign keys) databases

Note i m not saying mysql s license won t work for you but postgresql is definitely simpler

from question  

* (no title is found for this review)

Also look at the native postgresql types point lseg box path polygon and circle if you want to understand more about how postgis works and why its 2d feature implementers have a shorter row to hoe in general;mysql does not implement a lot of spatial queries -- i don t know for sure about contains but there are ways of approximating it and other functions

from question  

MySQL - Geo-Spatial Object

Ostgresql timestamp is not unix timestamp and mysql s unix timestamp is not postgresql s or oracles timestamp;postgresql timestamp gets harder to port if you use database timestamps

from question  

Timestamp Difference In Hours for PostgreSQL

May be postgresql takes less time than mysql

from question  

Select takes long time. How to solve this problem?

In fact this presentation which still refers to an older incomplete version of mysql s opengis support suggests that with proper indexing some mysql geospatial actions may actually perform better than postgresql postgis though i m sure that s up for debate

from question  

Import OpenStreetMap-Data (OSM-File) to a MySQL-Database / SQL-File

Fyi postgresql scales better than mysql on multi-processor overlapping requests from a review i was reading a few months back sorry no link

from question  

Upper Limit for Number of Rows In Open Source Databases?

Triggers in postgresql have a syntax a bit more complex than mysql because mysql execute procedures as the action

from question  

Update different table when row inserted

I m sorry to say this and maybe i m not solving your problem exactly but postgresql is 10 years older than mysql and is extremely advanced compared to mysql and there s many ways to achieve this easily

from question  

MySQL - Rows to Columns

Bonus tip avoid mysql;postgresql is better in nearly every respect

from question  

Ruby, RVM, LLVM and MySQL

I wonder why postgresql s single insert statement is completely faster than mysql s when autocommit is turned on

from question  

Why postgresql's single insert statement is faster than mysql?

Some recent tests we did showed that postgresql does perform faster than mysql and we believe the table partitioning feature in postgresql will be very important with a table in our database we foresee to grow into 100 million rows and more in production

from question  

(Fluent)NHibernate and PostgreSQL 9

I would choose postgresql over mysql

from question  

Django build video website similar to YouTube

Mysql i wouldn t recommend because you are really tying everything to one app only that can write to the db sql mode soup means relations are basically a private api instead of the public api they are in postgresql firebird and ingres and this means less flexibility down the road;however with postgresql you get a top-notch extensible development platform in a box

from question  

Which open source database is the best option for an accounting-related system?

It may be an option to migrate to 4.0 ee first migrate the db to postgresql which is closer to oracle than mysql and finally upgrade to alfresco community 4.2.f latest versioning with web services api

from question  

Downgrading from Alfresco Enterprise to Alfresco Community

Postgresql s traditionally had a more complete feature set in terms of acid compliance support for advanced queries etc than mysql postgresql has solid windows odbc drivers and postgresql documentation scrupulously points out any areas in which postgresql deviates from the sql standard

from question  

What do you think of Postgres and Firebird Databases?

I don t think that postgresql will affect your performance despite postgresql uses more resource since postgresql a full rdbm implementation in the long term postgresql will be the best option if you are looking for performance;number of sql queries is relative you must remember that to bring same results mysql and postgresql has their own implementations just to give an example mysql dont implement the full ps sql

from question  

Ruby on rails active-record generated SQL on Postgres

You have to use an other database like postgresql to get real blob support sorry;i do not know which client api you use but when trying to use blobs from own java and objective-c clients it seems mysql does not really support streaming of blobs

from question  

Handling of huge Blobs in MySQL?

Mysql answers will be quite different than postgresql answers

from question  

When insert some records in database-1->table-1 then same records should be insert in database-2->table-2 how to do this?

Unfortunately the mysql version isn t fully supported by django and you will need third party libraries;of the two postgresql has the richer set of functionality and provides better indexing options

from question  

Django and eBay style multi listing

For postgresql i do not know;for mysql please see the load xml syntax docs

from question  

Automated way to convert XML files to SQL database?

Now coming to second question based on pricing as you can see from mysql pricing page and postgresql pricing page mysql is bit cheaper than postgrsql reading on the answer you can make informed decision what would be best for you

from question  

AWS RDS MySql or Postgres - performance wise and cost wise?

Summa summarum postgresql probably is more ready for primetime than sql-server;- postgresql has has had paging for almost 10 years now mysql as well as sql-standard syntax compliant sql server just got that feature with sql-2012 only standard-compliant

from question  

SQL Server 2008 r2 or PostgreSQL

Current versions of mysql has not good planner as postgresql has there is progress - so complex queries are usually much better on postgresql - and really simple queries are better on mysql;complexity of postgresql configuration is myth

from question  

What data quantity is considered as too big for MySQL?

You will find postgresql is much more enterprise-oriented than other products such as mysql

from question  

I dont know how Postgresql created user on my mac

I agree with denis postgresql is a good choice and is definitely a lot stronger on the sql feature side than any other open source dbms and rivals the big ones as well;mysql has been easier to setup in a high-availability master slave environment but the game has changed with 9.0 and will change even more with 9.1 and synchronous replication which is more or less the same as oracle offers with it s data guard

from question  

PostgreSQL vs MySQL when tying into an android/iphone app

For that to work the database postgresql must have the correct encoding set see the first two references;note mysql handles collations much better so if you aren t too far along and you require multiple collations then it may be a good idea to switch

from question  

How to insert Japanese text into a Postgres table using PHP?

Sqlite is for local site and postgresql is very populare but i think it s just a choice;if you want to use mysql it isn t a problem

from question  

Which database is recommended to use with Ruby on Rails? (Considering hosting offers)

Other dbmss like postgresql have non-redundant enums so the following might not really apply to your situation;mysql enums cannot be applied in every situation anyway

from question  

JPA Lookup table design

At the load levels where postgresql s better locks overtake mysql s other parts of your platform could be the bottlenecks;postgresql does comply better with standards so it can be easier to replace later

from question  

Where to find a good reference when choosing a database?

Quoting is different mysql uses backticks for quoting identifiers whereas postgresql uses double quotes;like is case insensitive in mysql but not in postgresql

from question  

Switching from MySQL to PostgreSQL for Ruby on Rails for the sake of Heroku

Back to Home
Data comes from Stack Exchange with CC-BY-SA-4.0