Christian Fazzini wrote: > Just thinking out loud. about switching from pgsql to mysql.
You would be making a huge mistake. > So far, > haven't experienced any differences between the two databases. That's nearly unbelievable unless you haven't been using either much, or unless you've been using the most absolutely basic features. > I've > been using mysql for the past few years. I like it more because am a > mac interface junkie and mysql has sequel pro. Not that this is a > determining factor. But pgsql also has navicat (in my opinion, not as > good as sequel pro). Don't choose your DB server based on pretty graphical clients. MySQL is far inferior to Postgres in virtually every respect. Postgres performs better, lets you have referential integrity along with a fast storage engine, and is more extensible (PostGIS would not be possible in MySQL, for example). I think MySQL is *still* too brain-dead to scan table indices backwards, and its procedural language (if you ever need it) is so bad as to be nearly useless. Also, Postgres' syntax adheres more closely to the SQL standard. MySQL's advantages over Postgres include ease of setup and (so I've heard) clustering...and that's it. For most projects, it is a mistake to choose MySQL over Postgres. > > The more important thing is, web hosts that I have spoken to have said > that pgsql takes up a considerable amount of RAM than mysql... Never heard this. > More > RAM on a web host means more $$$. So configure your Postgres install to use less RAM. Or use Heroku, which has Postgres ready configured. > > Moreover, since I've switched from Symfony PHP. Most of my other web > projects will be hosted with a mysql db. That's just compounding the mistake. :) > > I am sure there may be other more significant differences. But for my > every day use as a web developer, I don't really notice the internal > features that pgsql has over mysql. > > What are you thoughts You'll notice the difference as soon as you try to do something non-trivial. Stick with Postgres. It's by far the better product. The fact that the differences are under the hood doesn't make them less important. There are also no commercial entities causing uncertainty as to its fate. Best, -- Marnen Laibow-Koser http://www.marnen.org [email protected] Sent from my iPhone -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
