On Aug 31, 2010, at 5:43 PM, Christian Fazzini wrote: > Just thinking out loud. about switching from pgsql to mysql. So far,
I wouldn't. > haven't experienced any differences between the two databases. I've Try inserting an invalid date into each database. See what it does. Unless it's changed mysql will insert it as 0000-00-00. PostgreSQL will give you an error. I think mysql will set a warning, but it will still do the insert. Create a VARCHAR(100) field. Now stuff 101 characters into it. MySQL will truncate the data. PostgreSQL will give you an error. You might be lucky and never run into these but they are a PITA when you do. > 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. Not sure how old these are, but might be interesting... http://sql-info.de/mysql/gotchas.html http://sql-info.de/postgresql/postgres-gotchas.html Awhile back I had the exact same Rails site running on MySQL and PostgreSQL. Database created via Rails migrations. Data inserted via the same load scripts. Identical in every way. A query that joined two tables of about 30K and 100K rows respectively took 30 seconds in MySQL. It took <1 on PostgreSQL. I was floored. The reason? The conditions were complex enough that MySQL wouldn't use all the available indexes. This is a fairly well known problem. And it can be a killer. What good are creating indexes if it won't use them? (for the record I may have some of my numbers wrong, but it was an incredible difference and the explain/analyze output clearly showed mysql wasn't picking up indexes that were available). > What are you thoughts Don't change. Write a letter to Sequel Pro and tell them you'd like them to support PostgreSQL :) -philip -- 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.
