Jump to content

The ultimate community for Ruby on Rails developers.


Photo

PostgreSQL vs MySQL

mysql postgresql database question

  • Please log in to reply
12 replies to this topic

#1 MrPepper

MrPepper

    Dispatcher

  • Members
  • 32 posts
  • LocationEast Coast

Posted 22 August 2013 - 10:02 PM

I have been looking this up and have seen a few videos of exactly what this title of this says.. BUT

 

What is your opinions? What do you use for your apps? Stability?



#2 AstonJ

AstonJ

    Dispatcher

  • Members
  • 35 posts

Posted 22 August 2013 - 11:42 PM

Postgres - it's just really nice - secure, fast, n full of features :)


:)


#3 MrPepper

MrPepper

    Dispatcher

  • Members
  • 32 posts
  • LocationEast Coast

Posted 23 August 2013 - 04:10 AM

I have seen a few videos of them two together.. was quite interesting as I have always used MySQL and turned away from PostgreSQL for no reason..



#4 Kelli Shaver

Kelli Shaver

    Inspector

  • Administrators
  • 76 posts
  • LocationKentucky

Posted 31 August 2013 - 05:14 AM

I prefer Postgres, but I usually end up using MySQL because most of the stuff I do gets deployed to an AWS stack and RDS does not support postgres. *muttergrumble*



#5 james

james

    Guard

  • Members
  • 223 posts
  • LocationLeeds, U.K.

Posted 31 August 2013 - 08:02 AM

Oooh! Is this one of those mine is better than yours threads? Personally I prefer MySql but I think that is mainly because I worked for years with that horrible MS product that you are no doubt familiar with.

Actually Postgres has improved massively over the years and is now probably a better product (despite it's quirks) the MySql.

 

Having said that since the Oracle debacle and the buy out of the Sun Systems products (How can you buy open source stuff, Someone messed up big style with the licensing on that!) MySql seems to be going backwards rather than forwards and I'd like to put a vote in for MariaDB https://mariadb.org/ It seems to be going from strength to strength but not many hosting companies seem to be proviing this as an option yet, although I'm sure it will happen. Of course if you have a host that'll allow you to provision your own database then it's gotta be worth looking at.


  • Jamie likes this
Programming is just about problem solving!

#6 Funnyvibe

Funnyvibe

    Signalman

  • Members
  • 17 posts

Posted 01 September 2013 - 02:36 AM

For the most part from a typical rails developer point of view, you really rarely will notice the difference between the two products from an api standpoint. It really depends on the environment you are deploying in. Even so, all of my projects run on postgres and could easily be configured for mysql in a heart beat. And the majority of them actually have in the past before I was graced with heroku. This really comes down to a different strokes for different folks discussion that doesn't make a difference in this humble developers opinion. Sure there are political aspects to consider, but in the real working world you really just have to learn to work with and love both. =) Oh and that being said, postgres has always been more stable for me, but less supported.

#7 mark horrocks

mark horrocks

    Passenger

  • Members
  • 4 posts

Posted 29 September 2013 - 01:20 PM

I like postgres and used it for over 5 years now. I recently changed servers and was easily able to migrate my data to my new server with this single command.

 

pg_dump -C -h localhost -U postgres myapp_production | psql -h 111.22.33.44 -U postgres myapp_production


  • james likes this

#8 james

james

    Guard

  • Members
  • 223 posts
  • LocationLeeds, U.K.

Posted 01 October 2013 - 06:32 AM

Welcome back to the forum Mark :)


Programming is just about problem solving!

#9 RubyOnTop

RubyOnTop

    Passenger

  • Members
  • 4 posts

Posted 29 August 2014 - 09:57 PM

I have only used mysql because its always featured in the tutorials I've been learning with. What do you recommend?



#10 yigitsadic

yigitsadic

    Passenger

  • Members
  • 3 posts
  • LocationTurkey

Posted 16 October 2014 - 11:58 AM

My vote goes for Postgresql. You can do more flexible things with it.



#11 EmilieIsaksen

EmilieIsaksen

    Passenger

  • Members
  • 2 posts

Posted 13 February 2015 - 06:41 AM

MySQL vs PostgreSQL is a decision many must make when approaching open-source relational database management systems. Both are time-proven solutions that compete strongly with proprietary database software. MySQL has long been assumed to be the faster but less full-featured of the two database systems, while PostgreSQL was assumed to be a more densely featured database system often described as an open-source version of Oracle. MySQL has been popular among various software projects because of its speed and ease of use, while PostgreSQL has had a close following from developers who come from an Oracle or SQL Server background.



#12 blueicefield

blueicefield

    Passenger

  • Members
  • 3 posts

Posted 27 April 2015 - 02:12 PM

I prefer Postgresql because of the support of transactional DDL.



#13 jefflunt

jefflunt

    Guard

  • Moderators
  • 157 posts

Posted 27 April 2015 - 06:40 PM

PostgreSQL. And Amazon RDS recently introduced RDS for PostgreSQL.







Also tagged with one or more of these keywords: mysql, postgresql, database, question

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users