MySQL vs PostgreSQL -- Choose the Right Database for Your Project

Top Rock Photography

Great article. I almost did not read it through, because of an early error, making me consider the source. Glad I read it. Thank you.

Per that error; Postgres and PostgreSQL are two different things, one of which is mostly dead. Postgres was acquired by IBM, developed for awhile, then abandoned, as features were added to DB/2. (The IBM cloud now offers both DB/2 and PostgreSQL as options). Berkley had sold Postgres to IBM in 1994 when they moved on to Postgre95. Then they moved on to PostgreSQL.

Yes, many people do say, Postgres, (and PostgreSQL has finally recognised this, [July 2018], apparently abandoning their past stance of insisting that it only be called, “Postgre-Es-Queue-El”), but it does not make it any more right than people (like me), who say, “Sequel,” and not, “Es-queue-el.” (Sequel was again, indeed, a totally different product, doing something quite similar).

For the most part, though, I generally only hear the term “Postgres,” when used along with the term, “NoSQL,” (as in, “Postgres NoSQL,” something else which does not really exists), to refer to the JSONB, and other non-ANSI-SQL compliant datatypes and functions of today’s PostgreSQL.

Nevertheless, in an education setting, the correct terminology ought to be used.