Slashdot Mirror

← Back to Stories (view on slashdot.org)

Why I Choose PostgreSQL Over MySQL/MariaDB

Posted by timothy on from the semi-religious-wars dept.

Nerval's Lobster writes For the past ten years, developers and tech pros have made a game of comparing MySQL and PostgreSQL, with the latter seen by many as technically superior. Those who support PostgreSQL argue that its standards support and ACID compliance outweighs MySQL's speed. But MySQL remains popular thanks to its inclusion in every Linux Web hosting package, meaning that a mind-boggling number of Web developers have used it. In a new article, developer David Bolton compares MySQL/MariaDB 5.7.6 (released March 9, 2015) with PostgreSQL 9.4.1 and thinks the latter remains superior on several fronts, including subqueries, JSON support, and better licensing and data integrity: "I think MySQL has done a great job of improving itself to keep relevant, but I have to confess to favoring PostgreSQL."

7 of 320 comments (clear)

  1. At least by Anonymous Coward · · Score: 3, Funny

    It's not Access

    1. Re:At least by HornWumpus · · Score: 3, Funny

      If Excel is using the old jet engine you get both in one deal.

      The worst stack I've ever seen. ASP invokes Access (via OLE automation) which in turn calls FORTRAN. I will smoke a turd in purgatory for showing them how to invoke Access.Application from VB.

      I quit in disgust shortly after. 'They' were supposed to define an API without knowing it, so we could replace the Access part. Management said: 'It's working, great lets move forward.'

      --
      John McAfee 'It was like that time I hired that Bangkok prostitute; to do my taxes, while I fucked my accountant'
  2. I thought we were over the whole SQL thing by i_ate_god · · Score: 2, Funny

    Isn't everyone all NoSQL nowadays or has that faded away?

    --
    I'm god, but it's a bit of a drag really...
    1. Re: I thought we were over the whole SQL thing by Anonymous Coward · · Score: 3, Funny

      NoSQL only caught on with dumbasses. Everyone with a brain ignored it.

    2. Re:I thought we were over the whole SQL thing by ArcadeMan · · Score: 4, Funny

      Nope, we all moved to XML.

      --
      Get free satoshi (Bitcoin) and Dogecoins
    3. Re:I thought we were over the whole SQL thing by Anonymous Coward · · Score: 5, Funny

      I moved all my XML into JSON, then stored it in a MySQL table named "JSONXML" with a single column named "data". I call it "web 3.0 agile database". I'm in the process of writing a manifesto and bunch of books about it.

  3. Re:I choose MS SQL Server by Foofoobar · · Score: 2, Funny

    Yeah and it runs GREAT on Linux. Like a rock.

    --
    This is my sig. There are many like it but this one is mine.