8

PostgreSQL or MySQL ?
And why?

Comments
  • 2
    Mysql for personal use, postgre for professional. The reason is time and availability
  • 1
    @RazorSh4rk so let say i build a project for client, which one is better? How is compatibility for cheap shared hosting?
  • 1
    @Letmecode yeah, mysql is mariadb now, but i just want to know what is better for real life
  • 1
    I like the JSON-Handling im Postgres very much 😀👍
  • 0
    @vannrith every hosting has mysql honestly, its fine for small to medium dbs
  • 3
    PostgreSQL, because fuck Oracle.
  • 0
    @3141 legit 😂
  • 7
    Haven't used it but I have a stress ball heheh
  • 0
    PDO! Then it doen't matter, right?
  • 0
    @Kaji J/K, I still use a MySQLi object because I still haven't taken the time to figure out PDO...
  • 0
    pg because gis
  • 2
    Use sqlite if you can get away with it. (Used far too little while often being the simplest and fastest solution). Use MonoDB when when you mostly have fieldable entities. Mariadb and Postgre are usually dictated by the ecosystem. Most php web applications use mysql(or Maria) so probably easier for other developers. Postgre is nicer as it is a bit more standards compliant.

    @Kaji PDO is php specific and does no abstraction to speak of. So queries with mysql functions won't work on Postgre or sqlite. Probably best to use an ORM if you want to be able to stay DB agnostic, else you have to be very careful.
  • 2
    Postgres. Automatic setups are easier. Better performance. Sticks to standard SQL. More features.
  • 0
    @Letmecode i worked with a guy who was a long time database sme and he said his favorite was postgres as well. He was massively smart and I trust his opinion but he never really elaborated why. What is it about postgres that draws you? Is it faster or more stable. Is the SQL in postgres more standardised?
  • 0
    @Letmecode awesome thanks.
  • 0
    Just posted a personal experience of this on an other rant, hold on a sec
  • 1
    There you go
  • 1
    @omomthings wow. That is a drastic improvement
Add Comment